Forum Discussion

MarkWinter1's avatar
MarkWinter1
Qrew Trainee
8 years ago

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)
  • You can trigger a webhook after the record is created to change the record owner using API_ChangeRecordOwner.