Edit all records in a table with an array
How would I use an API and or code page to edit every record in a table with the contents of an array? I want to essentially split up the records evenly and assign them to 8 different names.
Forum Discussion
Geofrey,
If the goal is to assign randomly have you considered a formula field based off the Record ID#
If the goal is to assign randomly have you considered a formula field based off the Record ID#
- Hmm, I have not. Would you be able to use this to equally distribute the records?
- Yes, because the record ID#s are random. Well i mean that they are sequential so you can use them to allow records to "agents" in a round robin fashion.
For example if you run a report sorted by [Record ID#] and then have a column with a formula like
REM([Record ID#],8) +1, then you should see that column counting up from 1 to 8 and then start over at 1.
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=bu&rl=bh9h - That works for my problem. Thank you for your help!
