Participant Opportunity Reponse from Form Responses

GOAL: Add Responses based on Form Response Answers to specific Form Fields through Form Responses. 

CRITERIA: Responses will be created for Form Responses when: 

  1. The Form_Response is not assigned to the Default Contact 

  2. Assigned to the Form_Response there is a Form_Response_Answer assigned to a Form_Field that is configured to create a Response 

  3. A Response does not already exist for the Contact that was created from the same Form_Response_Answer 

  4. The Form Response was submitted in the last 90 days 

RESPONSE RECORD CREATION

When Response records are created the fields will be populated as follows: 

Contact - Contact of the Form Response 

Response_Type - As configured in the Form Field settings 

Response_Date - Form Response Response Date 

Comments - Form Response Answer text

Domain_ID = DomainID of the Form Response 

TO SET UP

For each Form Response Answer that needs to trigger Response creation take these steps: 

  1. On the Form Builder page, edit the desired Form 

  2. For the relevant Form Field, configure it to create a Response 

  3. Set the Response Type that should be created 

SCHEMA DETAILS

No schema changes were required for this automation. 

ROUTINE DETAILS

A nightly routine will create Responses for any Form_Response_Answers that have been submitted in the last 90 days and meet the criteria of the Form Field.

Documented in MP here:

https://my.northway.org/mp/366/73