Discussions

Expand all | Collapse all

API call to create record then change owner of that record

  • 1.  API call to create record then change owner of that record

    Posted 12-27-2017 21:52
    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)


  • 2.  RE: API call to create record then change owner of that record

    Posted 12-27-2017 22:32
    You can trigger a webhook after the record is created to change the record owner using API_ChangeRecordOwner.