Map checkbox to list field using record producer

[brostoff17]

I have a series of checkbox variables that I want to map to a list field on the table.   Checking the checkbox just returns "true" or "false", so I cant map the fields.   Has anyone done this using an onSubmit script to map the fields?

[brostoff17]

Hey Chris,

Thanks for the response.   I tried this solution in my record producer script, but no luck.   Here is my updated script:

       var wArray = [];
       if (direct == 'true') {
           wArray.push('241aee49db72f2409502f6e9af961944');
       }
if (together == 'true')
       wArray.push('562a6e49db72f2409502f6e9af9619d4');
       current.u_product_line = wArray.toString();

[ccajohnson · Accepted solution]

I am guessing that your variable names are direct and together. If that is the case, you need to indicate that they are part of the producer form by adding producer. in front of the variable name:

       var wArray = []; 
       if (producer.direct == 'true') { 
           wArray.push('241aee49db72f2409502f6e9af961944'); 
       }
       if (producer.together == 'true') {
               wArray.push('562a6e49db72f2409502f6e9af9619d4'); 
       }
       current.u_product_line = wArray.toString();

[brostoff17]

Yes, they are.   I still seem to be having issues with this.   Were you able to get this working in the example you provided?

[brostoff17]

Chris,

These are adding to the field, but showing as the sys_id and not the value:

[ccajohnson]

What table does the product line field point to?

Unclear if this is a custom table and if there is a field that is used for display.

You will need to validate that the sys_id you are using is the sys_id of the appropriate record.

You could manually populate the appropriate Product line values and see what those sys_id's are. You can find that out by selecting "Show XML"   when right-clicking on the title of the record. Look for the <u_product_line></u_product_line> portion of the record to see what is there.