Discussions

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

    Posted 5 days ago
    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 5 days ago
    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 4 days ago
    Got it, thanks!

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