Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 14, 2021 10:43 AM
Desired outcome: When someone enters our blood donation center (no appointment needed) the front desk looks them up in the donors table and changes their “last visiting date” to today. I want to add a record that shows their new visit and insert the changed date into a date field in a (growing) “visits” table.
I created a simple automation: When record is updated in “donors” table, create new record in “visits” table.
Date Field to watch: “visit date” (this is the last date a visitor arrived)
Action: Create new record in different table and add “visit date” into date field.
Weird/unexpected behavior: the date added is 1 day earlier than the chosen date.
Solved! Go to Solution.
Jun 17, 2021 09:59 AM
Jun 16, 2021 08:12 AM
Hi @Tom_Steenhuysen and welcome to the community!
I know that the difference in timezones between data storage in Airtable and what you get to see visually, can differ and have that effect.
Check this post for example.
Jun 17, 2021 09:59 AM