Skip to main content


 

Symptoms


Validating duplicate row entry on a list view based on the first column either during each row entry or on form submit/validate.

"For each item in a listview" but was not successful.

 

Diagnoses


There is no built in function to check for duplicates in a listview. Nested For loops are not directly allowed in smartform rules making it difficult to check for duplicates.


 

Resolution

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




 
Be the first to reply!

Reply