BenBen1
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How to make a summary report from multiple tables?
I got it working yesterday, this is exactly what I needed. The only thing I didn't figure out was how to make the report from the Items table show up on the Focus table entry, which is ok. I believe it's because there is no relationship back to the items table, but I don't know if there is a way to create a relationship to that record via a quickbase formula field. When I tried to change the field type of the related focus table from a numeric reference to a numeric formula it broke the relationship between the tables. The only way I can think of doing it is through a dynamic form rule, but that doesn't help me for all of the existing records. But I guess I can grid edit and update those records, and rely on the form rule from there.23Views0likes0CommentsHow to make a summary report from multiple tables?
I have four tables. A Project table, a Task table, an Assembly table and an Item table. Each record in the Project table has many related tasks. Each record in the Task table has a numeric field dictating the number of assemblies needed for the task. It also has a dropdown to choose an assembly from the Assembly table. Each record in the Assembly table has a list of many related items from the Item table. Each record in the Item table has a field dictating the number of items needed to make the assembly it is related to and the Item description. I want to make a report that summarizes the total number of each unique item descriptions needed to complete the project. So: For each task, total the # items individually per assembly multiplied by the # of those assemblies needed for the task. Then combining the totals for items of the same description across all of the tasks of the project. Is there a way to do this either within native quickbase or using external tools? If external tools are required do you have any recommendations of what to use?