I have the set the condition to “Contains” and then the name of the Collection Record that I want to be present in the User’s Relationship property in order to make that component visible. In testing, this did not seem to work. I also tried using the Adalo ID from the API for the corresponding record but that also did not work.
Has anyone been able to figure out how to do this with Many-Many relationship properties?
Without having access to the app this would be difficult to troubleshoot. If you are in a position to grant me access to have a look then I will see if the issue can be resolved.
So to be able to filter by these many-many collections, you have to specify which specific record should be evaluated. So instead of the “Red Wine” static text you have there, you would need some red dynamic text to evaluate with. If you just say “Where this collection contains Red Wine”, Adalo doesn’t know which property it should be looking at. One way around this is to use the Count option instead. You can say, "This should only be visible if the user’s categories’ count where the name contains Red Wine is greater than 0.
So I have this sort of starting to work. My use case is that I am asking users to select a sub-category for each category that they selected from the previous screen, so if a user selects Red Wine, the dropdown menu to select a type of red wine should appear in this modal. Which it does here.
The problem I am now seeing, is that each user can add up to 5 categories to their preferences (the many-many relationship I described previously) however this modal is only showing the first component (Red Wine drop down) even though I set up identical drop downs with identical conditional visibility as per your method.
If you copied the dropdown over and over, you’ll need to reset the visibility back to Always visible for the copied dropdowns and then reset the visibility to Sometimes with those conditions. Don’t ask me why but copying things with visibility conditions sometimes breaks them and they have to be reset - don’t ask me how I know that one. Lol
