Skip to main content

I have a table with a multiple select field monday, thusday etc etc. 

I will make a view or a 2nd database where I can show and count all the people on the different days.

Monday : count : names

Thusday : count : names

etc

 

How can I do this?

Hey ​@ceescoenen,

What you will actually want to do is to have a new table called “Days Library” and have one record per day of the week (i.e. Monday, Tuesday, etc. each of them being one new record).

Then you will want to create a new field on your initial table. Field type: Linked record field, and connect it to the Days Library table (make sure to allow for multiple linked records). Then you will want to use this new field in replacement of your original multi select field.

Then on the Days Library you will want to create a new field of Count type (more on count fields on this article).

You can also re-convert your existing multiple field into a linked record field if that is easier, just by editing the field and changing the field type to Linked record field, and selecting “create a new table” when selecting the table. That will also create and link all days automatically for you.

Mike, Consultant @ Automatic Nation 
YouTube Channel