Actions

Actions

Zoho Tables offers three types of actions now. They are:

Let's try to understand how these individual actions work.

a) Send Email

This action allows you to send an email to the selected email addresses when the trigger event occurs to execute the automation. 
In the example below, an email is sent to the digital marketing manager every time a post is published.

Choose a trigger
Select the table named "Posts" and choose the trigger, "When record is updated". 


Choose a trigger gif

Customize the condition
Click on "+Add Condition" to set the filter condition as Status is any of Published.


Customize the condition gif

Add the action
Now, click +Add Action & Select Send Email
Enter your digital marketing manager's email ID, subject line & custom message.

Note: Ensure that you enable automation to complete the process.


GIF - Showing Action & Automation output

In the above GIF, you can see the digital marketing manager receiving an email once the status of the record changes to "Published" on the table named "Posts".

FAQs

1. What is the default sender's email address? 
Ans. The sender's email address is no-reply@localnotifications.zohotables.com

2. Can we add attachments to the automation email?
Ans. As of now, Zoho Tables does not support adding attachments to an automation email. We are working on incorporating this feature and it will be released soon.

3. How can I format the emails I send out?
Ans. You'll be able to format the emails in the future version using the Rich text editor.

4. Can you only send automation emails to the base collaborators?
Ans. No, we can also send emails to recipients who are not collaborators of the base.

5. Can you send an automation email to more than one email address?
Ans. Yes, we can send emails to multiple email addresses.

b) Create record

This action allows you to create a new record in your base when the trigger event occurs to perform the automation. 

In the below example, as part of our content creation process we have a table consisting of all the content that needs to be reviewed by the manager. What if we want to create a separate table that shows only the list of content that is approved upon the review process? This can be achieved using Create record.

Choose a trigger
a) Select the table "Content Review" which shows the complete list of content to be approved. 
b) Choose the trigger, "When record matches a condition".


Choose a trigger gif

Customize the condition
Click on "+Add Condition" to set a condition where the trigger sets off every time the field, Approved is ✔(checked). 


Customize condition gif

Add the action
a) Click + Add action and choose the action "Create Record". Select the table "Completed"  (where the new record will be created). 
b) Click + Choose field 
c) From the combo box, click the + icon to select the desired field value(s) that you want to populate into the "Completed" table we created. You can choose as many fields as you prefer.
Note: Ensure that you enable automation to complete the process.

See it in action
In the below GIF, you can see the list of approved contents created as new records in a separate table "Completed".


GIF - Showing Action & Automation output

FAQ

1. When a record is created on a new table, how do we ensure that all the fields from the previous table are also inserted? 
Ans. While adding the action, under the section fields ensure you insert each field from the original table. You can select as many desired fields by clicking the +icon from the combo box.



There could be instances where the field names between tables may not exactly be the same, so make sure to double-check if you're mapping the right field names together.

c) Update record

This action allows you to update the existing records in your base when the trigger event occurs. 

In the below example, as part of our job delegation process, we want to update the department manager's name based on the assignee's job type.
        
Choose a trigger
Select the table "All Departments" and choose the trigger, "When record is updated". 


Choose a trigger gif

Customize the condition 
Click on "+Add Condition" and set the condition as Job Type is any of Marketing Lead/Product Marketer/Content Writer/ Product Marketing Associate.


Customize the condition gif

Add the action
a) Click + Add Actions and choose the action "Update record". Select the table "All Departments" where you want to update the record.
In this case we use the same table for both trigger and action.


Add the action gif

b) Now update your record condition to filter out the exact Record you would like to change from the list of records available.
 
In this case, to update a record with the trigger step, repeat the same condition. 
click + Add Condition and choose Job Type is any of Marketing Lead/Product Marketer/Content Writer/ Product Marketing Associate. 


GIF showing record condition 

c) Now choose the field that needs to be updated. Click + Choose field, and select the field "Manager". 
Then, choose the value with which the field must be updated. In the below example, we have selected the manager "Olivia" from the dropdown menu.


GIF showing choose field and value

Note: Ensure that you enable automation to complete the process.

See it in action
In the below GIF, you can see the department manager's name being updated based on the assignee's job type.


The above GIF showing the automation output gif

FAQs

1. Can multiple records and fields be updated using the update record action?
Ans. Yes, you can update multiple records and fields in one go using the update record action.


    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION









                                    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.




                                        Manage your brands on social media

                                          Zoho Desk Resources

                                          • Desk Community Learning Series


                                          • Digest


                                          • Functions


                                          • Meetups


                                          • Kbase


                                          • Resources


                                          • Glossary


                                          • Desk Marketplace


                                          • MVP Corner


                                          • Word of the Day


                                            Zoho Marketing Automation

                                              Zoho Sheet Resources

                                               

                                                  Zoho Forms Resources


                                                    Secure your business
                                                    communication with Zoho Mail


                                                    Mail on the move with
                                                    Zoho Mail mobile application

                                                      Stay on top of your schedule
                                                      at all times


                                                      Carry your calendar with you
                                                      Anytime, anywhere




                                                            Zoho Sign Resources

                                                              Sign, Paperless!

                                                              Sign and send business documents on the go!

                                                              Get Started Now




                                                                      Zoho TeamInbox Resources



                                                                              Zoho DataPrep Resources



                                                                                Zoho DataPrep Demo

                                                                                Get a personalized demo or POC

                                                                                REGISTER NOW


                                                                                  Design. Discuss. Deliver.

                                                                                  Create visually engaging stories with Zoho Show.

                                                                                  Get Started Now









                                                                                                      • Related Articles

                                                                                                      • User Roles and Permissions

                                                                                                        User Roles and Permissions: Zoho Tables lets you assign permission of different levels to users to access your portal, workspace or base. This ensures that the right access is given to the right person to access the right information without having ...
                                                                                                      • Activity Log

                                                                                                        Activity logs help you keep track of activities performed by all the collaborators in the base. It allows you to stay on top of all the changes and refer to who made what changes and when. How does it work? At the top right corner of the table, Click ...
                                                                                                      • Granting access to Zoho Tables

                                                                                                        On your iPhone, go to Settings > Zoho Tables. Grant access to photos by selecting the access type. This lets you upload images from your Photos app. Grant access to the microphone. This lets you upload voice recordings directly from your iPhone. ...
                                                                                                      • What is Zoho Tables Automation?

                                                                                                        Zoho Tables Automation is a powerful feature that helps you eliminate repetitive tasks and processes by setting up "automation" triggered by specific events or conditions that streamline your workflows. In turn, tasks become more efficient, accurate ...
                                                                                                      • Kanban View

                                                                                                        Kanban view With Kanban view, your records are displayed as cards categorized based on a parameter of your choice, allowing you to manage your objectives more efficiently. You can create multiple Kanban views in any table inside Zoho Tables using the ...
                                                                                                        Wherever you are is as good as
                                                                                                        your workplace

                                                                                                          Resources

                                                                                                          Videos

                                                                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                          eBooks

                                                                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                          Webinars

                                                                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                          CRM Tips

                                                                                                          Make the most of Zoho CRM with these useful tips.



                                                                                                            Zoho Show Resources