List based on a selection from another list

Hey everyone
First post for me in the forum

Adalo is good I have re developed an exisiting app that took 3 months in 2 weeks
Deploying to IOS/Google stores is easier

BUT

How do you have a list based on a selection from a previous list?
The previous screen that is passed over cannot be enumerated

I already have work around for other screens storng a value in the users context

this is a fundermental requirement

P

like a subcategory list ?

Yes, So I have a list of Hospitals and when I click on a list item (Hospital) it takes me to another screen with a list of wards for the hospital.

Whilst I can get the hospital name on the next screen the List of wards wont allow me to select based on the Hospital

I cannot do it based on a filter as too much data would be needed

its possible if i can see an examples
just the database but its possible

The databases are all external collections
I am using the Adalo Users database and have used fields within that to store temporary id’s to resolve similar issues on other screens

u might have to re create the database for relationship issues

Hi @FredFrag,

What database integration you use for external collections?

For example, xano tables can be filtered like this : https://youtu.be/vXz2HfXKJGo?feature=shared

Airtable tables can be filtered like this : Filtering Airtable Lists | Adalo Resources

You can find the filtering details with that database integration documentation.

If you know how to filter but don’t get the previous screen data to map in the filter, then that data would be missing in the current screen. You can check this on the screen settings to see what screens cause the data loss in the current screen.

You can check these videos made by Patrick for better understanding this issue! : https://youtu.be/hnQQ5dfKZLY?feature=shared, https://youtu.be/Qo9SnoyWAyU?feature=shared

Thank you and have a great day!

Morning
I’m integrating with MSSQl via an API.
I did get this working by having a temporary column within the Default Users table to store the id required

regards
Paul

Hi, I tried filtering data from Xano database (not as external collection). However, it shows all the data first for a fraction of seconds and then applying the query parameters to filter the list (This can be seen in the youtube video also, which you have mentioned here: https://www.youtube.com/watch?v=vXz2HfXKJGo (at 08:22 mins). Could you suggest why this might be happening and how to avoid?

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.