Forum Discussion

CaroleVandenbe2's avatar
CaroleVandenbe2
Qrew Trainee
5 years ago

Button to generate/send email to specific address with specific fields only once pushed

I've searched and seen several responses to similar questions but nothing exactly this.  Here is what I need to know how to do: Build a button for a form that when selected, it automatically sends ...
APIs and custom code
Buttons
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
If you make a date / time field called [date / time to trigger email], then you can use this code for a formula URL field to make a button to update that field which will then trigger an email notificaiton set to watch for a change in that field. In the formula below my field ID was 58

var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_58=" & URLEncode(Now());


"javascript:" &
"$.get('" &
$TriggerEmailURL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • CaroleVandenbe2's avatar
    CaroleVandenbe2
    Qrew Trainee
    5 years ago
    Thanks - just tried and it says $TriggerEmailURL is not declared.  Is this something I need to do in the Formula URL field as well?

    ------------------------------
    Carole Vandenberg
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      sorry, copy paste error

      var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&_fid_58=" & URLEncode(Now());


      "javascript:" &
      "$.get('" &
      $URL &
      "',function(){" &
      "location.reload(true);" &
      "});"
      & "void(0);"

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • CaroleVandenbe2's avatar
        CaroleVandenbe2
        Qrew Trainee
        5 years ago
        Manual change of the date/time field does trigger the notification but the Formula URL does not update the date/time field.  I checked - I am using the correct FID (140) and I also tried using the apptoken too.  No luck - any ideas on what to try next?  Thank you!

        ------------------------------
        Carole Vandenberg
        ------------------------------