AnsweredAssumed Answered

Customize Drop-Down list depending on other fields value

Question asked by poliver88 on Jun 7, 2018
Latest reply on Jun 7, 2018 by philmodjunk

I have one number field - 'Total Weight' and another drop-down list field 'Product'

 

What I would like is to only show certain items in the drop-down depending on the Weight entered.


What I've tried is created another calculation field that would return me a list depending on the Weight value

and in the layout mode have set my dropdown box to display data from that field.


This works only once when I enter the 'Weight' for the first time. After that if I change the weight the drop-down doesn't get updated at all.


What's the best way to approach this?

Outcomes