Group Participant Form Submissions
This View example displays the Group Participants in a specific group and the date (if applicable) that they filled out a specific form.
Difficulty: Advanced
Page: Group Participants
Features: Adds a field to show whether when or if a specific form was filled out.
To create a View that lists all the Group Participants from a group and whether they have filled out a specific form.
Field List
Replace the value with appropriate Form ID:
Participant_ID_Table_Contact_ID_Table.[Display_Name] AS [Display Name]
, Group_ID_Table.[Group_Name] AS [Group Name]
, (SELECT MAX(FR.Response_Date) FROM Form_Responses FR JOIN Contacts C
ON C.Contact_ID = FR.Contact_ID WHERE FR.Form_ID = 1
AND C.Participant_Record = Group_Participants.Participant_ID) AS [Church Agreement]
View Clause
Replace highlighted value with appropriate Group ID:
Group_ID_Table.[Group_ID] = 292
Variations
View All Group Participants With Specific Role Type
Field List (Replace highlighted value with appropriate role type ID):
Group_Role_ID_Table_Group_Role_Type_ID_Table.[Group_Role_Type_ID] = 1
Techniques
- SELECT MAX