I am using Airtable as a Health and Safety Database for my Organisation.
I have one Table to record all the Prestarts my teams do, regardless if they are electronic, by paper, or a mix. (Prestarts)
I have another Table that essentially is a form for the Electronic Prestart. (Prestart Form)
I also have an Automation set up that when a new record is created in Prestart Form, it creates a new record in Prestarts, and inserts the data such has Date, Site, Team Leader.
This is working well with the exception of the date that is created in Prestarts is a day behind. I could just change the date manually… but that defeats the purpose…
(Initial Form that is filled out)
(Table Created from form)
(Prestarts Created Entry)