This View example displays the Group Participants in a specific group and the date (if applicable) that they filled out a specific form.

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 highlighted 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

• SELECT MAX