AnsweredAssumed Answered

Help with creating multiple new records via Script

Question asked by julieFrith on Jan 31, 2011
Latest reply on Feb 27, 2013 by philmodjunk

Title

Help with creating multiple new records via Script

Post

Hello

 

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

Jules

 

 

Example

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.

JE001

JE002

JE003

JE004 etc.  (Note: i need this to be 3 numbers as we have apts blocks which are in the hundreds)

 

 

 

 

 

 

Outcomes