How to Pass check box values from record producer to form/table?

[prasanna7869]

Hi Team,

I've created on table Registration form and I created one record producer. In that, I've 14 check box fields are there. If we check any one of them, I need to pass those label names to one string field called "Date Proffered".

I done this functionality by writing following script in record producer script field:

var descr = '';

if(producer.u_march14_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 14 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march15_yerba_buena_9_11.getDisplayValue() == 'true'){

  descr +="\n March 15 (9-11 am) @ Yerba Buena";

}

if(producer.u_march15_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 15 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march16_yerba_buena_9_11.getDisplayValue() == 'true'){

  descr +="\n March 16 (9-11 am) @ Yerba Buena";

}

if(producer.u_march16_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 16 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march17_yerba_buena_9_11.getDisplayValue() == 'true'){

  descr +="\n March 17 (9-11 am) @ Yerba Buena";

}

if(producer.u_march17_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 17 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march18_yerba_buena_9_11.getDisplayValue() == 'true'){

  descr +="\n March 18 (9-11 am) @ Yerba Buena";

}

if(producer.u_march18_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 18 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march21_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 21 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march22_yerba_buena_9_11.getDisplayValue() == 'true'){

  descr +="\n March 22 (9-11 am) @ Yerba Buena";

}

if(producer.u_march22_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 22 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march28_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 28 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march29_yerba_buena_9_11.getDisplayValue() == 'true'){

  descr +="\n March 29 (9-11 am) @ Yerba Buena";

}

if(producer.u_march29_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 29 (2-4 pm) @ Yerba Buena";

}

if(producer.u_march30_yerba_buena_9_11.getDisplayValue() == 'true'){

  descr +="\n March 30 (9-11 am) @ Yerba Buena";

}

if(producer.u_march30_yerba_buena_2_4.getDisplayValue() == 'true'){

  descr +="\n March 30 (2-4 pm) @ Yerba Buena";

}

current.u_data_preferred = descr.toString(); //Here I'm setting the final result to that field.

producer.redirect = "/Registration Form Final.do";

I list layout and for the values are displaying properly:

List layout:

But, when I export this table, the "Date Proffered" column showing empty column.

Please help me, how can I get the list layout values into exported excel sheet also.

Thanks & Regards,

Prasanna Kumar

[hadyndickson]

"current.u_data_preferred = descr.toString(); //Here I'm setting the final result to that field."......... You sure you got your column name spelt correctly? Just guessing but shouldn't it be current.u_date_preferred??

[prasanna7869]

Hi Dickson,

Thank you for your response. I've updated that field label. Actually, the data is passing properly. Here my concern is, while exporting the records by using excel, the "Date Preferred" column is empty. Please see he below screenshot for the same: After exporting the records.

Thanks & Regards,

Prasanna Kumar

[Namrata Makasa1]

hi,

just try this script. you will have to edit it as per your need....

if(current.variables.Request_Type_6 != 'Removal')

  {

  current.description += '\nResponsibility: ';

                      var keys = new Array();

                      var set = new GlideappVariablePoolQuestionSet();

                      set.setRequestID(current.sys_id);

                      set.load();

                      var vs = set.getFlatQuestions();

                      for (var i=0; i < vs.size(); i++)

                              {

                                if(vs.get(i).getLabel() != '' && vs.get(i).getDisplayValue() != '')

                                      {

                                          if(vs.get(i).getDisplayValue() == 'true')

                                                {

                                                    current.description += '\n'+vs.get(i).getLabel();//+': '+vs.get(i).getDisplayValue()+'';

                                                    }

                                          }

                                }

}

[prasanna7869]

Thank you Namrata for giving reply. As of now, I'm getting the values in form layout as well as List layout. Only concern is when after exporting the records, the "Date Preferred" column showing as empty even tat column having data in list layout. Please see the above mentioned screenshot for the same.