add record button in a notification email

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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.
Photo of Adam Keever

Adam Keever

  • 1,170 Points 1k badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,060 Points 10k badge 2x thumb
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?
Photo of Paul Vorster

Paul Vorster

  • 576 Points 500 badge 2x thumb
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.
Photo of Adam Keever

Adam Keever

  • 1,170 Points 1k badge 2x thumb
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";

(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
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>"


Photo of Adam Keever

Adam Keever

  • 1,170 Points 1k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,792 Points 50k badge 2x thumb
I'm not really an HTML Button expert.  If I had to have that look I would use the website https://dabuttonfactory.com/ and save the image in an app which was open to everyone on the internet