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.


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

                                                                                                              • Granting access to Zoho Tables

                                                                                                                On your iPhone, go to Settings > Zoho Tables. Grant access to contacts 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. ...
                                                                                                              • 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 ...
                                                                                                              • Siri commands, Spotlight search, and app shortcuts

                                                                                                                Siri commands After installing the Zoho Tables app, you can use Siri to interact with your Zoho Tables bases easily. Enabling Siri for Zoho Tables Setting up Siri: Siri should be enabled for Zoho Tables by default, but if not, follow these steps: ...
                                                                                                              • 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. ...
                                                                                                                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