Forum Discussion

MackenziePhilli's avatar
MackenziePhilli
Qrew Trainee
4 years ago

mailto: and next url in button

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
------------------------------

3 Replies

  • 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
    ------------------------------
    • MackenziePhilli's avatar
      MackenziePhilli
      Qrew Trainee
      Yes that is true.

      Is there another way have this functionality that when an email is sent it edits the check box to checked?

      ------------------------------
      Mackenzie Phillips
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        no, not using the mailto type process as when you enable the email client you are leaving Quickbase.

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