Hi everyone, I have a scenario in Make that is watching a survey123 survey. For those unfamiliar survey123 is a form tool/app for collect record info from end users. Users collect a ‘survey’, fill out attributes(columns), and when they submit a new row is added to the underlying table.
The webhook in the scenario sends a payload to make as a json object which has all the info from the attributes for a new survey. I am trying to collate these new surveys for the day, and send them to an email address in ONE email.
Seems simple but the fact I am trying to aggregate these into one email is making things complicated. I have tried using the text aggregator tool but it will not work. I still have items hanging in the queue instead of being brought into the scenario. So I need to:
- Read all items in the queue for the day
- Aggregate these into one text block to send as an email
- Format appropriately with newlines between attributes and 2-3 newlines between surveys
What tools do I need to use to do this? Thank you!
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of three modules:
This is just an example. Your final solution may or may not look like this depending on your requirements.
1. Run scenario DAILY
2. Aggregate with three new lines (br tag in HTML) below
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Thank you very much for the response. My email is formatted correctly now so that solves that issue.
However it still only processes one item in the queue and sends it in the email. I want it to include all items in the queue. Is there an option in the text aggregator or survey123 tool to make this happen?
Thanks again.
I don’t use Survey123. You’ll need to provide screenshots of the module, including advanced fields, if any.
It also could be as simple as scheduling your scenario to run on a schedule instead of “immediately”, or setting the cycle to a higher number, or setting the “Bundle limit” in the Trigger module to a higher number.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Sam, here is an image of the survey123 inputs.
I am pulling in the feature attributes, which are all straighforward text fields. There are other things I could get from this but for this project I’m just using these text columns like a regular table. This is in relation to fire hydrants so you can see attributes like id, address, defects, inspector, etc.
Increasing the cycles allowed all of the surveys in the queue to be processed so thats great, but they are still being sent in separate emails. If I wasn’t expecting too many surveys to be completed per day that would be fine, but we could have 50 or more per day. So I need to combine these into one email so the person I’m sending these to doesn’t get 50 separate emails.
This is how I have my text aggregator setup. Its formatting the text per survey correct but not combining all the survey payloads together.
Thanks,
