I have a gallery that has 4 columns, "Building", "Call Type", "Comments", "Date/Time" & I want the user to be able to filter any combination of the above columns.
I currently have it working for 2 fields with a nested "And" "Or" filter, but need to add another 2 conditions, but totally confused with the nested layout.
The current working code is... and allows me to filter a combination of either "Call Type" or "Comments" or both together. I now need to add 2 more filters. What is the correct nested formatting.
Filter('Calls Logged',
And(
Or(
IsBlank(ComboBox1.Selected.Value),
IsEmpty(ComboBox1.Selected.Value),
'Call Type'.Value = ComboBox1.Selected.Value
),
TextInput2.Text in Comments Or IsBlank(TextInput2.Text)
))
Thanks in advance
