Duplicate check in a dynamic grid layout

Question

Hi, I have a text field in dynamic grid layout. How do i check for a duplicate entry and generate a error message in validation? 
 (I'm storing the entries from the text field in a rule input of cdt type)

Arpit Bhargava · Accepted Answer

Hi Mohit 
 
You can try this below code to check the duplicate in the dynamic grid layout 
 
forEach( 
 items:ri!array, 
 expression: 
 textField( 
 validations:{ 
 if( 
 count(wherecontains(ri!array,index(fv!item,fv!index,{} ))) >1, 
 "Duplicate",{} 
 ) 
 } 
 ) 
) 
 
In place of fv!index you can use the column name if the ri!array is of multiple CDT type

Duplicate check in a dynamic grid layout

Top Replies