Notification links across tables

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
I have two tables that create a ticketing application.  The first table (Tickets) is the ticket itself.  The second table (Ticket Activities) is for activities that are attached per ticket.
I have notifications set up in the Ticket Activities table when any new activity is created.  
The link that is available to attach from the notification set-up page (%recLink%) takes me to the Ticket Activity Table.  I would like to instead, link to the Tickets Table.
How would I accomplish this?

Thanks,

Mike
Photo of Mike

Mike

  • 554 Points 500 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
Official Response
The tidiest way is to create a formula URL field which is a link to the Parent Record and put that fiedd in the Notification body.

The formula for a field called [Ticket] would be something like 

URLRoot() & "db/" & [_DBID_TICKETS] & "?a=dr&rid=" & ToText[Related Ticket])

You will be able to get the correct DBID reference to the tickets table by going to the settings for the tickets table and it will be under Advanced Properties at the bottom of that page.