Expand all | Collapse all

URL for a Parent Record

  • 1.  URL for a Parent Record

    Posted 07-11-2019 19:25
    I have a parent table Called Requests. And a child table called Tasks.

    When a new request is created, a task is automatically created for a user designated in the Requests table.

    The task looks up to the Request and pulls down 1)project, 2) customer, 3) RECID of the parent record.

    I'd like to include the URL of the related request, on the task form, so that the person assigned can go directly to that request. (right now I'm doing that through a lookup field to record ID in the parent record).

    I'd also like to use that URL in the notification email in the task table. (so that user can go directly from notification email in task table to the parent record in the request table).

    How do I create a URL for a given record?

  • 2.  RE: URL for a Parent Record

    Posted 07-11-2019 19:40
    See if this works for you.  Create a new Formula Rich Text field on the Parent table to create a Hyperlink to the parent record and look it up down to the child.

    var text Words = [Request Title]; ( or some other identifier field on the request).

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

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

    See if that work on the child record and then try it in the Notification.

  • 3.  RE: URL for a Parent Record

    Posted 07-11-2019 20:17
    Worked perfectly!! Thank You