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

Restricting Times Where Form Can Be Completed

Topic Labels: Views
352 2
Showing results for 
Search instead for 
Did you mean: 

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?


2 Replies 2

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.

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.