Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 01, 2022 02:05 PM
Hello - I am using the amazing pre-filled form extension by @kuovonne to pull form data entered into one table that is then updated with a pre-filled form.
The only issue I am having is the date field from the original entry is moved back by one day when the pre-filled form is created (and then updates a new record with the wrong date).
I have tried looking at the time zone settings, but have had no luck. Is there any thought about where the fix might live?
Thank you!
Solved! Go to Solution.
Nov 05, 2022 02:02 PM
This is often a timezone issue.
If this is a date only field (with no time), try prefilling with DATESTR({date field})
instead of just the date field.
Nov 05, 2022 11:32 AM
I have had the same issue. @kuovonne do you have any insight about this? Help please!
Nov 05, 2022 02:02 PM
This is often a timezone issue.
If this is a date only field (with no time), try prefilling with DATESTR({date field})
instead of just the date field.
Nov 05, 2022 05:11 PM
Ah, yes, this did help! But, we are using the pre-filled form to allow users to come back and edit their previous submission, so, initially the date fields are all blank, and some may remain blank. Adding DATESTR({date field}) did not work when the date field was blank - I had to add:
IF({date field}, DATESTR({date field}))
I had noticed, though, that when I used the same field in an automated email, clicking on the link in the email showed the correct dates in the pre-filled form, while using the link out of the table subtracted a day. Either way, the dates in the URL did not match the dates showing on the form. For example:
Also, in the automated emails showing the list view of all the responses, the dates show up with a time zone which I cannot change. I don’t even want it to show, but if it had to show I’d at least like it to be correct. Do you know any way around this?
Thank you!
Nov 07, 2022 06:46 AM
Thanks, @kuovonne! That worked for me!
Nov 07, 2022 11:14 AM
@Summer_Schedules There are many moving parts to your system, including the form itself, the prefill formula, the automation email, the timezone of the field, the timezone of the computer where you are viewing the form, and the actual time. If you have a date/time field versus a date-only field, you have even more complications. When you adjust one aspect it often has slight ramifications on the other parts of the system. And timezones are notoriously difficult to deal with.
Here are some general guidelines: