For Admins
Attendance Report for Sports Programs and J+S 📊
Sports programs, funders and federations often ask for proof of attendance: who was at which training, and for how long. Gumb records attendance as members respond. The Presence check report exports it as Excel or CSV, with one row per person and event and an ID number for each person. In Switzerland, the same export covers the attendance control of Jugend+Sport (J+S).
What does Gumb do for attendance reports?
- Recorded automatically Every answer to an event goes into the attendance list.
- Correctable later Admins adjust attendance in the event, even afterwards.
- ID number in the profile A person, license or membership number goes in the Free Text 1 field.
- Excel or CSV One row per person and event, with date, duration and location.
What happens to the attendance list when the coach leaves?
It stays with the club. All admins and group leaders keep seeing every attendance record, and the successor takes over without losing any data.

Where do I store a member's ID number?
In the profile field Free Text 1. Gumb exports it as its own column, so every row carries the person's number, e.g. a J+S person number, a license or a membership number.
- Click the gear ⚙️ next to your community's name and open the Members tab (1).
- Click the pencil next to the person (2).
- Enter the number under Free Text 1 (3) and click Save changes (4).
Your members can also add the number in their own profile.

How do I export an attendance report?
- Open the Scheduler in the left sidebar and click Export & Statistics at the top (1).
- Under Choose a report, pick Presence check (2).
- Click Show filters (3) and narrow it down: the date range to the season or course, the event type to your trainings, the groups to the team.
- Check in the Free Text 1 column (4) that everyone has a number.
- Click Export (5) and choose XLSX for Excel.
Gumb builds the report in the background and emails you the download link, to the address of your Gumb account. With many events, this takes a few minutes.

Which columns does the attendance report have?
One row per person and event. The column names follow your language in Gumb.
- The event: date, event type, start and end time, duration in minutes and location.
- The person: name, email, username, Free Text 1 and 2 and birthday.
- FUNCTION: Member, Admin, Group Leader or Owner.
- The answers: one column per answer option, with a 1 under the answer the person gave.
To count who attended, filter the column of your yes answer for 1.
How do I use the report for J+S in Switzerland?
- Made for J+S The first columns follow the template of the National Sports Database (NDS).
J+S course leaders report attendance in the NDS of the Federal Office of Sport (FOSPO). It imports a CSV file with exactly seven columns. Its templates come in German, French and Italian. Switch Gumb to German before the export: the columns are then named as in the German template.
- Open the export in Excel and keep only the rows with a 1 in the column of your yes answer.
- Copy the values from FREITEXT 1 into PERSONENNUMMER.
- Move FUNKTION right after PERSONENNUMMER and replace "Besitzer" with "Leiter/in".
- Replace your event types under AKTIVITAETSTYP with "Training", "Wettkampf", "Trainingstag" or "Lagertag".
- Rename STARTZEIT to ZEIT. Delete ENDZEIT and every column after ORT.
- Save the file as CSV UTF-8 and upload it to the course in the NDS.
ZEIT and ORT are only filled in for trainings. DAUER only accepts certain values, e.g. 60, 75 or 90 minutes for a training, so plan your trainings in Gumb with that length. The FOSPO guide lists the allowed values.
What must be in the NDS before the import?
All leaders, participants and activities must already exist in the course, or the import stops. So import the people first, then the activities and finally the attendance. A new import overwrites the attendance already recorded in the course, so always upload the whole course period at once.
How do I keep the attendance list up to date?
- Fill in answers later: In the Scheduler, use the left arrow to go back to past events and correct the answers. The next export includes them. More in Scheduling in Gumb 🗓️.
- Send reminders automatically: A push notification before every training gets everyone to answer in time: Automate Notifications 📳.
Who can export the report?
Admins and group leaders. The download link goes to the person who starts the export, so the export works even when the coach is away.
Is there a direct connection between Gumb and the NDS?
No. You export the attendance from Gumb and import it into the NDS. Your cantonal sports office for J+S answers questions about the import.