Jun 14, 2021 04:44 PM
Hi - I am new to Airtable and am looking to create a form that can only be completed by personnel during business hours ie: 9-5pm on Weekdays. Is there a way to automate these date parameters within Airtable?
Thanks!
Jun 15, 2021 01:26 PM
There is no function within AT that will use criteria to allow / disallow access to a data entry form.
You would be far better off using HTML and your code of choice to have a web page perform the logic over timing/day of week, then link to the form if the criteria are met.
Jun 15, 2021 02:35 PM
You cannot restrict an Airtable form by time of day. A workaround is to have a warning that any entries entered outside of the specified time will be automatically deleted. Then automatically delete them using a scripting automation. Note that when you calculate when the record was created, you must take the timezone into account.