ConfiForms: How to count (Smart) Multi-select values?

Ulrich Fries

For evaluating some events of my organization, I use two ConfiForms tables:

1. Database for employees
2. Database for events with a Smart Multi-select field, recurring on the employees database.

I would like to automatize my reportings. Is there a way to automatically count the values listed in the Multi-select field?

For example, I have the following in mind:

Event	Participants	Count
2024-01-12	John Doe, Jane Doe, Anne Bravo, Charly Sierra, Mike Holiday	5
2024-01-16	Jane Doe, Mike Holiday, Sally Subway	3

• The column "Participants" shows my Multi-select field values,
• The column "Count" sould be the counted number of the "Participants" values.

I am happy to receive suggestions for implementation

Alex Medved _ConfiForms_

Hi @Ulrich Fries 

You can use "asCount" virtual function on your Participants field

Set field name to 

Participants.asCount

 (on the ConfiForms Field macro)

Alex