Is there a way to detect duplicate values in a cus...
# generall
Luis
05/04/2021, 2:06 PMIs there a way to detect duplicate values in a custom field and in a standard field without scripting? Maybe WF?
Detecting the duplicate at the time of entry and not after it was saved.
n
Netsuite Tragic
05/05/2021, 3:54 AMA WF will do this. I have a similar one that looks for duplicated use of customer order numbers. In my case I am using After Field Edit.
l
Luis
05/05/2021, 6:28 AMGreat! What's the condition? Is it based on a saved search?
n
Netsuite Tragic
05/05/2021, 7:30 AMTRIGGER ON
After Field Edit
TRIGGERING CLIENT FIELDS
PO/Check #
CONDITION
Customer : {my_custom_field} contains PO/Check #
l
Luis
05/05/2021, 2:13 PMWow. Thank you!
Luis
05/05/2021, 2:14 PMDo you have a custom field on the customer record? Is that a concatenation of the PO Numbers?
n
Netsuite Tragic
05/05/2021, 9:59 PMYes correct. From memory we only consider a certain period of previous transactions. This sped up the check.
l
Luis
05/05/2021, 11:02 PMMakes sense. Thank you!
2 Views