Skip to main content
Solved

URL Button to redirect users to specific record

I am wanting to create a button that will redirect the user to another table within the same application, to a specific form within that table and the related record. I am aware you can do this using the key field in the table. However, the key field in the two tables I'm working with are not the same. (One is a project ID# and the other is a QB generated Record ID#)

Can I utilize another field in the starting table that relates to the key field in the end point table? If so, how does that look in a formula. I've tried it all and am starting to lose hope.

Thanks in advance!

Best answer by UrsulaLl

If you can pull in the related record id, then you can create your url field and populate what you need. You need the RECORD ID to pull this in. It does not matter what the key field is. 
So your URL would look like this:
URLRoot() & "db/" & Dbid() & "?a=dr&dfid=THEFIELDIDOFTHEFORM&rid="& URLEncode ([relatedrecordid#])
View original
    This topic has been closed for replies.

    Forum|alt.badge.img
    • UrsulaLl
    • Registered
    • Answer
    • March 15, 2018
    If you can pull in the related record id, then you can create your url field and populate what you need. You need the RECORD ID to pull this in. It does not matter what the key field is. 
    So your URL would look like this:
    URLRoot() & "db/" & Dbid() & "?a=dr&dfid=THEFIELDIDOFTHEFORM&rid="& URLEncode ([relatedrecordid#])
      Terms & ConditionsAccessibility statement