Pull a number from another table
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 tabl...
Forum Discussion
OK Mark, I am raising the flag for help. I can't get this done right. I do just simply want to bring a number from field 1 in table 1, to a similarly titled field in table 2. I know this is easier than I am making it out to be. How do I do this? The tables are in the same app.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendBut from which record are you wanting to pull the data?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Not exactly sure how to answer that. Here is a screenshot of some data from Table 1.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You
Can you give a very specific answer for the first row of data in table 2 what the right answer is to that first cell for Total FD calls and explain why it is the right answer?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------I think so.
Total FD Calls in table 2, first record, should be 1,073. That is the total of the Fire and EMS calls for Nov 2023. It really could be in any of the 17 entries on table 2 that are dated in November. I just need to be able to calculate the total number of ESD 7 calls, regardless of Incident Type, by Total FD Calls.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
Wait, maybe I can just do this with a QB action. When a new entry is made in table 1, just copy that record to table 2. Only copy date and Total calls fields.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You
I'm not really sure if your action method will work but they are telling us not to use actions anymore, so it would need to be a Pipeline. But a better solution is probably using a Formula Query. That is a whole world onto itself.
Sharon Faust, a.k.a. The Quickbase Junkie has a of of good training material. quickbasejunkie.com.
Truthfully you should try to find budget to just buy her Mega Bundle and have access to all of her training materials, both free and paid.
I assume that Quickbase University also has training materials too. Or some of us on this Forum offer one on one assistance. Or we plod though building a formula query on this thread here.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------