Button to go to parent record in a different application

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Is there a way to add a button in the child record that will take you to the parent record (in a different app) instead of the parent record showing as a link?
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,406 Points 10k badge 2x thumb
Hi TRNC,

Does the Child Record contain a field that matches with the key field from the Parent Record in the other app?
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb
Excuse my ignorance on this question. Would that be the 'Related PO' that links back to the parent record?
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,406 Points 10k badge 2x thumb
Hi TRNC,

Yes most likely if the Parent table is a PO table then the Related PO table would most likely be the matching field between the two tables. If so you can use a Formula URL button set to use that Related PO field to display the Parent Record when the button is pushed. It would use a formula url field with a formula like:

URLRoot() & "db/" & "DBID Here" & "?a=dr&key="&[Related PO]

What you would need to input here is the DBID of the Parent table in the formula where it says DBID Here. The DBID can be found by going to the table you are wanting to display and in the URL in the address bar it is the chain of numbers and letters that appear after /db/ and before ?a=. That essentially lets the button know which table you are trying to open up and then asking it to display the record from that PO table that has the same Related PO as its Record ID#.