Forum Discussion

SkyeEllis1's avatar
SkyeEllis1
Qrew Member
8 years ago

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!
Formulas and functions
  • UrsulaLl's avatar
    UrsulaLl
    Qrew Assistant Captain
    8 years ago
    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#])