How do you filter by multiple users in Adalo?
Use relationships and current filtering operators to show records connected to one or more users.
We checked current official documentation, captured the relevant screens, and compared the workflow with dated Adalo forum reports. Source links and limitations are below so you can judge the evidence directly.
Model the user-to-record connection first, then filter the list using relationship Contains rules and explicit AND/OR behavior. Many-to-many comparisons have platform limitations, so test the exact relationship shape.
Write the intended set rule in plain language before configuring filters: match any selected user, every selected user, or the logged-in user plus another condition. Model that relationship explicitly and test records that differ by only one membership. A join collection often makes roles, dates, and debugging clearer than a dense direct many-to-many relationship.
The intended outcome
A filtered list whose rules clearly express which user relationships qualify.
Requirements
- Defined relationship cardinality
- List of records
- Representative multi-user test data
Step by step
- 01
Write the rule in plain language
Decide whether records must contain all selected users, any selected user, or one current user.
- 02
Inspect relationship shape
Confirm whether the record has one user, many users, or a join collection.
- 03
Add filters independently
Prove each Contains or relationship rule before joining filters with AND/OR.
- 04
Test overlaps
Use records connected to neither, one, and multiple users.
The underlying logic
Filter operators compare the current record’s relationship to selected user records.
Current Adalo documentation notes limitations when comparing many records with many records.
Data model
| Collection | Important properties | Relationships |
|---|---|---|
| Users | Name, Role | Has many memberships |
| Records | Name, Status | Has many memberships |
| Memberships | Role, Joined Date | Joins one user to one record |
What changed?
- The refreshed model recommends a membership collection when relationship context or clearer queries are required.
Common failure modes
A many-to-many comparison is unavailable
Use a join collection or reshape the query around a one-to-many relationship.
Testing checklist
A record related to only the first selected user appears under an OR rule.
A record missing one selected user is excluded under an AND requirement.
No selected users produces the deliberately chosen default result set.
AND/OR matches the written rule
Overlap cases are tested
Empty selection behavior is intentional
Current limitations
- Many-to-many comparisons can be difficult to express and must be tested with the exact relationship shape.
Screenshot evidence
These captures document what Adalo currently publishes and what builders are reporting. They support the written guidance, but they are not a substitute for an end-to-end test in your own app.
What the Adalo community is reporting
These are concise editorial summaries of public forum posts—not endorsements or independently reproduced results.
From Structure to Connections
The discussion recommends intermediary join records for flexible many-to-many cases and explains that metadata such as role or joined date belongs on that record.
Boundary: These are practitioner recommendations; the exact AND or OR expression still depends on the available data context and must be tested with representative records.
Ali-Bazzi, michaelappdev, and replies · December 2025–February 2026Sources and status
This page was last reviewed on Aug 12, 2026. Its current status is Verified from current public evidence.
Verification owner: Adalocado editorial. Next review: Oct 12, 2026.
Changelog
Added current custom-filter and join-collection captures plus recent relationship reports.
Did this solve your problem?
Bring us the messy version.
Describe what you expected, what happened instead, and what you already tried.
Ask Adalocado
