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?