End-user Filters in Interface Display FILTERED Data as Options

[mbm61640]

At the top of my interface, I have a variety of Filters for end users. 

At the interface level, I've filtered out certain records using the same fields that are at the top of the interface as end-user filters. For example Published Location <> UNPUBLISHED. 

However, when end-users click on the filter "Published Locations", there still remains the UNPUBLISHED option which, when chosen, returns no records in the interface. 

I would like the records to be filtered and the filters to be... filtered. 

[jsep]

Is the "Published Locations" field a single or multi-select field? If so, then you cannot filter out the options. However, if you use a linked record field, then the options will be filtered out based on the listed records..

I hope this helps! If you need assistance implementing this solution, feel free to schedule a free call with me.

- Juan, Code and No-Code Solutions Expert