Hi, I need a help. Am having a table with check box while Am selecting the box and save it the data need to be fetched to the below table but the data is getting stored again and again for every save. So, now how to stop this duplication of data in child table? [image] validate: function(frm,cd…

Hi @VINOTH , Please check it. [image] Users cannot add rows with the same item twice. If do, then show an error message and remove the row/item from row @shuvro-baset You can achieve that through creating a Client Script on the Vehicle doctype form and the script should b…

Users cannot add rows with the same item twice. If do, then show an error message and remove the row/item from row frm.refresh_field('vehicle_items'); Hi, @NCP Nope this is not working in my case :frowning_face: Could you help me out in my case please :raised_hand_with_fingers_splayed:. Th…

Hi @VINOTH , Please try it. frappe.ui.form.on('Child Table Name', { duplicate_field_name: function(frm, cdt, cdn) { var d = locals[cdt][cdn]; $.each(frm.doc.table_name, function(i, row) { if (row.duplicate_field_name === d.duplicate_field_name && row.name != d.name) …

I haven’t idea about your scenario. I just share the code to stop duplication. so apply the code according to your requirement. Thank You!

How can we achieve this using Server Script?

Something similar logic has to be set up. [image] How to remove row of child table using script? ERPNext Please check it. [image] [image] Output: [image] I provided the sample, now you can set it according to the scenario.

Hi @umarless , Please apply the server script. DocType Event → Before Save Scenario 1: If you want to set the warning then you can apply it. items = doc.get("items") item_codes = set() for row in items: if row.item_code in item_codes: frappe.throw(f"Duplicate entry found: {row.item_c…

Could you please share the screenshot for a beginner like us to learn more Thanks

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace GitHub

Frappe Forum

Child table value Duplication

ERPNext

VINOTH January 10, 2023, 5:57am 3

Hi, @NCP
Nope this is not working in my case
Could you help me out in my case please .

Thank you.