I’d be grateful if someone could show me how to add a new field which will calculate the number of days from an existing field which gives a start date of a ser vice commencing.
I need to be able to calculate the number of days from that date to now.
many thnaks
Hi David,
This is the formula you want:
DAYS(Start Date; NOW())
Make sure Tap Forms returns a Number value for the formula. If on iOS, the Start Date would have square brackets around it when you choose it from the Fields list (e.g. [Start Date]
). On Mac, just double-clicking on the field in the Fields list will insert a field token for you into the formula.
Thanks!
Brendan
Hi there,
,amy thanks for your reply.
I’m still not sure how I construct the script in the box to make this script work.
I keep getting error repsonses.
Could you show me where the field I want to use as a start date (on line 2) should sit within this script.
many thanks
Attachments:
You must be
logged in to view attached files.
No need to reply. I got it to work. many thanks.
Hi David,
I’m glad you got it working now.
You were mixing a Script field with the Calculation field formula I provided.
Thanks,
Brendan