I have a SharePoint Multi-select Choice field which has about 30 options. The options fall into 3 categories A, B, C.
For ease of use I would like to have 3 different (colour coded) choice lists displayed on the form and then combine the results to write back to the single SharePoint field.
I have created the 3 "not connected" choice fields for the user to be able to find the appropriate choices easily, but I don't know how to combine the results, and write them back to the single SharePoint field.
(I think... but not certain, that this will be complicated by a couple of the options having commas in them.)
Eg. Option 1 = "Fred", Option 2 = "George", Option3="Helen, Ann", Option 5="1357",
Option 6 = "78, 965A"
Can anyone point me in the correct direction.
Thank you