MarkWinter1
8 years agoQrew Trainee
API call to create record then change owner of that record
I have a formula URL field that I am using to create a record in a table and set multiple values. Once that record is created, I want to change the Record Owner to a User field ([Requester User] in that same table. Of course, when I try to do this in the same URL, the Record ID is not yet created. So, how can I create the record and then change the owner?
here is my formula (without the change owner call):
var text URLONE = "https://MYQUICKBASEURL.com/";
& "db/"
& "9586ihjd"
& "?act=API_AddRecord&apptoken=d4k26jgbydttwdxmqn3hcnb5gqi&_fid_82=PO no longer needed&_fid_37="& [Requester Name] & "&_fid_75=" & [Line - Country] & "&_fid_45=" &[Supplier Name]&
"&_fid_6=" & ToText([PO Hdr Number]) & "&_fid_7=" & ToText([Maximum PO Line Num]) & "&_fid_28=1&_fid_11=1&_fid_113=1&_fid_114=" & ToText([Requester User]);
var text URLTWO = "https://MYQUICKBASEURL.com/intuitcorp.quickbase.com/db/bm4b44w87?a=dbpage&pageID=2";
$URLONE
& "&rdr=" & URLEncode($URLTWO)
here is my formula (without the change owner call):
var text URLONE = "https://MYQUICKBASEURL.com/";
& "db/"
& "9586ihjd"
& "?act=API_AddRecord&apptoken=d4k26jgbydttwdxmqn3hcnb5gqi&_fid_82=PO no longer needed&_fid_37="& [Requester Name] & "&_fid_75=" & [Line - Country] & "&_fid_45=" &[Supplier Name]&
"&_fid_6=" & ToText([PO Hdr Number]) & "&_fid_7=" & ToText([Maximum PO Line Num]) & "&_fid_28=1&_fid_11=1&_fid_113=1&_fid_114=" & ToText([Requester User]);
var text URLTWO = "https://MYQUICKBASEURL.com/intuitcorp.quickbase.com/db/bm4b44w87?a=dbpage&pageID=2";
$URLONE
& "&rdr=" & URLEncode($URLTWO)