You can set conditions on what records are accessible based on certain values in Airtable. For example, ensuring that users can only edit their records once or users can't edit the form when it expires. You can come up with your own rules that will disable the form when these conditions are not met. There are a few options to achieve this, depending on your use case.
You can set a custom message if the conditions are not met.
1. Prevent re-login after user submission
If the login page option is enabled (under How do users access their records? in the Share section), lock the form so they can't access it again.
Form settings
Share section
Turn on Conditional Login and set the conditions*
*Note: The condition should not be based on a linked record getting created. Follow this link to learn why.
2. Prevent loading the form
In this option, the user won't be able to open the form and it'll be completely blocked.
These options are only available for standalone forms, not child forms (i.e. forms used in a portal or shared view or for linked record fields in a main form).
Option A: Only allow updating existing records based on conditions
Form Settings
Share section
Turn on Allow users to update existing records toggle
Turn on Only allow users to view existing records if conditions are met toggle
Add Condition(s)
Option B: Lock the form after submission based on conditions
Form Settings
Share section
Turn on Allow users to update existing records toggle.
Turn on Lock the form after submission toggle.
Select a checkbox field for Field used for locking
The check box field will be checked after form submission so when the users try to reload the form, it will not be accessible.
💡 Note: this option will not be available if Allow users to submit another form or Allow users to copy submitted record to a new form are enabled
Option C: Disable the form at a scheduled date
Form Settings
Share section
Turn on Disable form at scheduled date toggle
Set a date and time
You can also set the date to be pulled from an Airtable field instead of setting a static date, by switching the Date Source
Optionally, you can edit the message shown to your users once the form is disabled.
💡 Note: you can configure the timezone using the selector on the right side of the date.