Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Timezone not Populating in Fillout PDF correctly

Topic Labels: Formulas
690 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaits7887
4 - Data Explorer
4 - Data Explorer

I created a form for our rental car contract in Fillout. Everything is populating correctly into airtable except the time. My issue is that I put the "date - time out" in the form eg 12/19 8:00pm. It will populate to airtable as 12/20 3:00am if I have the airtable time set to UTC. if I change the time in airtable to Denver (which is correct) it populates properly from fillout to airtable. HOWEVER, when I open the PDF everything in changed back to being a day in the future at 3:00am. I think it will work properly if I create seperate fields for date and time, which I can do, but it seems like it should be able to work by doing it the way I am. I'm sure this is a timezone code I cant for the life of me figure out. Please help, Thanks!

2 Replies 2

Try creating separate Date and Time picker fields and use those for the Fillout PDF?  You'll then need to combine that data together into a datetime with a formula field in Airtable though

typeflow
6 - Interface Innovator
6 - Interface Innovator

With Typeflow.us, you can generate PDFs based on Airtable (we use Google Docs for templating !), but we consider the date formatting from your Airtable table in the PDF generation. So no need to add new fields for Date and Time. 
We currently have a lifetime plan at 150$ with unlimited PDF generation too.

I'm happy to help you set things up if needed!