Advanced filtering on RG

[ed727]

I grappled with similar questions and eventually found the answers. To add to the above, a few things which may help…

@rachelwalsh365

I am having issues setting up the workflows on the checkboxes, more specifically, adding the values for the custom states in my workflows.

This video from @romanmg explains how to do it: https://www.youtube.com/watch?v=yahP3RyVggY

@rachelwalsh365

I am also unable to filter the RG applicable to my custom states, despite trying several different ways.

Additionally, looks like your colors filter involves filtering a list with a list which is a special type of search. This requires using an advanced filter which is client side. Note this will be slower to process on a large dataset. Below posts go into it…

Struggling with 'Intersect With'

Hi all, Been Bubbling for a while, and I think I had this a while ago, but I am suffering a massive brain fart this morning, and am wondering if anyone can help me out. I have a RG of ‘Shares’. In each ‘Share’ is a List of Things called ‘Interest’. Each user has a profile, and each profile also has a List of ‘Interests’. I am trying to get the RG to show Shares which contain at least one Interest that the Current User’s Profile contains. I’m going around in circles trying Intersects, Filter…

Advanced filter - multi constraints context

Hi Thomas, There are specific constraint operators that need to be used for single vs list values: Element vs Element Let’s say a User’s Name = Thomas and the input’s value = Thomas Jones Name = Input’s value > would not return the record because it’s not an exact match Name is in Input’s value > would return the record because the word “Thomas” is in the value “Thomas Jones” Element vs List Let’s say a User’s Name = Thomas and a custom state (list)'s value = Adam, Mary, Thomas Name = …