I have a formula URL button that needs two urls. The first is a mailto: function that works great and when the button is clicked it prompts an outlook email with dynamic field information for the user to send - great. The second URL I need is an API edit record url that checks a box to show that the email was sent.
Both links work separately (mailto formula prompts the email and the APIeditRecord url edits the record) but I cant find a way that works to combine them into one field. I want the email to prompt for the next url to edit the record.
My formula:
var text URLONE = "https://company.quickbase.com/db/xxxxxxx?a=API_EditRecord&usertoken=xxxmyusertokenxxxxx&rid="&[Record ID#]&"&_fid_13=true";
var text URLTWO = If([Sent] = true,"Survey Sent",[Survey Type]= "Precon", [Precon Kickoff Survey], [Survey Type] = "Kickoff",
[Kickoff Survey], [Survey Type] = "Progress", [Progress Survey], [Survey Type] = "Completion", [Completion Survey]);
$URLTWO
& "&NextURL=" & URLEncode($URLONE)
please help!
------------------------------
Mackenzie Phillips
------------------------------