Mutli dropdown and Repeating groups

Hi

Pretty new, learning as I go building a CRM lite for a small company. Currently I’m working on a past project photo page. I would like to use the multi-select drop-down to filter my repeating group of photos/descriptions. I can not seem to filter by more than 1 tag, and not sure where I am going wrong.

I have a spot to upload photos and assign tags as a list field. When searched in the RP, if I enter 2 tags and pic A has the first tag and pic B has the second, I’d like both pictures to show.

How do I go about doing this? I’ve tried creating tag as Data Type, list, is this something I filter off the repeating group… is it a workflow…

I’ve tried a bunch of combinations unsuccessfully, but I’m not sure if it is because the method or my execution was wrong.

Any suggested paths would be most appreciated!

Hi,
you can use :filtered with intersect or contain list with advance constrain. hope it works,

2 Likes

Hi, thank you for help. While I no longer get errors with the advance/contains list, it does not seem to fully work. Let’s say have 3 tags of red, white and black and the first image has tags of red and white. The image does not show when red and white are selected in the multi drop down. If I save an image with only red, it does show when only red is selected. I’d like the photo with red and white to show even if just red is selected. Do I need to move to custom states for this?

if you need to list out any of the selected in the multidropdown then, change the advanced filters into
“This Users tags intersect with Multidropdown A’s value :count >0”

1 Like

You don’t necessarily need to use the multi drop down for this as you could have other ways of selecting items to put them into a list…however, I don’t think that is really the issue.

You don’t need the advanced filter as that slows things down as well.

When I set up filters and search results for items that I want to select multiple of and have all show, such as products of shirts, shorts and shoes getting selected, added to a list and then the search results show all products that are either shirts, shorts or shoes I use the filter and the “is in”

Screen Shot 2020-01-30 at 1.48.49 PM

The above screen shot is only the filter part of my search, which is just search for products

The ZZZZZZZcategoryoptionsondatatype could be your “photo tag”

Screen Shot 2020-01-30 at 1.49.09 PM

My ZZZZZZZcategoryoptionsondatatype is an option set reference as a data field in the datatype of products, however for your images data type you would have a data field of “tag” which could be a text itself, or a reference to a data type that is “image_tags” where you have only certain tags a user can select.

I do this as I only want certain types of product images

Screen Shot 2020-01-30 at 1.53.11 PM

Screen Shot 2020-01-30 at 1.53.42 PM

If you have the database set up correctly for the images and their tags, then follow the filter above using the “is in” function to reference your list of tags from the multidropdown select or any other way of storing a list of selected tags.

2 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.