Creating an Image List Filtered by Shared ChildrenID Across Users

Get Help Database
1

Hi Everyone!
So, here is the deal. This doesn’t work. I need a workaround. The filtering is stuck, and if you have been here in Adalo long enough, you might have figured out why. So, if you are kind enough, I would appreciate your help.

Users are associated with one or more ChildrenID values through a relationship with a collection called ChildrenID. For example, a user can have 2 ChildrenIDs linked to their account.

I want to create an image list that displays images uploaded by any user who has a ChildrenID matching the value I enter into a field called ChildrenIDInput on my user account. This means:

  • The images displayed should belong to users who have a ChildrenID that matches the ChildrenIDInput value I entered.
  • The filtering should work even if the images were uploaded by other users, as long as the ChildrenID is the same.

Key Relationships:

  1. Users Collection:
  • Has a relationship with ChildrenID (one user can have multiple ChildrenIDs).
  • Contains a text field called ChildrenIDInput where I can enter a specific ChildrenID to filter the list.
  1. ChildrenID Collection:
  • A collection that stores all the ChildrenID values and their relationships with users.
  1. Little Moments Collection (Images):
  • Stores images uploaded by users.
  • Has a relationship with the Users collection but no direct relationship with ChildrenID.

Goal:

The image list should filter and display images based on:

  • The ChildrenIDInput I enter in my user account.
  • Images uploaded by users who have the same ChildrenID as the value in my ChildrenIDInput.

Thanks in Advance

2

Hello @Mor,
To filter images based on ChildrenID in Adalo: medicare gov

  1. Create a Custom List for your images.
  2. Add a Filter to this list where the ChildrenID of the image uploader matches the ChildrenIDInput of the logged-in user.
  3. Use Magic Text: In your filter criteria, use Logged-In User's ChildrenIDInput to match with the uploader’s ChildrenID.

This should display images uploaded by users with matching ChildrenID values.

Best Regards,
James Keen

3

Hey James. Thank you for your reply.
The images don’t have a childID. That’s because the images are from a user.

I wish to display all of the users pictures, from the user that has that childID related to him. And since the childID is a related field, it won’t filter with a text field like ChildIdInput.

  • Moris