topic Re: Trigger Slack notification when 'Submission Status' count in a Survey123 form is less than 30 in ArcGIS Survey123 Questions

Trigger Slack notification when 'Submission Status' count in a Survey123 form is less than 30

AryamanBhattacharya_BeansAI — Mon, 05 Aug 2024 12:54:52 GMT

Hello ESRI Community,

I am trying to build a Make (formerly Integromat) scenario to watch a Survey123 and trigger a notification status count is less than a fixed number.

To elaborate, our Survey has a 'Status' question/field with a list of choices (domains) assigned to it, one of them being 'Work in progress'. Now, we want that a notification is triggered only when the count for 'Work in progress' is less than 10, lets say.

Suggestions or guidance on how to achieve this will be helpful.

Re: Trigger Slack notification when 'Submission Status' count in a Survey123 form is less than 30

jcarlson — Mon, 05 Aug 2024 13:11:57 GMT

Are you looking to sum values across multiple surveys, then? Or would your users be answering "work in progress" to 10 different questions in the same survey?

Re: Trigger Slack notification when 'Submission Status' count in a Survey123 form is less than 30

AryamanBhattacharya_BeansAI — Mon, 05 Aug 2024 13:22:33 GMT

Thank you for responding @jcarlson !

I'm looking to sum values across multiple surveys. Example screen shot :

Re: Trigger Slack notification when 'Submission Status' count in a Survey123 form is less than 30

jcarlson — Mon, 05 Aug 2024 13:52:52 GMT

All right, so what I would do in a situation like this is to take the survey webhook in Make and use its token to query the feature service.

The other fields in your POST would be:

query, with a value of status='work in progress' (but make sure to match the domain code, not the description)
returnCountOnly with a value of true
f with a value of json

Then have your flow parse the JSON of the response, find the count value in the JSON, and then set up a filter on the rest of your flow based on that value.

Re: Trigger Slack notification when 'Submission Status' count in a Survey123 form is less than 30

AryamanBhattacharya_BeansAI — Fri, 09 Aug 2024 10:42:06 GMT

Thank you for your suggestions @jcarlson ! Your suggestions helped us setup the desired Make scenario. Based on our chat internally, adding the JSON parser to the flow helped set up the alert based on count.

Thanks again!