Forum Discussion

MackenziePhilli's avatar
MackenziePhilli
Qrew Trainee
4 years ago

URL Button to Open form in another app

Hello,

I have two separate apps, the projects app and the cost app. They exist in two different apps because it best fit the needs of our cost packages.

I have a form in our project app that creates complex automations on our project side, however I would like our team to be able to access the form through the Cost App.

I would like to make a button in our cost app that opens the form with the related record id from our project app (the record ids for our projects are the same between the cost app and the project app because we used a connected table). Is this possible?
#crossapprelationships #URLformulabuttons #Buttons

Thanks

​​​

------------------------------
Mackenzie Phillips
------------------------------

5 Replies

  • The syntax of a button to display a record is this


    URLRoot() & "db/xxxxxx" & "?a=dr&rid=" & [Record ID#]

    The xxxxx needs to be replaced with the table ID you see in the URL when you view the "other" record.  It will be a string of about 8 characters.


    Where I show [Record ID#] that is where you put in the field that has the [Record ID#] of the Other table's record.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MelanieProebste's avatar
      MelanieProebste
      Qrew Trainee

      Hi Mark - Can you write out how this should look? I am in one app, but want this button to look at another table in another app. Is this how you would notate?

      URLRoot() & "db/btbcahsih" & [_DBID_POWER_CLEAN] &

      Thank you, 

      Melanie



      ------------------------------
      Melanie Proebstel
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        URLRoot() & "db/btbcahsih" & "?a=dr&rid=" & [the field name in this table that holds the Record ID# of the record in the other table].



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------