A form does not continuously refresh Airtable values while it is open. Field validation evaluates the values currently in the form, so it should not be treated as a guarantee that another user has not changed a record. When saving an existing record, miniExtensions checks its current access and locking rules and checks for conflicting changes to the submitted fields. If a conflict is detected, the form refreshes and asks the user to review the latest values before trying again. Conditional Login can additionally check whether a record still meets your access conditions at submission, as described below.
When turning on the form's login functionality it will validate if the conditions set for being able to log in (e.g. correct status) are still met at the time of submission. This can be used to prevent multiple submissions by different users.
To take advantage of this feature, go to:
The Form's Share section
Make sure that How do users access their records? is set to Login page
Select the fields used to uniquely identify a record under Login Fields
Under Restrict Access, turn on Conditional Login
Add the required conditions, e.g. Status = Available
Now, the conditions (Status in this example) will be checked both when the user first loads the record (either by entering the login details, or by using the magic link) and when they hit the submit button. If the condition is not met in either of the two steps, an error message will be shown.