Search based on Values in Checkbox
I use a checkbox to store the values chosen by the user. It is not complicated and it are just 4 values. (Computer - Concrete - E-Book - Internet). The user can choose one value, more values or all values, whatever they like, in the pick order they like.
The chosen values are stored and sorted in a global field for later use.
Later on there is a search (using “Find” - “SetField” - “Perform Find”) based on values in the global field.
In the SetField is use “from - until”:
SetField [LearningMaterial ; GetValue ( gField::MateriaI ; 1 ) & ".." & GetValue ( gField::Material ; ValueCount (gField::MateriaI ) )]
(The field “gField::Material” is sorted for a proper find)
But now comes the problem;
If a user only checked “Computer” and “Internet” I can’t use the “from - until” option, because FM takes everything between “Computer” and “Internet” and I only want a search for the checked values.
I think I am making a “thinking mistake”, but I can’t find a proper solution to perform a search based on the checked options. I solved it now by counting the number of values in the checkbox and use “if” to check the quantity of values. But that seems not an proper or elegant solution.
Anybody a good idea?
Thanks in advance.