Dropdown List Filtering

I have 3 tables: Users, Location, Group.

Each Location is assigned has one Group assigned to it and multiple groups can be assigned to multiple users. I have a dropdown that I am trying to populate with the location values based on the Groups of the current user but I cannot seem to get it to work.

I know this can be done but I am not sure how. Any help would be greatly appreciated.

Here is a screenshot of my configuration:

Hi there, @jason.h… if I understand your post correctly, I believe you would need to use an advanced filter that looks something like this…

If you haven’t used an advanced filter before, be aware of the potential performance impact that is a result of the filter taking place on the client side. So, in this case, all of the things in the Site data type will be returned to the browser and then the advanced filter will be applied. Again, just something to keep in mind.

Hope this helps.

Best…
Mike

1 Like

I have never used advanced filtering but it works great. Thanks!

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