Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
3 years ago

Formula API Button to create records in table in another app

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
------------------------------
  • 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
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      Got it, thanks!

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