Skip to main content
Question

mailto: and next url in button

  • July 16, 2021
  • 0 replies
  • 107 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
The only way to do this will be this sequence.

$URLONE
& "&rdr=" & URLEncode($URLTWO)


But that does mean that you are having faith in your staff that once they push the button they will actually go ahead and send the email. If they get struck by lightning and failed to send the survey then it will still be flagged that survey was sent. 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------