The 'Add Field Summary' feature allows you to dynamically insert aggregated data from your table into email or message content.
If you're a sales manager aiming to report the total revenue from successful deliveries each month, you can automate this with a field summary.
How to include records in messages?
Choose Send Email or Send Zoho Cliq Message as the action to notify your management.
In the message body, click where you want to insert the summary field(for example, after a brief introduction or a list of records).
Click the plus (+) icon on the right side of the message box.
From the dropdown menu, choose Add Field Summary.
In the right panel, choose the Orders table that contains delivery data.
Choose the field you want to summarize- for e.g., Total Amount.
Choose Sum as the formula to calculate the total revenue for the month.
Close the panel and complete the automation set-up. The field summary will now appear in the message content.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
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.