Help with creating multiple new records via Script
Can anyone help.
I have a database which based on a number entered i need to create multiple new records to that number as well as create a unique code for each record.
I'm struggling how to achieve this so any help would really be appreciate.
Thanks in advance
Field Content Data Entered
Estate Name JulesEstate
Number of Apts 50
Estate Reference: JE
Estate Reference Code: (script generated result)
In this example i would need it to generate 50 new records and in each Estate Reference Code enter a combination of the Estate Reference and sequencial number of apartments entered. eg.
JE004 etc. (Note: i need this to be 3 numbers as we have apts blocks which are in the hundreds)