Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
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.