How can I apply multiple filters with OR conditions.
I want to create a search bar can search with event code or name.
![]()
Event table likes this.
CODE NAME
01 aaa
02 bbb
03 ccc
When I input in search bar “01”, I want result to display 01 Event.
When I input in search bar “bbb”, I want result to display 02 Event.
However, I think Adalo filter is AND conditions, so this picture settings not works I want.
So, how can I apply multiple filters with OR conditions or make this function.
