How do I save multiple selections in a checkboxField? I tried displaying the cho

judym598

Certified Senior Developer

over 8 years ago

How do I save multiple selections in a checkboxField? I tried displaying the choiceValues using a rule (e.g., rule!psh_getAllFruits) that pulled data from a cdt (PSH_Fruits). The CDT is associated with a table (pshfruits) that has 2 columns: id (auto-generated integer) and fruitType (text). I wanted to store the selected id(s) in a field in another CDT (specifically newList_cdt.fruitType). I originally had 'fruit' as an integer. When that didn't work, I decided to change my approach to displaying the choiceValues using a constant (cons!PSH_FRUITS) and using a checkboxFieldByIndex; couldn't get that to work, so I went with the following and changed the data type of the column in the table (and CDT for this item) to 'text'. It works as long as I only select one item. (I actually have 8 choices so I'd really prefer to pull the choiceValues from a CDT - lookup table). I cannot get it to save or display multiple selections. At one point...

Discussion posts and replies are publicly visible

Parents

0 judym598
Certified Senior Developer
over 8 years ago

I would rather not have to create a new table with a nested CDT if I can avoid it. I replicated the code above with the 'split' and got the following error when I selected 2 items:

Could not display interface. Please check definition and inputs.
Interface Definition: Expression evaluation error at function a!checkboxField [line 191]: A checkbox component [label="What type of fruit? - Need to fix..."] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was B; P and choiceValues was B; A; P; G.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 judym598
Certified Senior Developer
over 8 years ago

I would rather not have to create a new table with a nested CDT if I can avoid it. I replicated the code above with the 'split' and got the following error when I selected 2 items:

Could not display interface. Please check definition and inputs.
Interface Definition: Expression evaluation error at function a!checkboxField [line 191]: A checkbox component [label="What type of fruit? - Need to fix..."] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was B; P and choiceValues was B; A; P; G.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data