Different values for different rows in a table

NAGENDRA_KOMMIREDDI · July 24, 2017, 4:16am

i want to store the different users whwnever the verify button is clicked but because of this code it just duplicating all the values whenever the button is clicked

Below is my code

Sangram · July 24, 2017, 4:39am

@NAGENDRA_KOMMIREDDI

Before adding user’s entry in table check (using script) whether a user is already added or not in a table.
So it will avoid duplicate entry.

NAGENDRA_KOMMIREDDI · July 24, 2017, 4:47am

sorry to trouble you,can you help me with the code
And if i validate it then it will post an error of duplicating …i want to insert a new row with out modifying the previous rows…

Sangram · July 24, 2017, 4:59am

Check sales_order.py for avoiding duplicate entries.

Refer this

github.com

frappe/erpnext/blob/develop/erpnext/selling/doctype/sales_order/sales_order.py#L78-L83


      
          		# validate p.o date v/s delivery date
          		if self.po_date and not self.skip_delivery_note:
          			for d in self.get("items"):
          				if d.delivery_date and getdate(self.po_date) > getdate(d.delivery_date):
          					frappe.throw(
          						_("Row #{0}: Expected Delivery Date cannot be before Purchase Order Date").format(d.idx)

NAGENDRA_KOMMIREDDI · July 24, 2017, 6:19am

Will the unique filed will do the validation ,but the problem is when the first user is inserting the fields are…

And when the second user is verifying
it is updating the previous rows values …although it didn’t saving but i don’t want to update the previous rows …please help me with these …And by default it is raising an error for the duplcate values for the fields in the child table …
Thank you