Skip to main content
Question

Pull a number from another table

  • March 25, 2024
  • 0 replies
  • 156 views
Forum|alt.badge.img+4

I ahve a table that breaks down "Fire Calls" in table 1.  I have table 2 that needs to have a formula of "total of fire calls" divided by ESD 7 calls.  I haven't had to pull numbers from another table up to this point.  I am going to look in help and other resources, but I always think this group will be faster or add clarification.



------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • March 25, 2024

    Is there any kind of relationship in place for the numbers you're trying to pull? If not you will need to expand your horizons into some thing called Formula Queries.  They are a relatively new feature of QuickBase that came along in the last two years or so and kind of rocked our world and that they allow you to basically pull any information from anywhere without relationships. You just have to be cautious if you are dealing with tables with high record counts as they will potentially impact the performance of your app or actually be blocked by QuickBase if you are carrying very large table say an excess of 10,000 100,000 records depending on the nature of your formula query. 

    I think we would need to have more details in order to guide you on whether you can pull your numbers for a traditional relationship which is typically preferable or whether you need to get into formula queries.    



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement