Skip to main content
Question

Formula API Button to create records in table in another app

  • September 20, 2022
  • 0 replies
  • 159 views
Forum|alt.badge.img+11
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement