Discussions

Expand all | Collapse all

add record button in a notification email

  • 1.  add record button in a notification email

    Bronze
    Contributor
    Posted 08-16-2018 19:30
    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.


  • 2.  RE: add record button in a notification email

    Top
    Contributor
    Posted 08-17-2018 13:16
    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?


  • 3.  RE: add record button in a notification email

    Posted 08-23-2018 13:24
    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.


  • 4.  RE: add record button in a notification email

    Bronze
    Contributor
    Posted 08-23-2018 18:59
    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";



  • 5.  RE: add record button in a notification email

    Posted 08-23-2018 19:06
    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>"




  • 6.  RE: add record button in a notification email

    Bronze
    Contributor
    Posted 08-23-2018 19:36
    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.


  • 7.  RE: add record button in a notification email

    Posted 08-23-2018 19:39
    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