Discussions

 View Only
  • 1.  Notifications and having %recLink% open a particular FORM

    Posted 05-13-2022 18:39
    Hi all:
    Probably a simple question, but I have a notification for a table that I have put %recLink% in the notification.  Works fine but it links to the DEFAULT form for that table. I want it to use a different form that I have developed for the table as the notification is set for a specific change that is made with the "NON-DEFAULT" form.   How do I modify %recLink% or what would be the html that I would need to write out in my notification to have it pick the correct form to display the record?

    Thanks!

    Melissa

    ------------------------------
    Melissa Freel
    ------------------------------


  • 2.  RE: Notifications and having %recLink% open a particular FORM
    Best Answer

    Posted 05-13-2022 19:44
    Edited by Mark Shnier (Your Quickbase Coach) 05-17-2022 14:43
    A Notification can contain a Hyperlink field

    Here is the generic formula to make a Formula Rich text field be a Hyperlink.

    Hyperlink Example

    var text Words = "Words go here or a formula for the words"

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


    // this last part is always the same

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

    The &dfid=11 says to use form ID# 11.





    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Notifications and having %recLink% open a particular FORM

    Posted 05-17-2022 14:09
    Thanks Mark! Appreciate it as always

    ------------------------------
    Melissa Freel
    ------------------------------