Link to record in connected table

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
I've connected two tables from two apps and would like to have a link to the record in the source table available in the record in the connected table. Similar to a link to a parent record.

Photo of Heather Bryant

Heather Bryant

  • 1,116 Points 1k badge 2x thumb

Posted 7 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
You can make a formula URL button to go to from Sync back to the Parent.

urlroot()  & "db/" & "xxxxxx" & "?a=dr&rid=" & [Record ID#2]

The xxxxx will need to be the table code that you see when you view a record in the original table.  It will be the part after the db/ 
and will be about 7 characters long.

The Record ID to display will be whatever the field is called which is the Refresh Key on your Sync table.  If you did not rename it, it is likely still called [Record ID#2].  You can rename that to be called what it is, which is [Record ID# of original source table record].

To get back to view the sync table record from the original table, try this

urlroot()  & "db/" & "yyyyyyy" & "?a=dr&key=" & [Record ID#]

where yyyyyy is the table ID code in the sync table.