I am trying to use a formula url button to mark a task complete, but in doing do, i also want to update the parent record of the task based on a user input from a codepage. Both functions work independently, but I cannot get them to work together. I think the issue is either somewhere in my nested url's, or it isnt possible to do this with a codepage for user input.
Is what I am trying to do possible?
Here is what I have:
var text URLONE = URLRoot() & "db/" & [_DBID_SO_TASKS]
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_12=" & URLEncode("Complete")
& "&apptoken=dg3xmifbwc8n9adx8a9hfkdqq7u&rid=";
var text URLTWO = URLRoot() & "db/" & [_DBID_OPPORTUNITY]
& "?a=API_EditRecord&apptoken=dg3xmifbwc8n9adx8a9hfkdqq7u"
& "&rid=" & [Related Opportunity]
& "&_fid_14=";
var text urlprompt = URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=8"
& "&url=" & URLEncode($urltwo);
var text URLTHREE = URLRoot() & "db/" & AppID();
$URLONE
& "&rdr=" & URLEncode($URLprompt)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
If I change the last three lines to just $URLONE, or $URLprompt they work independently, but I want to trigger everything to happen form one click. thank you in advance.
------------------------------
Kyle Conner
------------------------------
Question
Formula URL Button - update child record and parent record with user input from codepage
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.