Forum Discussion

AdamKeever1's avatar
AdamKeever1
Qrew Commander
7 years ago

add record button in a notification email

I would like to add a button in an email notification to allow the user to add a new record from the email notification.

This seems relatively simple, but I am not finding the solution. Any suggestions?

I have successfully added record update buttons to email notifications so I understand how they work.
  • Hi Adam,

    Are you looking to just add a button that would take a user to a specific table in Quick Base, have them sign in, and add a record? Or are you looking to have them be able to add the record without having to sign in?
  • HI Evan, I am interested in both options, but the user must not be able to see the app token when the user hovers over the button. Furthermore I would like to edit the existing record as well.
  • I was planning to allow add record without sign-in. I have performed this for updating a record, but can't figure it out for adding a new record. I have a formula URL that is checked to display as button with the following, but it results in a hyperlink in the notification rather than a button:

    "https://XXXXXX.quickbase.com/db/XXXXXXXXX?a=nwr";

  • If you want to have a link show nicely in an email notification you can make your own hyperlink field as a formula rich text field.


    var text URL = URLRoot & "db/" & [_DBID_Table name goes here] & "?a=nwr";

    var text Words = "Click here to add a record";

    "<a href=" & $URL & ">" & $Words & "</a>"


  • I was hoping to create a button. We have update buttons like these:


    I cannot figure out how to do this for add new record.