I have 6 dropdowns but based on space restrictions I had to include a script that showed the dropdown options on two lines instead of just one (kinda like a wrap around). I have the export values set for each item and a text box (TOTAL) that is set to calculate the export value for each dropdown based on the selections. However, the calculation is not happening. I'm sure it has something to do with the "wrap around" script, but I have no idea what I need to do next. Any suggestions would be appreciated. Below is how I have things set up right now.
Dropdown1 through Dropdown 6:
ITEM: FullyMet MostlyMet PartiallyMet SomewhatMet NotMet
EXPORT: 10 7.5 5.0 2.5 0
Wrap around script on ACTION tab for each dropdown:
this.getField("Dropdown1").setItems(["Fully\nMet", "Mostly\nMet", "Partially\nMet", "Somewhat\nMet", "Not\nMet"]);
TOTAL box: CALCULATE tab, Value is the sum(+) of the following fields: Q1, Q2, Q3, Q4, Q5, Q6
Copy link to clipboard
You did not set the export values. To do so you need to use this command:
this.getField("Dropdown1").setItems([["Fully\nMet", 10], ["Mostly\nMet", 7.5], ["Partially\nMet", 5], ["Somewhat\nMet", 2.5], ["Not\nMet", 0]]);
Note that adding line-breaks into the items of a drop-down field is not an official feature and tends to be buggy. I would recommend not doing it, if at all possible.