multi-dimensional visibility gird

Question

Is there a way to set up a visibility grid based on a combination two or three other dropdown values?

Example:

dropdown 1 is a dropdown with of values A, B,C

dropdown 2 is a dropdown with of values 1, 2, 3, <blank>

Dropdown 3 should display a subset of options dependent on dropdown 1 AND dropdown 2

dropdown1=A & dropdown2=1 -> dropdown 3 values i, ii

dropdown1=A & dropdown2=2 -> dropdown 3 values i, ii, iii

dropdown1=B & dropdown2=1 -> dropdown 3 values i

dropdown1=B & dropdown2= <blank> -> dropdown 3 values i, iii, iv

and so on...

thanks,
FrancescaS

Francesca Shiekh · Accepted Answer

I took your code and was able to get it to work for myself by making the following changes: In custom/include/Expressions/Expression/Enum/RestrictSalesGoalsDropdownExpression.php Changed static function getParameterTypes ( ) { return array ( AbstractExpression : : $ENUM_TYPE , AbstractExpression : : $ENUM_TYPE , AbstractExpression : : $ENUM_TYPE ) ; } To static function getParameterTypes ( ) { return array ( AbstractExpression : : $STRING_TYPE , AbstractExpression : : $STRING_TYPE , AbstractExpression : : $STRING_TYPE ) ; } Changed the parameter types to strings instead of enums because from your dependency it looks like you are passing in the values of three different fields, which would be strings, and not arrays. In custom/Extension/modules/sgoal_SalesGoals/Ext/Dependencies/ deps.ext.php Changed 'keys' = > 'createList(restrictSalesGoalsDropdown($goal_type, $sales_entity_type, $sales_group))' , 'labels' = > 'createList(restrictSalesGoalsDropdown($goal_type, $sales_entity_type, $sales_group))' , To 'keys' = > 'restrictSalesGoalsDropdown($goal_type, $sales_entity_type, $sales_group)' , 'labels' = > 'restrictSalesGoalsDropdown($goal_type, $sales_entity_type, $sales_group)' , Removed the call to createList because your custom sugar logic functions are already returning an enum. I'm not sure if naming this file deps.ext.php, which is the same name as the file Sugar creates, will cause any problems. When I was testing I used a different name, such as cstm_restrict_sales_goals.php to prevent any problems with name conflicts. Hopefully these changes solve the problem for you.