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
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
Rae
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?
Rae
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.
A
Abhishek Singh
Any update on the release date? Josh Johnson
This will help in building powerful filters.
Josh Johnson
Abhishek Singh: We're progressing well! You should have something to try out in January :)
F
Francisco Caeiro
Josh Johnson: This will be great and it is a major limitation currently so looking forward to it :)
Oleksandr Kyrylov
Josh Johnson: Any news on progress?
Josh Johnson
Oleksandr Kyrylov: SOOOOOOO close. We're doing QA on the final two cards :)
Josh Johnson
in progress
Josh Johnson
Currently, all our filtering logic is AND. In this cycle, we're going to add OR functionality as well so you can build more complex filters.
Paul H
Josh Johnson: Will this include display conditions too? So display if x or y? And will it support multiple conditions e.g. X and Y or Z?
Josh Johnson
Paul H: It will support things like (X and Y) or Z, but for now we're going to start with list filtering. Visibility is definitely one area we want to expand it to in a later launch though!
C
Ch
Josh Johnson: Hello, so no "if" condition is scheduled with the "or" improvement of list ? It's tricky when you want an user to pick some criteria to filter but he doesn't set all of them (ex : color, condition, brand..)
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.
Mitch
Not having this is a major stumbling block.
Working with "real" developpers, there's always hesitation about low code platforms. Having to go explain that I can't do 'or' logic isn't something I'm looking forward to.
'And' is technically possible in filters.
Both need to be brought to conditional visibility
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.
Load More
→