Discussions

Expand all | Collapse all

View form from a different app using formula url field

  • 1.  View form from a different app using formula url field

    Posted 10-28-2018 13:28
    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">https://ingramcontent.quickbase.com/db/bnqttwix7?a=dr&[Child%20Acct%20ID]=6010004&dfid=2">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.




  • 2.  RE: View form from a different app using formula url field

    Posted 10-28-2018 13:32


  • 3.  RE: View form from a different app using formula url field

    Posted 10-28-2018 14:20
    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.


  • 4.  RE: View form from a different app using formula url field

    Posted 10-28-2018 14:23
    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.




  • 5.  RE: View form from a different app using formula url field

    Posted 10-28-2018 14:47
    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!