You need to sign in to do that
Don't have an account?
Marisol Thomer
Multi-Selection Picklists and Excel Connector
Hi all,
I saw in a December '06 post that in order to query a picklist selection, you have to use the operators "equals" or "not equal."
What about for multi-select picklists? I tried using the "includes" operator to query records based on whether they include one of the picklist selections and found it would only return those records that ONLY had that picklist selection (and no others).
Also, how do you format more than one selection (of a multi-select picklist) in Excel to have Excel Connector recognize it as such, more than one selection (as opposed to some new selection called "x, y, z")??
I feel like I must have missed something basic here. Any help is MUCH appreciated!
I saw in a December '06 post that in order to query a picklist selection, you have to use the operators "equals" or "not equal."
What about for multi-select picklists? I tried using the "includes" operator to query records based on whether they include one of the picklist selections and found it would only return those records that ONLY had that picklist selection (and no others).
Also, how do you format more than one selection (of a multi-select picklist) in Excel to have Excel Connector recognize it as such, more than one selection (as opposed to some new selection called "x, y, z")??
I feel like I must have missed something basic here. Any help is MUCH appreciated!