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
JasonJohnson's avatar
JasonJohnson
Qrew Assistant Captain
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
LauraThacker's avatar
LauraThacker
Qrew Captain
6 years ago
Jason & John; this is an illustration of the fact that there are many different ways to achieve things in Quick Base.  I spoke with John this afternoon; and his use-case is enter the text-options once on record-creation and to create the child records only once.  The list-formula & webhook solution I proposed to import those records in a single step works really well for that use case; but you have illustrated that there are always different techniques to do things and sometimes the complexity of what you might be doing will be a deciding factor in directing you to the implementation technique.  Also, choices become dependent sometimes on solutions you become familiar with implementing.  Well illustrated!