Create new records using data from a multi-select field

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.

You can also use the formula that Mark has provided; and use it to create a formula that can be read by Quick Base as a csv import and leverage the Webhook automation feature to create child-table records with the values from your multi-select text field.  This is much cleaner than having 10 separate fields that run on separate automations.

There are many ways to do this and it always depends on the use case and how far down the rabbit hole you want to go. Both answers are great with one going a bit more down the rabbit hole technically. I am taking a different angle, what if I really didn't want this to occur every single time I hit save or I needed to review the record that other users are making before the other records are made (I am not a fan of going back to delete extra records). I went with making a button using a Formula Rich Text field. The button adds a record for each of the items selected (up to 10) and also fills in a field with the Record ID from the table of origin. (if using a table to table relationship you could populate the related field with the record ID to connect the records).
In the table of origin I made 2 fields, the one for the button and a checkbox field that is used to hide the button after being used.

Yes it a bunch of lines but it offers some good learning material if you have time to learn. I apologize if it is too much, I just wanted to do it and use my brain on something different today.

var text value = ToText([item choices]);

// splitting out the selections

var text valone = Trim(Part($value,1,";"));
var text valtwo = Trim(Part($value,2,";"));
var text valthree = Trim(Part($value,3,";"));
var text valfour = Trim(Part($value,4,";"));
var text valfive = Trim(Part($value,5,";"));
var text valsix = Trim(Part($value,6,";"));
var text valseven = Trim(Part($value,7,";"));
var text valeight = Trim(Part($value,8,";"));
var text valnine = Trim(Part($value,9,";"));
var text valten = Trim(Part($value,10,";"));

//how many records will I be creating

var number howmanyitems =
If($valten>"",10,
If($valnine>"",9,
If($valeight>"",8,
If($valseven>"",7,
If($valsix>"",6,
If($valfive>"",5,
If($valfour>"",4,
If($valthree>"",3,
If($valtwo>"",2,
If($valone>"",1,
0))))))))));

//creating the variables for adding records to the 'Send It Here' table, mostly boring repetition also it is going to edit the current record

var text URLONE = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1"));

var text URLTWO = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
));

var text URLTHREE = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
)));

var text URLFOUR = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfour)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
))));

var text URLFIVE = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfour)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfive)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
)))));

var text URLSIX = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfour)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfive)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valsix)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
))))));

var text URLSEVEN = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfour)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfive)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valsix)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valseven)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
)))))));

var text URLEIGHT = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfour)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfive)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valsix)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valseven)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valeight)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
))))))));

var text URLNINE = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfour)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfive)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valsix)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valseven)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valeight)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valnine)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_9=1")
)))))))));

var text URLTEN = URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valone)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valtwo)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valthree)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfour)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valfive)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valsix)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valseven)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valeight)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valnine)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& [_DBID_SEND_IT_HERE]  & "?a=API_AddRecord"
& "&_fid_6="& URLEncode($valten)
& "&_fid_7="&[Record ID#]
& "&rdr="
& URLEncode(URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&r