Duplicate check in a dynamic grid layout

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

Hi Arpit,

That was a really short version of that and worked completely fine. There's just a slight change for multiple cdt though.

For multiple cdt instead of replacing fv!index we can replace the index function all together with the column name.
Here's what it it looks like for me for multiple cdt,

if(count(wherecontains(fv!item.(columnName), ri!array.(columnName))) > 1
,"Duplicate",
{}
)

Please ignore the brackets with column name.

Regards,
Mohit Shah

Hi Arpit,

That was a really short version of that and worked completely fine. There's just a slight change for multiple cdt though.

For multiple cdt instead of replacing fv!index we can replace the index function all together with the column name.
Here's what it it looks like for me for multiple cdt,

if(count(wherecontains(fv!item.(columnName), ri!array.(columnName))) > 1
,"Duplicate",
{}
)

Please ignore the brackets with column name.

Regards,
Mohit Shah