Evaluating Monday Status column for Filter

Hi all,

I’m trying to set up a filter to evaluate a Status column from Monday.com and let the Scenario move ahead if the Status has been set to “Yes.”

I’m trying to use in my filter:
Condition:
{{get(map(3.value.label.index; “index”); 1)}}

Numeric Operators: Equal to 1.

When I test it by selecting either “yes” or “no” on my board, I get an error -

“Failed to evaluate filter ‘0-0’: Function ‘get’ finished with error! Function ‘map’ finished with error! ‘5’ is not a valid array.”

Any thoughts where I’m going wrong would be much appreciated. Thanks in advance.

Hey @GregG1,

What you could do, is use the ‘Watch Board’s Column Values’, select ‘Item’s Specific Column Value Update’ in the Webhook and then use a simple text filter.

Here’s how you the webhook is set up:

The output of which is this:
image

And here’s how the filter is set up:

Hope this was helpful!

2 Likes

@GregG1

The specific syntax to reference the correct value in your filter will depend somewhat on the module that is providing the data.

Generally, monday status column values can be referred to directly as part of the “mappable column values” array, e.g., {{4.mappable_column_values.status1.index}} or {{4.mappable_column_values.status1.text}}.


Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)

1 Like

Thanks, @JimTheMondayMan and @NocodeNoah!

I’m pretty sure I’m doing the mapping wrong, even after all of your help.

Here’s my module:

Here’s my filter:

As you can see, I’m not getting the Value: Label: Text option in the details from step 1 (it is module 5 in this case, because I’ve edited this so many times).

Here’s what comes back when I toggle that status column:

And here’s what the filter does - stopping on Yes, when it should proceed:

How have I still gotten this wrong? Thanks again for any suggestions!

@GregG1

You need to be referencing “text” in “label” in “value”. If you update the filter AFTER running and triggering the Watch Board’s Column Values, you should be able to get that.

It will end up like this:
{{1.value.label.text}}


Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)

1 Like

Thank you, again, @JimTheMondayMan!

I didn’t realize the value of running a scenario from the diagram view and that it would reveal more options for building the scenario. That is supremely helpful.

With that knowledge and the filter updated as described, my scenario is running just as desired now.

Thanks again again,
Greg

2 Likes

@GregG1

You’re welcome. Glad you got it working!


Jim - The Monday Man (YT Channel) Our latest vid: Reading REALLY Large monday Boards - Part 2
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)

1 Like