Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
7 years ago

Check a box from a Notification email

We want to check a checkbox using a link disguised as a button in a notification email. Has anyone tried such an endeavor and had success? 

My brain says it's possible and easy so if you know something my brain doesn't let me know. 

Thanks in advance. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    That is easy to do, I think, but the issue will be permissions and even if the user does have permissions they may not be logged into Quick Base.

    You could have a userid with restricted permissions, but enough to check the checkbox and the button could authenticate with a userid and password and then redirect to check the checkbox and then it would need to do something like display the record.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      You can just use a formula URL field then.

      The field will be called [Click to Approve]

      But then what do you want to happen in terms of the user interface when the button is clicked.  Should it display the record?



      var text URLONE = URLRoot() & "db/" & dbid()
      & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&_fid_7=1";

      var text URLTWO = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#]


      $URLONE
      & "&rdr=" & URLEncode($URLTWO)





       
    • JimHarrison's avatar
      JimHarrison
      Qrew Champion
      7 years ago
      Nope, just check the box. Doesn't need to display anything. 

      Thanks for the above, I was hoping to grab the dbid and realm data in the email but noticed it doesn't work that way. Making it into a field and then placing the field into the email makes more sense.