I am loading a listbox for KPI selections with an expression as following:
=if($Field = 'KPI_FIELD1' or $Field = 'KPI_FIELD2' or $Field = 'KPI_FIELD3' or $Field = 'KPI_FIELD4', $Field, null())
When loading data in a listbox like this I am not able to select "Always One Selected Value" or set the default value via a trigger.
Is there a way to do this also?
If you have KPI_FIELD1, KPI_FIELD2,....so on, in different list boxes, please check the "Always One Selected Value".
Then create the Listbox with expression (one that you put in your question), you should be able to see "Always One Selected Value" then.
Or create a new field in the script and use that for the list box. Then you can select 'Always one selected value' property.
If($Field = 'KPI_FIELD1' or $Field = 'KPI_FIELD2' or $Field = 'KPI_FIELD3' or $Field = 'KPI_FIELD4', $Field, null()) as NewField
One way to achieve this is by creating a clear state.
Select one value from the list box, say KPI_FIELD1
Click the drop down arrow just beside 'Clear' button
Click on 'Set Clear State'
|Always One Selected Value||Checking this option assures that one value will always be selected, which is useful in documents where the data only makes sense when one value is already selected, such as one currency rate. This option is enabled after one value is already selected in the list box. This option is not available for calculated fields.|