Unusual filtering

Questions
1

:bullseye: What is your goal?

To filter bundles coming from a Google sheet into one of two path

:thinking: What is the problem & what have you tried?

unusual filtering

:clipboard: Error messages or input/output bundles

refreshed

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Screenshot (72).png
Screenshot (72).png1920×1080 248 KB

Screenshot (71)
Screenshot (71)1920×1080 293 KB

3

And what is unusual about the filtering?

4

bundle should go in filter 1 but goes in 2

5

Hi @learn2,

It looks like a filter configuration issue. Please cross-check that the filter conditions are set correctly on each route. If the issue persists, please share the filter settings so we can troubleshoot the issue further.

Best Regards,
@Mohamed_Jahar

6

Hello,

If you are using filtering by Payment method (col J) you have there value Trial (capital T) but you named filter as trial (lowercase).
Of course name =/= what you actually put into filter settings but that’s my guess where your problem is.
If you have not selected case insensitive and put col:J=trial as filter - there is your issue.
Have a nice day,
Michal

7

Have you checked your filtering conditions? Make sure the cases used in the conditions is the same as the Google Sheets; the same goes for the titles

8

sorted that filter but on another senario

Screenshot (85)
Screenshot (85)1920×1080 221 KB

Screenshot (86)
Screenshot (86)1920×1080 312 KB

trying to set up a for a single value, The attached filter does not work

9

I would separate two cases that look similar but need different filters:

  1. the field should equal one specific value;
  2. the field should contain only one value.

If the Google Sheets cell is comma-delimited text, Make will not treat it as an array automatically. So for case 2, either check that the text does not contain a comma, or split the text first and check that the split result has length 1.

For example, the logic is:

split the cell by “,” → trim the pieces → check length = 1

If you actually mean “only pass rows where the value is Trial”, then use a text equals condition on the cell value, and watch for case / extra spaces. The filter name itself does not matter; only the condition inside the filter does.

10

Hello,

Why your filter is not working?

You are using Array operators: contains which works with arrays but you have string/integer value, in your case integer =0.

How to solve it?

Please let me know what other values shipping (col: K) can contain - is it 0-1 (0 for one, 1 for >1) or 0 is for one ship item and 1 is for 2, 2 is for 3 etc.

Anyway you should not refer to array if your value is string/integer. Use text or number operators.

Tip

I would strongly suggest calculating number of shipments inside Google Sheets and return value in dedicated column. It will make your workflow more stable and easier to debug as if any changes will be made in Sheets it will handle shipment calculations on its own.