Integromat Send Mail when Survey Reaches Specific Percent of Project Completion

[Cyprus_Forest_Department]

Hi to all.

I have a survey that has as a target 1500 records to be collected.

I want integromat to send an email when e.g 50% of the records have been collected.

I played around with setting up filters as the pictures show, but to not avail.

Anyone have discovered a way through?

Thanks in advance.

[AndrewBowne]

This will only fire if your objectid is 750.  It's possible that you could skip past that OID if a record is added using a method other than S123.  What about setting a range of, say, 5 records?  That way you would ensure an email if one of those 5 entries are made.  Downside is that you will receive up to 5 emails.  I don't know if that would be a concern of yours.

[Cyprus_Forest_Department · Accepted solution]

Ok, found the solution.

Integromat has an operation that can be found at the bottom side of the scenario diagram, under tools.

Its called Increment Function. 

You put this operation between the survey123 operation and the router.

You set then the email filter based on the increment function and it works.