Skip to main content
Nintex Community Menu Bar

How to validate duplicate rows in list view

  • October 22, 2019
  • 3 replies
  • 225 views
  • Translate

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

Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+9
  • 266 replies
  • October 22, 2019

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

Translate

  • 173 replies
  • October 22, 2019

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

Translate

Forum|alt.badge.img+7

1. To Prevent Duplicate entry validation

click here 

2. Duplicate value in listview row[Top Kudoed]

click here 

3.Removing Duplicates from List Controls

click here 

 

All the best.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings