Exactly what do your scripts need to do with this checkbox formatted list?
Here's one useful tool that you can use to test and see what values are selected in the field that ignores the order of the values in the field:
FilterValues ( CheckboxField ; "Grapes" )
will return "Grapes" if the box for grape was checked and returns an empty string if it was not. You can even test for multiple values selected such as:
FilterValues ( CheckboxField ; List ( "Grapes" ; "Oranges" ) )
Which will return "Grapes", "Oranges" or both values separated by a return depending on whether one, the other or both values were selected by the user.
Thanks phil, I can see the check box values but they are sorted based on the user inputs
(I did try what you noted but results are still based on user checking sequence)
I am setting a global field in another file from this checkbox formatted list - ....
THEN I am doing script conditionals based off this set global in file B to process the results
if field x =
is not considered the same as
if field x =
It's impractical to do a mess of OR statements - I'll never get all the combinations.
I gave you an example in my last post that describes using FilterValues as a way to compare two lists of values. This function ignores the order of the values so the different orders to the values in this field will not affect the results returned. This should solve the problem for you.
thanks - I tested this by doing a 'set field'
fieldA user entry - sequence of checked boxes...
FilterValues ( fieldA; List ("apple";"pear"; "squash") )
results are the same as the user entry order
sorry but I am just not getting this...
Please spell out the exact results you need here. I think we are on different pages.
FilterValues will not change the order, but you can use it to test the contents and the order will be ignored during that testing.
Thus, FilterValues ( fieldA; List ("apple";"pear"; "squash") ) won't change the order, but it can tell if apple, pear or squash were selected regardless of their order in fieldA.
Ok... I think I am getting this ...
instead of my script step conditional say..
I think I am beginng to understand -
I have a condition script step that sez...
You are suggesting
FilterValues (_Inventory::G_Brands; List ("Dean";"Luna"; "ddrum";"Dime") )
UPDATE - my initial testing reveals that this isn't working
will guess around a bit.
ValueCount ( FilterValues (_Inventory::G_Brands; List ("Dean";"Luna"; "ddrum";"Dime") ) ) = 4
BRILLIANT - I'll savor this code logic like a child - Thanks again