How to validate duplicate rows in list view

Hi Everyone,

When adding a row to list view or on the event list row added, no duplicate values should be entered. It should be validated in the "Add new row" button click.

via database it is validated, without saving to database we have to validate with in the view itself.

Please suggest me any solution ASAP.

Thanks

Surya

Page 1 / 1

Hi Sthurangi

Workaround:
Create 3 parameters
current string - text
dupsFound - number set to -1
valid - bool true

Using an unbound rule as the inner for loop, and calling “then execute another rule” rule as the outer for loop creates the logic necessary to check for duplicates.
When a duplicate is found dupsFound 1 in a statement,
If dupsFound >= 1 set valid to false.

Screenshot located (bottom of page): http://community.k2.com/t5/K2-blackpearl/Duplicate-value-in-listview-row/m-p/86145_M26496

Ref: https://community.k2.com/t5/K2-blackpearl-Articles/How-to-validate-for-duplicate-row-entry-on-a-list-view/ta-p/86291

Regards

Elvis

Hi Sthurangi

See the link below, i hope it will resolve your issue.

https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Duplicate-value-in-listview-row/m-p/86145?nobounce=#M26496

Best,

Sunrise

1. To Prevent Duplicate entry validation

click here

2. Duplicate value in listview row[Top Kudoed]

click here