Example: Show events attended by employees on an Organization’s contact record¶
The example below describes how you can use FormBuilder and SearchKit to show all the events attended by the employees of an Organization on the Organization’s contact record .
Step 1: Create the saved search¶
- Navigate to Search > SearchKit.
- On the Submission Forms tab, click the New Search link.
Step 2: Add SearchKit settings¶
- Give the search a title ‘Events Attended By Employees’.
- On the Search For tab on the left:
- Click + Entity and choose Contact Related Contacts, change it to With (required)
- Click and change the Relationship to Contact value to Employee of
- Click + Entity and choose Contact Related Contacts - Contact Participants, change it to With (required)
- Click + Entity and choose Contact Related Contacts - Contact Participants - Participant Event, change it to With (required)
- On the Select Fields tab on the left:
- Click on the x symbol to remove Contact ID, Sort Name, Contact Type, Contact Subtype.
- Leave Event Title
- Still on the Select Fields tab, use the + Add Field drop down to include:
- Contact related contacts - Contact Participants - Participant Event - Start Date
- Contact related contacts - First Name
- Contact related contacts - Last Name
- Contact related contacts - Primary Email
- To add a display, click on + Add on the lower left hand side of the screen and choose Table.
- Give the Table a name, this name will show on the contact screen as the tab title.
- Click Sorting, choose Contact related contacts - Contact Participants - Participant Event - Start Date and change the order to Descending
- Click Columns > Use Custom Columns
- Click the down arrow on Event Title and edit the Header text to be Event Name.
- Click the down arrow on Start Date and edit the Header text to be Event Date.
- Click Save at the top of the screen.
Step 3: Complete The Form¶
At the top right of the page, click the Forms link. Choose Create form for Events Attended By Employees. This will then open FormBuilder in a new browser tab.
In the newly opened tab, use the configuration pane on the left side to configure the following settings for your form: * Title: Events Attended By Employees * Placement: Contact Summary Tab * Contact Type: Organization * Click Save at the top of the screen.
If you now go to an Organization Contact record, that has employees who have attended an event, they will be displayed in a new tab on the record ‘Events Attended By Employees’.