Creating x amount of records based on a count field.

May 30, 200619 yr

I have a field called No of players, it is formatted to count the number of data items checked in a checkbox.

Is there anyway i could make a script that will go to one of my layouts(member) and create the amount of new records that are in the No of players field.

eg No of players= 23

The script will create 23 new records.

Also how many records in general can one database hold, till it effects performance.

Edited May 30, 200619 yr by Guest

May 30, 200619 yr

The attached screen shot of a script will do the trick for you.

May 30, 200619 yr

Author

thanks very much, is there a way i could set a second variable at the beginning of the script without messing the loop up.

Edited May 30, 200619 yr by Guest

May 30, 200619 yr

You can set as many as you wishes to, as long as the variable names doesn't conflict.

Instead of using Set Variable[ could you instead, use to set a field to itself in a Set Field[ where you define or initiate a series of $variables via a Let([$var1="XXX";$var2="YYY" ... etc.

--sd