The form extension allows you to restrict submissions when specific conditions are met. By using an auto-number field and the Save & Continue mode, you can track how many submissions have been sent. New submissions that exceed the limit can be separated into a different view, and the user will be informed that their submission is invalid.
To set up the condition, you will need a formula field that reflects the value of the auto number field. Type the name of the auto number field as the formula. The purple color will indicate that the field is recognized:
Activate the Save & Continue mode in the Save & Continue section. You can choose to have the Save Mode either manually triggered by users with the Save Button each time they make a change, or automatically triggered every few seconds, along with the Save Button. When this mode is activated, the formula fields in your form will be computed, allowing conditions to be verified based on the submission’s auto-number value.
Add a checkbox field to your table and set it as the Confirmation Checkbox Field. This field will indicate whether a submission is valid (within the set limit).
Go to the Disable Form section and enable the Enable saving records if conditions are met toggle.
Add a new condition using your formula field.
Add a custom disabled by conditions message for your users. The Save & Continue mode will compute the formula before the user can submit the form and it will show your informative message if the limit has been reached:
Here's how the Airtable setup looks:
💡 Note: each submission attempt creates a new record in Airtable, so you’ll have a trace of all invalid attempts. However, only submissions made before reaching the limit will have a verification checkbox marked, which you can use to create a view that only shows valid submissions.