Opt in/out of email subscription
Requirement
Users should be able to choose if they want to subscribe to or unsubscribe from a periodic newsletter email.
Use Case
A fintech company sends monthly newsletters to its customers. Customers should have the option to subscribe or unsubscribe to the newsletter at any point of time.
Steps to follow
1. Create two forms with the following details.
Form | Form Link Name | Field Type | Field Name | Field Link Name |
Opt In | Opt_In | Add Notes | I want to receive updates | plain |
Name | Name | Name | ||
Opt Out | Opt_Out | Add Notes | I do not want any further updates | plain |
Name | Name | Name |
The Opt In form is used by customers to sign up for the monthly newsletter. The Opt Out form is used by customers to unsubscribe from the monthly newsletter.
2. Create workflow with the following details to restrict duplicate email IDs.
We are using the Form Event as Validations on form submission so that the entered email address can be checked before the data is added to the database.
3. Click Add New Action and add the following snippet in the Deluge editor.
- // check if any duplicate records exist and alert the user if yes
- duplicate_records_count = Opt_In[Email == input.Email].count();
- if(duplicate_records_count != 0)
- {
- alert "This email is already registered for updates";
- cancel submit;
- }
Note: The No duplicate values field property can also be used to prevent duplicate entries. However, we have used the script to display a customized alert message.Now let's add workflows to the Opt Out form to achieve the following:
- Disable Name field
- Fetch data and populate Name field based on the entered email address
- Display an alert when then entered email address does not exist in database
- Remove the email address from Opt In form after form submission
4. Create workflow with the following details to disable the name field.
5. Click Add New Action and save the following snippet in the Deluge editor.
- disable Name;
6. Create a new workflow with the following details.
The Form Event is selected as User input of a field so that the corresponding Name value can be fetched when an email address is entered.
7. Click Add New Action and save the following snippet in the Deluge editor.
- // fetch the record containing the email address
- fet = Opt_In[Email == input.Email];
- // if the record exists, assign the corresponding name to the Name field, and display an alert to the user that the email will be removed from the list
- if (fet.Email != null)
- {
- input.Name = fet.Name;
- alert ("This email is registered with the name " + input.Name) + " and will be removed from the updates list";
- }
8. Create another workflow as below to display an error if the email is not found/subscribed
We are using the Form Event as Validations on form submission so that the entered email address can be checked before the data is added to the database.
9. Click Add New Action and save the following snippet in the Deluge editor.
- // fetch the record containing the email address
- fet = Opt_In[Email == input.Email];
- // if the email address is not found, display an alert and restrict the form submission
- if(fet.Email == null)
- {
- alert "This email is not registered for updates";
- cancel submit;
- }
10. Lastly, create a workflow as displayed, to remove the email address from the subscription list on successful form submission.
11. Click Add New Action > Deluge Script, and save the following script in the Deluge editor.
- // delete the record in Opt In form which contains the specfied email address
- delete from Opt_In[Email == input.Email];
See how it works
Points to note
- Permissions can be used to hide the reports from users.
- The email list in the Opt In form can be used to send periodic emails or newsletters using schedules.
Related Links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
FAQs: Understand Forms
This page covers everything you need to know about Zoho Creator, from creating and customizing forms to collecting, editing, and deleting data seamlessly using stateless forms. What is a form and its purpose? Forms serve as a user interface, ...Insert records through email
Requirement When an email is received, content from the email is extracted and used to create records. Use Case The HR team sends an email to shortlisted candidates. Candidates can reply to the email with details that are extracted and added as ...Copy data from one Address Field to another
Requirement Copy one Address field to another automatically while filling out a form. Use Case An online e-commerce application generally would ask every customer to enter separate billing and shipping addresses. Sometimes, people have both the ...Limitations: Workflows
Workflow execution A maximum of 120 workflow action calls (requests) can be executed per minute and per IP address. This count includes the execution of the following: Script in the on load form event Script in the on user input form event Script in ...FAQs: Sending Email Notification - On Successful Submission
This page covers effectively managing email notifications for form submissions, including customization, verification, and optimizing communication channels. What is email notification on form submission, and how can I enable it? Email notification ...
New to Zoho LandingPage?
Zoho LandingPage Resources