Taking and showing attendance for instructors in a class

I have a form that is used to take attendance for 6 weekly sessions. The form populates a contact list for each class and calculates each participants progress during the 6 weeks using a JOIN DISTINCT COLLECT Participant@row formula.

There are 3 different cohorts of the same class going on at the same time. I have a sheet with each cohort that I want to display when they there attendance for each session individually.

Basically when the form recieves that they attended "Class 1" , I want the attendance sheet to show a checkmark in the colomn dated for class one. But it has to match up with the participant from the form to the attendance sheet.

Find more posts tagged with

Accepted answers

All comments

Tracy PIneda

Here are some Pics

Pic 1. The sheet the collects the attendance. If "Clase 1" is entered in the "Clase Asistida" coloumn for Testing Test participant, (Pic 2) then I want a checkmark or even just "Clase 1" to be entered in the coloumn with "Clase 1: 01/13/2021" that corresponds with the PARTICIPANT column.

Thanks

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.