Forum Discussion

AshleyAsante's avatar
AshleyAsante
Qrew Cadet
6 years ago

URL for a Parent Record

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?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.