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

[Namrata Makasa1]

what type of field is the "Date Preferred"?

String or Date?

[prasanna7869]

It's String field on form.

[Namrata Makasa1]

Ideally it should display the values as it has been captured in the form since as you say the value is present in the List layout.

Not sure, may be some issue with the acls.

[prasanna7869 · Accepted solution]

Thanks for responding my Queries Dickson and Namrata!!!

I fixed this issue by following way to change my code:

var descr = '';

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

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

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

}

var finalResult = descr.toString().replace(',', '');

current.u_data_preferred = finalResult; //These two are working or my requirement.

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

Now, the values are displaying in "Date Preferred" column.

Thanks & Regards,

Prasanna Kumar

[Namrata Makasa1]

it's great that you found your solution.

please hit Like, Helpful or correct answer if you find anyone's reply worthy of so.