View form from a different app using formula url field
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.
"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.
