Auto-generated serials and record submit
A have created part of a solution that auto-enters a serial number on creation of a record. I then have an auto-entered field recordID which is generated by means of a calulation using the serial number.
Is there any way that I can create a system where that if the user does not commit the record by pressing on a submit button, that the data entered in the fields by the user are wiped and that generated serial can be re-used? e.g the user has made a mistake and this record is not required therefore the record is not commited/saved
Thanks in advance
Set your serial number to be generated "on commit" instead of "on creation" in field options.
You can then use the revert record step in a script to undo the rest of the data entry. (You could attach this script to a cancel button, for example.)