How to update a doctype fields values from another doctype

Frappe Framework Customization
1

Hello guys. I have a frappe application with 2 doctypes “property and payment”. I have a select field in property called “status” where the options are “Available” and “Rented”. And i have a link field to the property dcotype in my payment doctype.
I want the “status” field in the Property doctype to change to “Rented” when i create a new record in the Payment doctype linking a paticular property.

how to i go about acheiving this? mind you i am a beginner on frappe framework

2

try below:

doc = frappe.get_doc(“Property”, docname)
doc.status = “<desire_status>”
doc.save()

3

In what file do I implement this? And which doctype

4

Hi,
You can do this on payment doctype, .py file.
On validate event:

def validate(self):
doc = frappe.get_doc(“Property”, docname)
doc.status = “Rented”
doc.save()

5

You can also use like this
frappe.db.set_value(“Property”, {“name”: doc_name}, “status”, “Rented”)

6

Hi madu,
There are different purposes of using these methods
To set a single value at a time, you can use
frappe.db.set_value(“Property”, {“name”: doc_name}, “status”, “Rented”)
To set multiple values at a time. you can use

doc = frappe.get_doc(“doctype name”, docname)
doc.status = “xyz”
doc.customer_name = “abc”
doc.amount = 123
doc.save()

7

thanks for the reply. i tried it but it didnt work

payment
payment715×383 32.2 KB

8

What is the fieldname of your link field on the payment doctype use that fieldname instead of docname.
Self.your_fieldname

9

i did that but its still not working
payment1

10

this is a screenshot of my payment Doctype

payment2
payment2953×433 20 KB

11

Try using ‘doc.insert()’ instead of ‘doc.save()’.
and
‘frappe.db.commit()’
It might help.

12

Coming here with more question.

So, I have a custom DocType, and I’d like the status of to change to “Assigned” when a user is assigned to the document (from the sidebar), indicating someone is working on it. The status field shall remain read-only.

And I’d like the status to change once the document is submitted, to Submitted etc.

Any help is appreciated guys :slight_smile:

13

Shouldn’t your
def validate(self)

be indented and be within your class Payment(Document).

There it is outside.

Validate is using the Document class functions.

14

Has your issue been resolved?

15

let doc = frm.get_doc(doctype,docname); works for me.