Sum of Count of value in 5 fields
I have this data in table -> for every PC, there are 5 Peripherals fields. Each of these Peripheral fields have the same set of dropdowns. This is to allow them to collect up to 5 peripherals that are...
Forum Discussion
This really requires a table of records to mimic your 2nd screenshot. Each Peripheral -field should create a single record as a child-record. This way you would be able to get your Summary Report by Building Name to tell you the count of Peripherals by Peripheral type.
You could build an automation, webhook or QBAction to create these records when the Peripheral fields are populated.
Workstations < Peripherals
Each Peripheral would be connected to the Workstation and have a single-peripheral name. You can display/embed these if you want to, or not.
You could build an automation, webhook or QBAction to create these records when the Peripheral fields are populated.
Workstations < Peripherals
Each Peripheral would be connected to the Workstation and have a single-peripheral name. You can display/embed these if you want to, or not.