Forum Discussion

JohnReinagel's avatar
JohnReinagel
Qrew Trainee
6 years ago

Create new records using data from a multi-select field

When I save a record in a table, I would like to take items selected in a multi-select field in that table and create a record for each item selected into another table.  I tried an automation but it ...
Quickbase Automations
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
You can make 10 fields each with a formula like these here

var text value = totext([my multi select field]);

Trim(Part($value,1,";")),
Trim(Part($value,2,";")),
Trim(Part($value,3,";")),
Trim(Part($value,4,";")),
Trim(Part($value,5,";")),
Trim(Part($value,6,";")),
Trim(Part($value,7,";")),
Trim(Part($value,8,";")),
Trim(Part($value,9,";")),
Trim(Part($value,10,";")



Then fire an automation to create 10 records and then the 11th step will be to delete all the blank records as in many case you would have less than 10 valid records created so a bunch will be blank.