[SOLVED] How do you assign a value to table multi-select in the client script?

ERPNext Customize ERPNext
,
1

I’ve been fiddling with Table Multiselect (TMS) and cant get it to save even when the values show up in the browser. Maybe someone here will help.

My goal is to assign values (crops) to a TMS based on another field (Spray program). But I get errors when saving:

Screenshot 2022-09-06 at 08.31.35
Screenshot 2022-09-06 at 08.31.351920×1200 167 KB

I’ve included my code, my form and console in this screenshot. Here’s my snipped of the assignment:

 spray_program(frm){
    if(frm.doc.spray_program){

        frappe.call({
            method: "frappe.client.get",
            args: {
                doctype: "Spray Program",
                name: frm.doc.spray_program,
                async: true
            },
            callback: (rs) => {
                let res = rs.message.sp_crops;
                let crops = ""
                let crop_list = []

                for (var index in res) {            
                    crops = crops + res[index].crop + ", "; //using a text field
                    //using a table multi-select field
                    crop_list.push({ name: res[index].name, crop: res[index].crop, doctype: res[index].doctype });
                }
                console.log(crop_list);
                
                frm.doc.crops = crops; //temp use text // iterate
                frm.refresh_field('crops');
                frm.doc.user_crops = crop_list; //temp use text // iterate
                frm.refresh_field('user_crops');

                /**
                 Failed
                 frm.doc.user_crops = [{ name: , crop: "F116-124", doctype: "Crops" }] //added dt
                 Needs actual doctype

                 0: {name: 'CROP-001', owner: 'adam@jjjj.com', creation: '2022-09-05 19:07:59.376017', modified: '2022-09-05 19:12:29.548265', modified_by: 'adam@jjjjj.com', …}

                 0: 
                    creation
                    : 
                    "2022-09-05 19:07:59.376017"
                    crop: "F116-124"
                    docstatus
                    : 
                    0
                    doctype
                    : 
                    "Crops"
                    idx
                    : 
                    1
                    modified
                    : 
                    "2022-09-05 19:12:29.548265"
                    modified_by
                    : 
                    "adam@jjjjj.com"
                    name
                    : 
                    "CROP-001"
                    owner
                    : 
                    "adam@jjjjj.com"
                    parent
                    : 
                    "001-1234-aug"
                    parentfield
                    : 
                    "sp_crops"
                    parenttype
                    : 
                    "Spray Program"
                 */
                
            }
        });
    }
},
2

Assignment with frm.set_value solved it :triumph:

 spray_program(frm){
    if(frm.doc.spray_program){

        frappe.call({
            method: "frappe.client.get",
            args: {
                doctype: "Spray Program",
                name: frm.doc.spray_program,
                async: true
            },
            callback: (rs) => {
                let res = rs.message.sp_crops;
                let crops = []

                for (var index in res) {         
                    crops.push(res[index]);
                }

                frm.set_value("user_crops", crops);
                refresh_field('user_crops');
            }
        });
    }
},
3

Is there a python method to do it??

4

found any?