Forum Discussion

ChrisMolkenbuhr's avatar
ChrisMolkenbuhr
Qrew Trainee
5 years ago

URL Button to check a checkbox and initiate outlook for email

Hi, I'm trying to create a button that will check a checkbox and then open outlook and populate the recipients, subject line and body. I copied one of kirks buttons to check the checkbox and have mad...
APIs and custom code
Buttons
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
I suggest this Syntax

var text url =
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken= apptoken " &
"&_fid_415=1";

var text MailTo = "mailto:"&""&[Recipient 1]&";"&[Recipient 2]&"\n"&"?subject="&"\n"&[Subject]&""&"&body="&[Body]&"";

&URL
& "&rdr=" & URLEncode($MailTo)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ChrisMolkenbuhr's avatar
ChrisMolkenbuhr
Qrew Trainee
5 years ago
Thanks so much for your reply!

When i enter this, I get this at the end:

Hovering over the yellow it says "Expecting Text"
and if i try to close i get a formula syntax error "a formula cannot end with an assignment to a variable declaration".






------------------------------
Chris Chris
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    My mistake  s/b $URL

    $URL
    & "&rdr=" & URLEncode($MailTo)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ChrisMolkenbuhr's avatar
      ChrisMolkenbuhr
      Qrew Trainee
      5 years ago
      Thank you so much! That worked. 

      Is there something I can add to make it return/display the record? When i press the button the email pops up but in my browser the screen goes blank.

      ------------------------------
      Chris Chris
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        5 years ago
        Try clicking the box that says to open in new window and see if that helps.

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