Sum of Count of value in 5 fields

Question

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 attached to the PC. I would like to generate a count of each type of peripheral. Below is a sample of what the data looks like:

I would like to create a table where the data below can be pulled as needed (grouped by the location). Is it possible to do this?

Thank you.

LauraThacker · Answer

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.

Sign up

Login to the community