How to display a list based on a relationship, 2nd level?

Get Help
1

I’m new on Adalo and have gone through a ton of the tutorials and searched this forum with no clear analogy.

I’m building a list management app and have run into a perplexing issue.
When a user logs in they start with their “list of lists” (think “weekly groceries,” “things to read,” “calls to make”). Zight 2025-01-05 at 12.14.5...

They click one of their lists and see the list’s categories. Zight 2025-01-05 at 12.21.5...

So far, so good. The problem is that when they click a category to expand it, instead of showing the items in that category (e.g., “bakery”), they see all of the items in the list. Zight 2025-01-05 at 12.22.0...

I’ve tried a bunch of different configurations of the Simple List to restrict it to the items relating to the category clicked, with no luck. It currently is this: Zight 2025-01-05 at 12.22.2...

On the database side, the hierarchy is 1>M List → List Items, with Category as a M>M relationship with List Items. Categories should be able to have multiple levels to allow for subcategories, which is what their “level” field designates. Categories also have a M>M relationship with Lists so the user can pick which of the categories should be available in each list.

I have not yet been able to figure out how to allow a list to be added and have the user select which Categories it should have. So suggestions to do that would also be very welcome.

But in the meantime, how do I get that displayed list to show just “bakery”-level items and not all the items in the list?

Thanks!

2

Hi,

If each user is going to tap from the same lists of items to make theirs, you will need to :

  • create a new list for each type for each user in a new collection named “users lists”
  • the relationship would be 1>m user>lists, let’s name it “my lists”
  • you’ll need to add a relationship between the base items and the new collection “users lists” and it would be 1>m list>items
  • after a screen to create the list, users would be redirected to the items list, with a toggle make them add/remove the item from current list (the one that has been just created)
  • on the screen for my lists, show only the lists created by the user
  • to display the list’s items filter (my list’s items)