Multi criteria filter
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
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:
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”.
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)
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
- 4 yrs agoLast active