API call to create record then change owner of that record

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • In Progress
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)
Photo of Mark Winter

Mark Winter

  • 252 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of ARYEH ZELCZER

ARYEH ZELCZER

  • 332 Points 250 badge 2x thumb
You can trigger a webhook after the record is created to change the record owner using API_ChangeRecordOwner.