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

[Ulrich Fries]

Thanks a lot, Alex, for your fast response! I'm really glad to see that it works so easily! ☺️