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