296
Logical "And" and "Or" functions
complete
J
JONATHAN MARTIN
Having the ability to due multiple searches with filtering is a crucial assets to useful apps. Getting results based on a series of combinations of data is essential.
Josh Johnson
complete
Launched! 🚀 You can now use both AND & OR functions when filtering lists and dropdowns! Watch this video to learn more. https://www.youtube.com/watch?v=lY_ZJgKwyIM
Activity Feed
Sort by
Tareef Roustom
I have just implemented it in one of my applications, and it's causing a drastic decrease in performance and app speed, could you guys look into it
Josh Johnson
complete
Launched! 🚀 You can now use both AND & OR functions when filtering lists and dropdowns! Watch this video to learn more. https://www.youtube.com/watch?v=lY_ZJgKwyIM
Devops
Josh Johnson: Nice one Josh! Keep up the good work 👏
Wolfgang Stöttinger
thanks Josh Johnson! does this also apply to conditional visibility and actions?
Devops
Wolfgang Stöttinger: Just checked and as of now it doesn't seem that this was applied to conditional element visibility.
Josh Johnson
Wolfgang Stöttinger: good question. We're starting with lists and dropdowns but we'd like to expand to to visibility eventually as well.
Josh Johnson
in progress
Josh Johnson
planned
D
Davit Gegia
Hello guys! I've created a new component with implementation of many logical functions in Adalo, maybe it will be useful for you.
Robbie Isaac
This enhancement would also be extremely useful when configuring visibility logic
Chris Duncan
This is the one thing holding my app back. If anyone knows a solution, let me know :)
J
Jeremy Southard
Chris Duncan: Sadly, the best I've been able to do is put multiple lists on the same screen and show/hide them based on another input. See the attached screenshot. The "Search By" dropdown list changes which list and search box are actually displayed. My biggest complaint here is if I change what is displayed in the list details, I have to change it in 3 places. It would all be so much easier if the list filter allowed "Name contains X" OR "Order Number contains X".

J
Jeremy Southard
Chris Duncan: Also, I came across this "hack" to combine multiple database properties for a search: https://youtu.be/ddf3dx-bIhs
Josh Johnson
Merged in a post:
"OR" logic in Custom Filter
amezousan
Why I want this
With Custom Filter, I'd like to look up content in a list by "OR" logic sometimes but not only "AND". As an example, I created two select forms and one simple list, but I can only use "AND" logic under the Custom Filter.
What I want
I want to have a possibility to choose either "AND/OR" logic in Custom Filter.
How I want this
From a user perspective, the design should be extremely simple. I'd like to have a select form to be able to choose "AND/OR" logic, as well as a help text which tells what the "AND/OR" means.

Matheus G. Spartalis
this is very important!! would solve many problems for querying data. I always come across the lack of OU during the development of the application logic.
D
David Weiss
A or B = not not (A or B) = not (not A and not B) so they will need to make it group able.
Load More
→