URL Button to Open form in another app

Question

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 #ButtonsThanks​​​------------------------------Mackenzie Phillips------------------------------

markshnier__you · Answer

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 · Answer

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() &amp; "db/btbcahsih" &amp; [_DBID_POWER_CLEAN] &amp;
Thank you,&nbsp;
Melanie------------------------------Melanie Proebstel------------------------------

markshnier__you · Answer

URLRoot() &amp; "db/btbcahsih" &amp; "?a=dr&amp;rid=" &amp; [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------------------------------

melanieproebste · Answer

Hi Mark,I want this button in my app (bsb76aszn), but to push to app (btbcahsih), table [_DBID_POWER_CLEAN]. When I enter the way you have noted, it tells me the [_DBID_POWER_CLEAN] table is not in the app (bsb76aszn). Is it possible to button between two different apps, not two different tables?Many thanks for all your expertise here.&nbsp;Melanie------------------------------Melanie Proebstel------------------------------

markshnier__you · Answer

Please post your current URL formula by a copy and paste.&nbsp; Note that the "code" for the table needs to come from the target table and not the target app Home page.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

URL Button to Open form in another app