Multi criteria filter
Hi
I want to make a filter of all German and / or French customers but it only works for one or the other. What's the problem
Michel
8 replies
-
What kind of field are you using?
-
Hello Michel. If you mean a filter in a views table, it needs a specific syntax. Take a look here:
https://ninoxdb.de/en/manual/tables/views-filtering-values
Fabio
-
Thank you fabio but I tried everything it does not work
German and French
"German" and "French"
= "German" and "French"Yes filter in a views table
I also tried with or ..... but nothing
-
mmhh.. in some cases, filters can not be implemented through the mechanisms described in the Filtering Values section.. In these cases the trick is to define the filter over an additional calculated column:
Use the function “Show columns…” from the View menu --> drag a formula in the list of visible columns --> in this formula, you can set: 'Customers = "German" or 'Customers' = "France" so that it returns a Yes / No value --> then you can create a filter for this calculated column to “Yes” or “No”.
P.S.
Today it will be the Ninox Webinar EN at 6:00 PM. If you can participate you will find useful ideas to improve your DB (and ask questions if you need)
:)https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg
Fabio
-
Maybe try like in stead of =
like "German" and like "French"
I haven’t test it dough.
-
Works with "or"...
like "German" or like "French"
-
Thank you all. The solution proposed by Steven and Nick works perfectly
-
Perfect it works, thanks
Fabio
Content aside
- 5 yrs agoLast active
- 8Replies
- 2528Views