Skip to main content
arulk0002
Inspiring
April 3, 2022
Question

Validations two rows

  • April 3, 2022
  • 2 replies
  • 0 views

Hi Friends,

How to validate two rows and also between rows where the two rows are equal. please let me know how to do...

2 replies

harshitb6843
April 3, 2022

You can directly add validation on every field of the row where the logic can be to check the occurrence of fv!item in the array. If it is more than 1 then the validation should be invoked. 

if(
  wherecontains(fv!item,local!rows)>1,
  "Cannot have duplicate rows",
  {}
)

arulk0002
arulk0002Author
Inspiring
April 3, 2022

Thanks [mention:ef600ff8f5d2497eb2def2126dc89484:e9ed411860ed4f2ba0265705b8793d05] Let me check