View form from a different app using formula url field

  • 1
  • 2
  • Question
  • Updated 2 months ago
  • Answered
I have two apps, "Data" and "Sales". There is a cross-app relationship already established. Both apps have a table called "Accounts". There is a table to table relationship already in place. In both "Accounts" tables, the key field is called "Account ID". I would like to have a button in "Data" > "Accounts" that calls up the form in "Sales" > "Accounts". I am trying to use a formula URL field in "Data" > "Accounts" to accomplish this. The formula I have at this point is . . .

"https://xxxxxxx.quickbase.com/db/xxxxxxxxx?a=dr&[Account ID]="&[Account ID]&"&dfid=2"

When I click the button in "Data" > "Accounts", a new window opens in "Sales" > "Accounts".
That's a good thing, and the URL in the new window is this . . .

https://xxxxxxx.quickbase.com/db/xxxxxxxxx?a=dr&[Account%20ID]=123456&dfid=2

I should mention that the account number above (123456) is the correct account number. But the page displays the "Account Not Found" dialogue box.

Sadly, my repeated attempts to fix this (using the SWAG method) have failed. Any help would be greatly appreciated.


Photo of Orion

Orion

  • 172 Points 100 badge 2x thumb

Posted 2 months ago

  • 1
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
Photo of Orion

Orion

  • 172 Points 100 badge 2x thumb
Thanks.
Alas that did not work. In fact the account number no longer appears in the new URL. If I may ask, doesn't the use of "rid" invoke the Record ID field? These will not be the same in the two tables. I should also have mentioned earlier that the "Account ID" fields are in fact text fields even though they contain numbers.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
Sorry, my mistake,


"https://xxxxxxx.quickbase.com/db/xxxxxxxxx?a=dr&key=" & ToText([Account ID]) & "&dfid=2"

We need to say that this is the "key and not the rid.


Photo of Orion

Orion

  • 172 Points 100 badge 2x thumb
I am doing my happy dance. Fortunately, no one can see. But rest assured that you have singlehandedly made this a great year for me. May blessings rain down upon you!