Record Producer NOT creating all the populated List Collector values into target table's List field.

Aki18
Tera Contributor

I created a Record Producer which has the List Collector field with multiple values are populated.

However, the issue is that NOT all the populated values are filled into the List field of the target table. As the image below, only the first value is populated in the target List field. Could someone please help me with troubleshooting it?

 

Aki18_0-1667894661710.png

 

Best Regards,

Aki

11 REPLIES 11

How are you populating the list collector ? Are you selecting values in the field manualy ?

 

Regards,

Kamlesh

@Aki18 ,

 

Also could you please confirm if behaviour is same from legacy view ?

 

Also try this :

 

1. Open your record producer from legacy view and just before submitting the form open the javascript executer ( CTRL+SHIF+J)

 

2. execute the below script and check output. If you get sys_ids in the alert then there is no reason it should not work (Assuming you are using Map to field option for mapping in record producer). If it shows name in alert then that's the issue:

 

alert(g_form.getValue("you_list_collector_field"));

 

kamleshkjmar_0-1667899506532.png

 

 

kamleshkjmar_1-1667899600695.png

 

Regards,

Kamlesh

 

Hi @kamlesh kjmar ,

Thank you for your reply.

I tried it from the legacy view, but had the same issue...

Also, I got appropriate sys_ids of the populated values after executing the script as per your instruction... Any ideas why the error still persists...?

Hi @Aki18 ,

 

Include the list collector field in the list view of the table where record is getting created. If in list view you can see all the values then most probably you have a client script working onload responsible.

 

But if in list view also you see just one value selected then either there is any BR or any script on the record producer which is removing the value before creation of the record.

 

Regards,

Kamlesh

Aki18
Tera Contributor

Hi All,

Thank you those who replied to my question. I found out the cause of the issue.

The issue was due to max length of the target field. After changing it from 32 to 1024, multiple values became able to get populated into the List field...!