How can I set Control Field using another Control?

Q&A
, , ,
1

Hello,

I currently have two parameters set up with controls. Control #1 is a list of options that correspond to column names. Control #2 should be a list of unique values in the column indicated by Control #1.

I attempted to get this working by using a Calculated Field, which maps the Strings of Control #1 to the appropriate columns:

ifelse(${DimensionParameter} = ‘First Category’, {first_cat}, ${DimensionParameter} = ‘Second Category’, {second_cat}, ${DimensionParameter} = “Third Category”, ${third_cat}, “”)

However, I am unable to use this calculated field as the dimension for Control #2 (it does not appear in the Field dropdown).

Does anyone know how to accomplish what I’m trying? Thanks!

1 Like
2

Hello @SophK, I think the best way to manage this will be to utilize conditional rules in the free-form layout. You can use the selection of the category parameter to determine which control you display to the user. This would be the best way to dynamically change the dropdown options.

I made a demo in Arena. You can view it here: Dynamic Control Field

Let me know if you have any questions!

1 Like
3

This makes a lot of sense, thank you @DylanMorozowski. I can definitely implement this in my dashboard, but I’m hoping there could a solution that doesn’t require the control duplication. In reality I’m actually setting two different controls with the “outer” control, and with at least five different categories/columns that’s at least 10 controls. Which is totally doable, but not as flexible as would be ideal.