URL Button to redirect users to specific record

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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!
Photo of Skye Ellis

Skye Ellis

  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb
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#])