Multiple Tables Report
Hi all, I have three project tables from different business units, each with fields for contract value, contract date, and other details. We want to create a dashboard with reports combining the da...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI have an alternate suggestion. I would create the fourth table that Mike talks about but I would set the key field to be a prefix corresponding to each of your three separate tables and then a dash and then the record ID of the source table.
In each of the three tables I would create a formula to make that key field of the fourth table so for example it would read like
List("-", "Business Unit 1", ToText([Record ID#]))
Then create three saved table to table copies to copy the fields from respectively each of the source tables into the combine table.
Then I would set a pipeline to run every hour say which would be to first delete all the records in the combined table and then to successively run each of the saved table to table copies.
The make Request step to run the saved T2T copy would look like.
mycompany.quickbase.com/xxxxxxxx/?act=API_RunImport&ID=10
Mark,
I like the idea of the Combined table having a key field in that way but I had a question. Lets say each of your 3 tables has 5000 records. Wouldn't that mean every hour your pipeline is deleteing 15000 records from the combined table, and recreating them, every hour? I was under the impression that a record ID could only go up to about 4 million. Wouldn't recreating 15,000 record IDs every hour, hit that limit quite quickly?
- MarkShnier__You
The limit for maximum record ID in a table is 4,294,967,295.
by my calculation, if you burn through 5000 record IDs every hour, then you would run out of numbers after about 10 years. But you probably don't need to refresh every hour outside of business hours and maybe there would be a more intelligent way of deleting just the records that are no longer required. The only purpose of deleting is to cover the possibility that record in one of the individual tables was deleted. But you can set up relationships and be more intelligent about deleting.
Oh, it's 4 BILLION not Million! I have had that wrong in my head for the last 5 years lol.