Discussions

 View Only
  • 1.  mailto: and next url in button

    Posted 07-16-2021 13:47

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


  • 2.  RE: mailto: and next url in button

    Posted 07-16-2021 14:36
    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
    ------------------------------



  • 3.  RE: mailto: and next url in button

    Posted 07-23-2021 09:08
    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
    ------------------------------



  • 4.  RE: mailto: and next url in button

    Posted 07-27-2021 12:32
    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
    ------------------------------