AnsweredAssumed Answered

3 Checkboxes with scripts to find 2 or more matching values from 3 different fields.

Question asked by Kaorin on Jul 6, 2015
Latest reply on Jul 25, 2015 by philmodjunk

Title

3 Checkboxes with scripts to find 2 or more matching values from 3 different fields.

Post

Apologise if my title didn't make any sense.

The aim is to create script(s) which will find all the values ticked from 3 different check boxes.

Let’s say I want to find the records matching to the following by clicking the values in check boxes:

Vegetable” and “Fruits” from Produce category and

 “UK” and “France” of origins and

Fresh” and “Frozen from State of the products.

to show the record(s)match to above criteria.

However, I may only want to tick just 1 value from 1 checkbox, to just find "apples" only from Produce category.

 

These are the fields I have so far:

GROCERIES::Produce (apple, peas, pear, basil, potato, etc…)

GROCERIES:: Type (Fruits, Vegetable or Herbs)

GROCERIES::Origin (UK, France, Spain, etc..)

GROCERIES::State (Fresh, Frozen or Dried)

 

I also created 3 global fields, which are the checkboxes listing all the values from the appropriate fields:

 

GROCERIES::g_finf_produce,              all values from  the field GROCERIES::Produce

GROCERIES::g_find_fuits,                    all values from GROCERIES:: Type

GROCERIES::g_find_origin,                  all values from GROCERIES::Origin

 

How do I create a script that finds everything that I tick from each of the 3 check boxes and which field should I attach the script to?

Should I make 3 different scripts and apply to each global fields or should I make just 1 script and apply to all 3 global fields?

 

Thanks.

Screen_Shot_2015-07-03_at_17.56.58.png

Outcomes