Endless menu while creating a filter

[giladraf]

Hey,

I’ve seen some answers in the forum about it, but I couldn’t figure out what I’m doing wrong here (or how to bypass the Adalo’s bug?) - anyways I’d appreciate any with the endless menu while creating a filter…

I’m building a screen that the user can add many filters.
In the DB I’ve added properties/columns in the user table, for example:

• filtered_categories - which has many to many relations with the 'category" table.
• filtered_color - which has many to many relations with the ‘colors’ table.

Once the user selects categories and colors, I save the selections for this user in the Users table (filtered_categories and filtered_color).

My plan was to filter the list of products for the user by adding this filter:
FIlter 1:
All product

Filter 2:
Current Product > Colors
Contains
Logged In User > Filtered_color

(And the same for the categories)

But I can’t really create filter 2, due to the issue you can see in the attached image.

Any idea what I’m missing here?

[Mosses]

You would need to make the data first available in the new screen. Here’s a quick video tut on how to do it. Hope it helps.

[James_App_Maker]

Hi Giladraf,

Welcome to the Community!

Adding onto what @Mosses said, @pford made a video tutorial on this same topic, which is very common when building your first app.

Adalo Tutorial: Most Common Mistakes - Current Data Missing From Screen, Data Loops and Flow Breaks

[Mosses]

@James_App_Maker I think you meant "Hi @giladraf "

[James_App_Maker]

Oh sorry I didn’t see that.

[giladraf]

Thank you guys for the warm welcome and for the willingness to help me here.
I really appreciate that!

I learned new useful things about connecting data but unfortunately, this is not exactly what I want to achieve.

I’m saving the selection to the ‘Users’ collection and then want to filter the list according to what I have there. here’s an example:

And I get the infinite menu when I want to select this:

Any idea what I’m doing wrong?

[giladraf]

Would really appreciate help with this one

[Yongki]

Hi @giladraf ,

As I see you want to save preference, category and color, so whenever user view list, you want the content is filtered accordingly.

Try binary total,

I make a sample here,

List filtering based on different user characteristics

Hi @Hussain , I have updated the cloneable app, this is very different. Basically what I did is binary total and filter, so you can fill the goal with whatever you want by duplicating status total. Previously I use toggle as only 2 parameters, now there are 3 parameters. Why we are doing workaround like this, it because filter only making it smaller set, which is known as AND, while what you want is OR, expand the set. Play around with binary total.

and just mention again here,

Trying to make it so you can have multiple restrictions for visibility

Hi @Jrs8 [Pasted_Image_5_22_21__5_25_AM] Click here again, make group again, then you can have another visibility. For OR function, use binary value, such as 100, 10, 1 for example in 3 factors, use 3 digits first digit which is 1 in 100 will determine first factor second digit which is 1 in 10 will determine second factor third digit which is 1 in 1 will determine third factor This is a combination of binary value, but with this, we can manipulate them by adding 100 or 10 or 1 and combi…

Don’t worry about infinite menu, focus on what you want to display, stay in your logic.