Notification links across tables
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 no...
Forum Discussion
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.
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.
