Discussions

Expand all | Collapse all

mailto: and next url in button

  • 1.  mailto: and next url in button

    Posted 19 days ago

    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 19 days ago
    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 12 days ago
    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 8 days ago
    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
    ------------------------------