Trying to create auto ID, after customer submits the form the ERD number will be creted/added automatically based on the continuation of previous records (which were manually imported in to the Knack)..
Managed some form of formula but struggling with the implementation..
1. User enters the details (the ERD number does not exist yet)
2. After submitting the form it's redirected to view page where can see the details with the new ERD number automatically created.
How to do this ? how to use the extract date record and replace with the ERD from now on not messing with the older records..continuing the numbering order..
3. Can click on edit to add/change more records.. another level..