I'm trying to set the select dropdown options based on a field called 'set' in the array. If the value of 'set' is ICE, ICE 2, or PIE then I want the dropdown to show High, Medium, or Low. But if the value of 'set' is Hotwire I want it to show Yes or No for the 'variable'. This is what I've got so far - The presentation is ugly on purpose because I'm trying to identify where it's going wrong and I'm just trying to get it to technically work before I move to putting the style on it.
Two screenshots:
- My current page layout
- The formula I have to try and show only the correct values of High, Medium etc
.jpeg/public)