Forum Discussion

HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
6 years ago

Link to record in connected table

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.

Thanks!
Formulas and functions
Quickbase Sync
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.