Help

Restricting Times Where Form Can Be Completed

Topic Labels: Views
802 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Chase_Thompson
4 - Data Explorer
4 - Data Explorer

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!

2 Replies 2
Jon_Stephenson
7 - App Architect
7 - App Architect

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.