Question
Button to go to parent record in a different application
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?
This topic has been closed for replies.
+17Hi TRNC,
Does the Child Record contain a field that matches with the key field from the Parent Record in the other app?
Does the Child Record contain a field that matches with the key field from the Parent Record in the other app?
Excuse my ignorance on this question. Would that be the 'Related PO' that links back to the parent record?
+17Hi 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#.
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#.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.