- 3,675,642 Users
- 11,611 Discussions
- 18,535 Comments
Using Eloqua's Update Rules to update multiple fields in backend
Run a training series (around 15 of them), all in different cities all on different dates. The stakeholder requested to have only one form with all the events listed and attendee will select a training session from the drop-down within the form
Here comes the challenge, they requested to get all the attendees to go under different unique campaign identifiers so different teams within different cities could respond accordingly.
Our Preferred Option: Use the Eloqua platform and its functionality to get the result; It is more complex but secure.
Upon form submission, the event name is used to update multiple fields in the database using “Shared Update Rules”.
Step by Step
Assumption: The user has a basic knowledge of using Eloqua forms
1 - Create an HTML form with the dropdown list. Define name and values for those value will be used to drive values t in upcoming steps.
2 - Set up processing steps.
3 - Add “Update Contact - With Custom Values”
4.1 - Go to Contact> Tools > Form Update Rules and hit new button at the top right corner of the page
4.2 - After click on the new button the popup will open with option to “Add Shared Update Rules Set”
4.2.1 - Complete the “Update Rule Set Name” field with a Name that is consistent with the form name so they can be easily associated if they need to be edited in the future.
4.2.2 - Select the data field to identify the contact. For this example, we will use “Email Address” then add the rule.
4.2.3 - Click on “+ Add Update Rule”Select the field selection list icon
4.2.4 - In the“Entity Field Search” popup, search for the field needed to update. In this example, we will update a Campaign ID (Unique Identifier) and Content Name.
4.2.5 - Select the field to update.
4.2.6 - Select “Set to Value” option in the “Select an update action” and add the value to be amended and hit “apply”.
4.2.7 - After hitting “Apply”, the preview will show the action. If looks correct? click save or “add more” to add more rules.
4.2.8 -Now complete, add the Update Rule to your form processing steps.
6 - Select the update rule and hit “Apply”. The rule will now appear on the processing step
8 - Lastly, add the condition to trigger the update. Click on “Conditionally” and add the condition by selecting the field name listed
9 - The condition will depend on the value passed from the HTML form submission. In this example, the condition is if an attendee has selected the “Atlanta” event.
Upon selecting Atlanta (or any city) in our scenario, the Eloqua form processing will update multiple fields. The contact can now flow into a designated shared list as well as a CRM system correctly attributed to the selected event.
One of the biggest benefits of using Update Rules is that internal data changes are handled through Eloqua and not exposed to the attendee. Their view and experience is seamless.
Lastly, in the future if more field updates are requested by our stakeholders, we can easily add that in update rules without even touching the front end.