Discussions

 View Only
  • 1.  Formula API Button to create records in table in another app

    Posted 09-20-2022 12:06
    Hello,

    I am creating a new app for managing travel expenses.  I have a tasks table in my main ERP system that my users use.  Can I create a formula rich text button in my travel expense app using formula url's to create a task in another app?  I have done it within the same app many times but when I try to do it, it is not recognizing the table (presumably since it is in a different app)

    ------------------------------
    Ivan Weiss
    ------------------------------


  • 2.  RE: Formula API Button to create records in table in another app

    Posted 09-20-2022 12:21
    sure,
    Normally you refer to tables by the indirect reference of [_DBID_TASKS]
    There's a best practice because if you were to have hardcoded the Table ID and you copy your app then everything is going to fail.  

    But as you can imagine there are many thousands of apps out there with tables called Customer or Tasks. So when you are going cross app, you need to actually insert the table ID which you see in the URL of any report or record in that table..  

    URLRoot() & "db/" & "bn4qy88xx" & "?a=nwr;





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



  • 3.  RE: Formula API Button to create records in table in another app

    Posted 09-21-2022 08:10
    Got it, thanks!

    ------------------------------
    Ivan Weiss
    ------------------------------