Field selections

[#1]

Hi,

How can I check if a user selected anything other than a specific list of values?

For example, I have the field "Possible Selections" with the values ValueA, ValueB, ValueC, ValueD, ValueE, ValueF.

If the user selects any values different than ValueA, ValueC or ValueF, I want to know.

any ideas?

[vinieme12]

do you want to retrieve the values selected other than ValueA, ValueC or ValueF or just a boolean result?

[vinieme12 · Accepted solution]

Try this if you want to see values other than specified are selected

=concat(distinct

  if(wildmatch(FIELDNAME,'valueA','ValueB','valueC')=0,AU_TierGroup),', ')

To see count of values selected other than specified

=sum(

  if(wildmatch(FIELDNAME,'valueA','ValueB','valueC')=0,1))

[marcus_sommer]

I think you will need to use the audit-logging (could be enabled within the qmc) to track which user did what (inclusive selections) within an application. If you are dealing with confidential data and you need to control the access on the data on the user-level you should consider the use of Section Access.

- Marcus

[#5]

I need the count result. Thanks!!! it works great!