Adding instructor to a child table

Frappe Framework Customization
1

Hi Everyone,

I have created a childtable named xyz.In xyz childtable i have a field linked to instructor.While adding instructor to childtable duplicate values are entering.
I wrote a script but it is not working properly.

frappe.ui.form.on("Team", "instructor", function(frm,cdt,cdn) {
	
	for(key in frm.doc.team){
	// console.log(frm.doc.team[key].instructor);
	frappe.call({
				method: "ims.ims.doctype.fe_settings.fe_settings.get_employee_details",
				args: {
					"instructor_id": frm.doc.team[key].instructor,
				},
				callback: function(r) {
					if(r.message) {
							console.log(r.message[0]["instructor_name"]);
							// locals[cdt][cdn]['instructor'] =r.message[0]["name"]
							locals[cdt][cdn]['instructor_name'] =r.message[0]["instructor_name"];
							locals[cdt][cdn]['phone_number'] =r.message[0]["cell_number"];
							locals[cdt][cdn]['designation'] =r.message[0]["designation"];
							locals[cdt][cdn]['email'] =r.message[0]["company_email"];
							locals[cdt][cdn]['image'] =r.message[0]["image"];
							// refresh_field("team");
							refresh_field("instructor_name");
							refresh_field("phone_number");
							refresh_field("designation");
							refresh_field("email");
							refresh_field("image");
					}
					// else{	
					// frappe.throw("please tick show in website in Instructor")
					// 	console.log("hello");
					// 	cur_frm.get_field("team").grid.grid_rows[key].remove();
          			// refresh_field("instructor")
					// }
				}
		});	

	}
		
});
2

instead of using locals[cdt][cdn][fieldname] use the frappe,model.set_value(cdt, cdn, fieldname, value) method then refresh the child table using frm.refresh_field('childtable_name')

3

@makarand_b Thanks for the reply.But I have tried the script. Its again entering the duplicate values.

frappe.ui.form.on("Team", "instructor", function(frm,cdt,cdn) {
	
	for(key in frm.doc.team){
	// console.log(frm.doc.team[key].instructor);
	frappe.call({
				method: "ims.ims.doctype.fe_settings.fe_settings.get_employee_details",
				args: {
					"instructor_id": frm.doc.team[key].instructor,
				},
				callback: function(r) {
					if(r.message) {
							console.log(r.message[0]["instructor_name"]);
						
							frappe.model.set_value(cdt,cdn,'instructor_name',r.message[0]["instructor_name"]);
						frappe.model.set_value(cdt,cdn,'phone_number',r.message[0]["cell_number"]);
						frappe.model.set_value(cdt,cdn,'designation',r.message[0]["designation"]);
						frappe.model.set_value(cdt,cdn,'email',r.message[0]["company_email"]);
						frappe.model.set_value(cdt,cdn,'image',r.message[0]["image"]);
							
							frm.refresh_field("instructor_name");
							frm.refresh_field("phone_number");
							frm.refresh_field("designation");
							frm.refresh_field("email");
							frm.refresh_field("image");
					}
					// else{	
					// frappe.throw("please tick show in website in Instructor")
					// 	console.log("hello");
					// 	cur_frm.get_field("team").grid.grid_rows[key].remove();
          			// refresh_field("instructor")
					// }
				}
		});	

	}
		
});
5

@makarand_b I have another issue with this can you help me please