Customise the property values set through 'Unique values in column'

[Cheap Onos]

Hi All,

Hopefully a simple answer- I have added a property control in my text area i.e. drop down list, and have set the property values through 'Unique values in column'.

But what I additionally need to do is limit what values are being included in the dropdown list - the list is driven by master data and I'm trying to avoid creating another "master" list.

Is there a way to control what values are inluded

[Gaia Paolini]

In the case of Unique values in column, you cannot filter by e.g. data type or other column properties (as all entries have the same data type and column properties). You can specify simple wild-card expressions like 'Bor C' for example, or 'NOT G' (the * is implicit here)

[Cheap Onos]

Thanks. I have ended up just creating a calculated column based on the master list and have hard coded to exclude the values I don't want included in the drop down list. Not ideal, but works.