Forum Discussion

CaroleVandenbe2's avatar
CaroleVandenbe2
Qrew Trainee
4 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
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
4 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    the way to debug this is to do this

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

    $URL

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



    ie comment out the javascript stuff and just run the URL. That will expose the error message.  The javascript refresh hides any error message and just refreshes the page.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • CaroleVandenbe2's avatar
      CaroleVandenbe2
      Qrew Trainee
      4 years ago
      It's an apptoken error.  I do think I need these.  I put it in the code, and checked it twice, even created a new one and tried the new one.  Keep getting the error 24 that it's not assigned.  xxx below replaces the actual apptoken.  But note the void(0) appended - does that tell something?  I've checked for spaces and there are none.  I am literally copying/pasting from the apptoken list into the code.  

      <qdbapi>
      <action>API_EditRecord</action>
      <errcode>24</errcode>
      <errtext>Invalid Application Token</errtext>
      <errdetail>The Application Token xxxvoid(0); has not been assigned to this Application. To read about assigning an Application Token to your application go to https://help.quickbase.com/user-assistance/app_tokens.html</errdetail>
      </qdbapi>


      ------------------------------
      Carole Vandenberg
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        May I see your code that is failing?  Please copy and paste, nota screen shot.

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