How do I allow multiple selections of choices on a form in Kingston?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2018 08:01 AM
I have a variable that is set up as multiple choice, but I want users to be able to select more than one option when they are filling out the form. Is this possible in Kingston?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2022 01:02 AM
Hi,
If you go to the "Reference qual" field where you are specifying the question id and add ^inactive=false onto the end of the statement so it looks something like so...
question=f735fda71bd48d907762db5be54bcb25^inactive=false
Next, go to the question_choice table, find your question answers, and set the inactive field to true for any that you no longer want to use. They will stop being listed in the form, but will still show in the historic tickets.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2022 07:23 AM
This is perfect! Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2022 08:07 AM
Do you know how to reorder the selections in this type of variable as well? They default to alpha-numeric order even when reordered. I looked in the variable attribute documentation and can't find anything to get variables in a different oder.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2022 12:35 AM
There's an order column in the question_choice table.
I haven't tried it, but it should be along the lines of setting the order values for your question in that table, then adding the following to the ref qual statement.
^ORDERBYorder

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2022 01:01 PM
Following xiax's original instructions, I now use this as a standard when setting up list collectors like this on the variable, to keep it similar to how a Select Box would behave and easily be able to inactivate choice options later on if needed.
Reference Qual: question=[question sys_id]^inactive=false
Variable Attributes: ref_ac_order_by=order