Multi-Select List Box Only Stores With Commas

[DataCobalt]

I have a multi-select listbox thanks to this article. The only issue is I need these items separated by ";" instead of ",".

 

 

Here is the code with the changes I have made:

<script type="text/javascript">
 var v_state = "[@field:Reason_for_Cancelltaion]" ;
var o_state = document.getElementById("EditRecordReason_for_Cancelltaion") ;
  o_state.multiple = true ;

function f_listbox() {
  if ( v_state.indexOf(";") > 0 ) {
    for (var i=0 ; i < o_state.options.length; i++ ) {
if(o_state[i].value == v_state) {
 o_state.remove(i);
 break ;
}
  }
   var o_st = v_state.split("; ") ;
    for (var j=0 ; j < o_st.length; j++) {
     for (var i=0 ; i < o_state.options.length; i++ ) {
 if(o_st[j]== o_state.options[i].value){
  o_state.options[i].selected = true ;
  break ;
    } 
   }
  }
 }
}
 window.onload = f_listbox ;
</script>

Even though I have replaced the character it still separates by commas!

 

Otherwise this functions as intended and I have even paired it with some jquery in order to remove the condition of holding down the control key for multiple selections.

 

 

Any and all help is much appreciated!

[Jan]

Hello DataCobalt,

 

As far as I know, multiselect element saves selected items that are separated by comma.

 

This code only allow to fill the Listbox with saved values that are separated by comma, and if you change the code, it will display values that are separated by ";" but does not save records by this way.

 

To save values that are separated by ";" you can follow the next steps:

1) Make your current Listbox field Hidden;

2) Add a Virtual field, make it Listbox and set settings as you need.

3) Add a Header&Footer element, click the "Source' button and enter the following code to the Footer

<SCRIPT LANGUAGE="JavaScript">   var fieldName = "cbParamVirtual1";
   var x=document.getElementsByName(fieldName);
   x[0].multiple=true;

  function fill_the_field()
    {
       var fieldName = "cbParamVirtual1";
       var secondFieldName="InsertRecordName";

       var myListBox = document.getElementsByName(fieldName)[0];
       var result = "";
       for (var i = 0; i < myListBox.options.length; i++)
       {
           if (myListBox.options[i].selected)
              result = result + myListBox.options[i].value + ";";
        }
       result = result.slice(0,result.length-1); 
       document.getElementById(secondFieldName).value = result;
   }
document.getElementById("caspioform").onsubmit=fill_the_field;
</SCRIPT>

Please insert the name of your field instead of "InsertRecordName" and the name of your virtual field instead of "cbParamVirtual1" in both cases, if the Virtual field is not Virtual1.

 

I hope, it helps.