Server Side Script UPDATE value in other doctype

Frappe Framework Custom Script
1

I have created a new doctype called Test with three fields test_code, test_name, status

Now when Create a new project in Project doctype i need to insert it to Test doctype
So I have created a new server script after save as below

frappe.get_doc(dict(
                doctype = 'Test',
                test_code = doc.name,
                status = doc.status
            )).insert()

And it worked Sucssfuly

after that create a new server script Before Delete

frappe.get_doc(dict(
                    doctype = 'Test',
                    test_code = doc.name,
                    status = doc.status
                )).delete()

also that worked

Now I need a server script to update or change the value For Example: when chang status in Project doctype I want to update status in Test doctype where test_code=doc.name

How I can do that?

1 Like
2

Have you tried hooks?
https://frappe.io/docs/user/en/guides/basics/hooks

An on_update hook for Project doctype could work.

3

Try it.

test
test1026×178 27.9 KB

4

thanks @Jitendra_Rathod
I can do that in Server script doctype or in .py file?

5

yes, you can do in .py file.

6

I won’t do change in files, is there any way to do it in Server Script as I did with insert and delete?

7

add your custome script and pass the path in hooks.py

9

How i can do that?

11

Try this code

value = frappe.db.get_value(doctype, docname, fieldname)
frappe.client.set_value(doctype, docname, fieldname, value)
or this
doc = frappe.get_doc(doctype-name, document-name)
// get property
doc.title
// set property to the document
doc.first_name = ‘My Name’
// save a document to the database
doc.save()

12

This is good for an update an existing Document, but
how to insert a complete new document
like Journal Entry

13

Please check this link…