Hello,
I've got a flow that is triggered by responses to a Form. What happens after the Form response is recorded is a fairly complex web of If "this" is true, then do "that."
To keep it more simple for the sake of my example, let's say there are 3 boxes - one that says "Type," one that says "Location," and one that says "Position." There are many options for each of those boxes, so let's use this table as an example:
Now let's say my goal is to make it so that IF Type = Verbal, AND Location = Philly OR NYC, AND Position = Associate OR Manager OR Assistant Manager, THEN send an email to PERSON1. But if IF Type = Verbal, AND Location = LA OR Chicago, AND Position = Associate OR Manager OR Assistant Manager, THEN send an email to PERSON2.
Below is a screenshot of how I have it setup now. It does trigger now, but not exactly the way it should.
Before, I had all 3 And/Or boxes set to AND, but it wouldn't trigger at all. Once I set them to Or, it triggers, but it's not checking that all the statements are true, only the first "Type" statement. So, since there's 4 similar scenarios, it's triggering all 4 of them instead of just the one.
I hope this makes sense and someone has encountered this before and can help, as it would be greatly appreciated!
Thank you.
