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)
Question
API call to create record then change owner of that record
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.