I think this line should inside for loop.
Thanks For your efforts. But I tried it as well.
This line inside For loop will give same result. As d.doctype and d.name stores current row values, so it changes value of that particular row, at which we change material weight or moisture value. It does not change all table value.
What should i do for this ?
many thanks brother
@Hardik_Gadesha, @Hafees_Kazhunkil, @cpurbaugh
please give me your assist on this issue
if i want to add a 5th column on the table and make the field to be calculated by column1 * column2 what should i do?
thanks in advance for your support
This may help:
//The following three scripts calculates the rate/amount based on quantity.
frappe.ui.form.on("Material Request Item", {
rate: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, 'amount', (d.qty * d.rate));
var total = 0;
frm.doc.items.forEach(function(d) {
total += d.amount;
});
frm.set_value('total_amount', total);
},
qty: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, 'amount', (d.qty * d.rate));
var total = 0;
frm.doc.items.forEach(function(d) {
total += d.amount;
});
frm.set_value('total_amount', total);
},
amount: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, 'rate', (d.amount / d.qty));
var total = 0;
frm.doc.items.forEach(function(d) {
total += d.amount;
});
frm.set_value('total_amount', total);
}
});
1 Like
@cpurbaugh
thanks for your replay
here is my case my child table name is Activityitem and parent doc type is Activity Type
my 3 columns are itemquantity,itemcost and itemtotalost
and what i need is itemquantity * itemcost =itemtotalcost
and here is my code
frappe.ui.form.on(“Activityitem”, {
itemcost: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.Activityitem, ‘itemtotalcost’, (d.itemquantity * d.itemcost));
var total = 0;
frm.doc.items.forEach(function(d) {
total += d.itemtotalcost;
});
frm.set_value(‘total_amount’, total);
},
itemquantity : function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.Activityitem, ‘itemtotalcost’, (d.itemquantity * d.itemcost));
var total = 0;
frm.doc.items.forEach(function(d) {
total += d.itemtotalcost;
});
frm.set_value(‘total_amount’, total);
},
itemtotalcost: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.Activityitem, ‘itemcost’, (d.amount / d.itemquantity));
var total = 0;
frm.doc.items.forEach(function(d) {
total += d.itemtotalcost;
});
frm.set_value(‘total_amount’, total);
}
});
but not working.
please give me your advice.
thanks in advance
frappe.ui.form.on("Activityitem", {
itemquantity: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, 'itemtotalcost', (d.itemquantity * d.itemcost));
},
itemcost: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, 'itemtotalcost', (d.itemquantity * d.itemcost));
}
});
Please Check Child Doctype Name, Field Name twice and confirm
@Hardik_Gadesha, @cpurbaugh
thanks for your support
but its not making the calculation, what shall i amend
frappe.ui.form.on(“Activityitem”, {
itemquantity: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, ‘itemtotalcost’, (d.itemquantity * d.itemcost));
},
itemcost: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, ‘itemtotalcost’, (d.itemquantity * d.itemcost));
}
});
Post Screen shot of your doctype schema
frappe.ui.form.on("Activityitem", {
itemquantity: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, 'itemtotalcost', (d.itemquantity * d.itemcost));
}
});
frappe.ui.form.on("Activityitem", {
itemcost: function(frm, cdt, cdn) {
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, 'itemtotalcost', (d.itemquantity * d.itemcost));
}
});
can you share me your code? I have an identical case which requires custom script like yours… Thanks before…
Study this link. It will help
Nice thread.
I’m trying to achieve the same via web form but I’m stuck at the event listener part itself.
This is my code which is working in the form js file:
frappe.ui.form.on("Indicator", "value", function(frm, child_doctype, child_name) { console.log(frm, child_doctype, child_name); });
and this is code which isn’t working in my webform js file:
frappe.web_form.on("Indicator", "value", function(frm, child_doctype, child_name) { console.log(frm, child_doctype, child_name); });
Error:
“web_form.js:39 Uncaught TypeError: Cannot read property ‘df’ of undefined”
Any help would be highly appreciated. Thanks!
Thanks for pointing me to the documentation.
In fact, following the same, I’ve got to implement the events for the form fields but the issue is only wrt to accessing the fields of the child table placed inside the webform.
For Example:
For a webform field, this is working:
frappe.web_form.set_df_property([“name”], [“read_only”], [1]);
now, I want to do the same for a field inside a child table which is part of this webform, what should I do for that?
I tried the below options, but isn’t working:
1.)
frappe.web_form.set_df_property([“indicators.grid.grid_rows[0].columns.value”], [“read_only”], [1]);
2.)
frappe.web_form.get_field(‘indicators’).grid.grid_rows[0].columns.set_df_property([“value”], [“read_only”], [1]);
Any inputs on how I should approach this problem?
Thanks for your time!
Could you help me with the script. I am trying to change field in child table based on delivery date. I want that if delivery date is within next 5 days, then the field should automatically updated to “This Week”, and if delivery date has been passed then the field should be “Overdue”
frappe.ui.form.on('Sales Order Item',"child_table_name_remove",function(frm, cdt, cdn) {
refresh(frm); {
// your code here
if(frm.doc.delivery_date > frappe.datetime.add_days(frappe.datetime.get_today(), 12)) {
frm.set_value("item_dispatch_sch","Upcoming Week");
frm.refresh_field("delivery_date");
}
else if(frm.doc.delivery_date < frappe.datetime.get_today()) {
frm.set_value("item_dispatch_sch","Overdue");
frm.refresh_field("item_dispatch_sch");
}
frm.refresh_field("delivery_date");}});
pass the child table and name in the set_value() method as follows:
frappe.model.set_value(cdt, cdn, 'fieldNameInQuotes', 'value');
Then you probably want to refresh the entire table, not the field, i.e. frm.refresh_field('items')
Thanks a lot for the immediate reply. I have got it working, but it’s only updated whenever I am making changes in a particular form. But now I want it to keep updating on daily basis for all the submitted documents. Otherwise, it won’t help if the field is only updated while making changes and not automatically on the basis of change in date.
I guess for that we need to write a server script in the schedular event, but am not sure what the script code should be.