Skill level: Medium
Time required: 6 minutes
This article explains how to use Formula mode in Quickwork to format multiple rows of data (as shown below) into a single, readable message for messaging platforms, avoiding the clutter of multiple unreadable messages from a Foreach loop.
A neatly structured single message where each row appears on a new line, making the data visually appealing and easier to read.
Prerequsites
- A Quickwork account and and familiarity with the platform's GUI.
Using Formula mode for data formatting
1. Build a journey in Quickwork to format multiple rows of data from Google Sheets into a single, structured message using Formula mode and send it via WhatsApp by Gupshup.
2. Toggle the Message field to Formula mode and write a map() function. This function converts rows of data into a single string, where each row is joined by newlines \n, ensuring each row appears on a new line.
This approach ensures that the data is sent as a single, readable message, enhancing user experience.
Comments
0 comments
Please sign in to leave a comment.