You can calculate fields on the fly in Eventmaker. This is a feature commonly found in database managers or CRMs such as Salesforce or Filemaker, and it proves very useful for our use case: it avoids exporting the database, performing calculations in Excel, and reimporting it with the new values.

You can refer to this article to learn everything about calculated fields.

To help you understand the usefulness of these fields, here is a concrete example: imagine an organizer from a large metropolitan area in northern France wants to know at any time which local mayors (from 59 and 62) are attending their event.

To address this issue, we will create a new field of the “calculated” type in the database.

Go to the Participant fields tab, click the + Add a new field button and select the Calculated type.

A calculated field is evaluated in Liquid and has access to all guest data.

In our case, we will write in the Maire du Nord field the value “Maire du Nord” if the code_departement equals “59” or “62”, and “Autre” otherwise.

This field will be calculated each time the participant is modified.

⚠️ If you create a calculated field after registrations have started, you will need to run it manually on existing participants.

You can find your new calculated field in your field reports, and thus verify that the data has indeed been grouped.

To do this, go to the Reports tab then select the Attendance by field option before choosing the name of your calculated field.