Creating an Array of simple types not working

#1

Note: this fails for CSV, but works for json…

I’m trying to create an array of strings. I choose Custom List and give it values of “Task, File, Note, Appt”

  • If I call the field registrations[], it will populate with a single value.

  • If i call the field registrations[1-2], it always ends up empty

I do exactly as described here but it does not work - https://mockaroo.com/ff6a9e90

#2

You can use a Formula field and enter this formula. It does behave a bit differently, but it solves your case for CSVs if you want to have one column with multiple random values in a comma separated list.

'Task,File,Note,Appt'.split(',').sample(random(1,4)).join(', ')