Help

Re: Creating a count of same items from single select field

Solved
Jump to Solution
1766 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Hairtable
6 - Interface Innovator
6 - Interface Innovator

I have two tables:

‘events’
‘people’ (including single select field for ‘dietary requirements’)

I can assign multiple people to each event. I then use a rollup field in ‘events’ linking to ‘people’ and the ‘dietary requirements’ field with this simple formula:
ARRAYJOIN((values), ", ")

It returns something like: None, Pescatarian, Vegetarian, None, None, None, None, None

What I would really like to see is:

1 x Pescatarian
1 x Vegetarian
6 x None (or No dietary requirements)

There are more than three options at the moment (e.g. ‘nut allergy’ and others, and as I add more people there will be additional dietary requirements to add to the single select field, no doubt.

What is the way to achieve this ‘count of same items’ please?

1 Solution

Accepted Solutions
nea_lpatil
7 - App Architect
7 - App Architect

@Hairtable

Check out reply by @Jeremy_Oglesby for counting from ARRAYJOIN result

Above article shows method for calculating number of times certain item appears in the result.

Neal

See Solution in Thread

1 Reply 1
nea_lpatil
7 - App Architect
7 - App Architect

@Hairtable

Check out reply by @Jeremy_Oglesby for counting from ARRAYJOIN result

Above article shows method for calculating number of times certain item appears in the result.

Neal