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

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

Database for employees
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

I am happy to receive suggestions for implementation :)

1 answer

Community moderators have prevented the ability to post new answers.

1 vote

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

Set field name to

Participants.asCount

(on the ConfiForms Field macro)

Alex

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.