Discussions

 View Only
  • 1.  URL Button to Open form in another app

    Posted 09-30-2020 10:22
    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
    ------------------------------


  • 2.  RE: URL Button to Open form in another app

    Posted 09-30-2020 11:13
    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
    ------------------------------



  • 3.  RE: URL Button to Open form in another app

    Posted 05-30-2023 19:17

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



  • 4.  RE: URL Button to Open form in another app

    Posted 05-30-2023 19:55

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



  • 5.  RE: URL Button to Open form in another app

    Posted 05-30-2023 21:04

    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. 
    Melanie



    ------------------------------
    Melanie Proebstel
    ------------------------------



  • 6.  RE: URL Button to Open form in another app

    Posted 05-30-2023 23:16

    Please post your current URL formula by a copy and paste.  Note that the "code" for the table needs to come from the target table and not the target app Home page. 



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