Data not saved in web form child table

KS_Deal · July 10, 2020, 4:53am

Any idea ?

khushal_t · July 10, 2020, 6:45am

Is your site running its saying 500 internal server you may check logs on the server like your DB services other services are working or not.Please check Server logs for more details

KS_Deal · July 10, 2020, 8:13am

No site is working correctly and data is saving on database except child table.

stevenyaga · August 25, 2020, 8:55pm

@KS_Deal, A workaround is to add a client script and add a validate handler. Then set the property of frappe.web_form.doc[CHILD_TABLE_FIELDNAME] = frappe.web_form.get_values().CHILD_TABLE_FIELDNAME; See the example below where my child table field name is “parameters”:

frappe.web_form.validate = () => {
let data = frappe.web_form.get_values();
frappe.web_form.doc[‘parameters’] = data.parameters;//set this here otherwise the child table values will not save
return true; //Make sure you return true else data will not save
};

marynvdl · November 17, 2020, 9:53am

Thank you, this worked for me.

Just note that the client script should be filled out on the actual web form, not as a custom script.

See the below example on the Job Application Web Form for the child table language.

frappe.web_form.validate = () => {
   let data = frappe.web_form.get_values();
   frappe.web_form.doc['language'] = data.language;
   return true;
};

Akram_Mutaher · December 4, 2020, 11:50am

@alkuhlani

ERP_Implementer1 · December 21, 2020, 9:43am

this is the solutions

Saad_Genirex · September 24, 2021, 1:29pm

can plzz snd the js file or code

ERP_Implementer1 · September 25, 2021, 10:51am

@Saad_Genirex

Write this script on web Form in Client Script Section

frappe.web_form.validate = () => {
let data = frappe.web_form.get_values();
frappe.web_form.doc[‘Your_Child_Table’] = data.Your_Child_Table;

return true;
};