How to update child table of one doctype from button click on another doctype using Server Script?

ERPNext
, ,
1

Hi there! I have a doctype called Planning and a child table in it. I added a button called Create task. When I click this button, task details in child table should create values in child table in another doctype called Phases.

How can i achieve this using Server script?

2

Hi @NCP !, Could you help me with this topic?

3

Hi @ibalajib,

I have no idea about the set value in the child table via the click button.

But you can set parent doctype value via click button using client/custom script.

Example:

frappe.ui.form.on('Your DocType', {
	    test_sf_connection: function(){
 		frappe.db.set_value('Another DocType', 'Name', {
 		    'Another DocType Field Name': 'Test',
 		});
	    }
});

Otherwise, it works on the server-side using the before/after save events.

Thank You!

4

And what to do if we have to update a value of child table in a parent doctype through another doctype who has a parent doctype link

5

Did you get any solution of it?