Forum Discussion
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
------------------------------
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__You9 months agoQrew Legend
But from which record are you wanting to pull the data?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- TonyGonzalez9 months agoQrew Trainee
Not exactly sure how to answer that. Here is a screenshot of some data from Table 1.
I want to bring total calls over. (The dates won't always match up in Table 2, but the month is the important piece.)Data in table 2 currently looks like this...There wouldn't be an incident type, just a date and total FD calls.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You9 months agoQrew Legend
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
------------------------------