Frappe.db.insert() with child table

1

I have a custom doctype. From this doctype I want to create a new document to Contact doctype using a custom button.

I successfully use this js in the frm.add_custom_button function for the button:

frappe.db.insert({
   "doctype": "Contact",
   "first_name": frm.doc.first_name,
   "last_name": frm.doc,last_name
});

But in Contact there is also a child table for phone numbers.
In my custom doctype I have the fields for phone number.
How do I insert this phone number to the child table?

I also tried to use below script but I don’t think it will work as it is new so there is no docname yet:

var p = frappe.model.add_child(docname, "Contact", "phone_numbers");
frappe.model.set_value(p.doctype, p.name, "phone", frm.doc.nomor_hp);

Thank you

2

Hope this helps to sort the issue.
contact = frappe.new_doc(“Contact”)
contact.field = your field value
contact.append(“phone_nos”, {
‘phone’: ‘xxxxxxxx’
})
contact.save()

3

Isn’t that for python?
I need the js one.

The alternative is to use frappe.call and python method (I already have the code for the python method for a code triggered insertion):

def add_contact(self):
    contact = frappe.new_doc('Contact')
    #the rest of the code to insert values to Contact
    contact.insert(ignore_permissions=True)

But another question arise: how to pass values to a python method asking for (self)?

4

That is for python. Instead of trying in js, py is better for creating a new_doc with child table details.
Pass the values from js as frm.doc and convert the json in py.

5

The py method I already have takes self as argument (because it takes data from a form), so in the py:

def add_contact(self):
    contact = frappe.new_doc('Contact')
    contact.first_name = self.firstname
    contact.last_name = self.lastname
    contact.append('phone_nos', {
        'phone': self.nomor_hp,
        'is_primary_mobile_no': 1,
    })
    contact.insert(ignore_permissions=True)

How do I convert the frm.doc to self (how the args in the frappe.call should be)?

1 Like
6

Try this by Converting the json arg
args - represent the frm.doc
a = json.loads(args)
print(a)