How to setup validation to check if the input value duplicate in a data page record?

General
,
1

I have a Data Page called CarList. And in the case creation form there is a “carID” input field. I would like to add a validation so that the form can return warning and not to proceed if the user entered a duplicated carID. But I cannot find a suitable function in validation to do the checking with the data page. Anyone has faced this issue before or has any suggestion on that? Thanks.

Car validation.png
Car validation.png2705×1083 231 KB

2

Hi @Valor: Can you confirm if the below understanding is correct

  • CarID is a single value property
  • CarList Data page is the source for dropdown

In this case, what you are you trying to validate? Can help to understand this.

If you are looking for duplicate validation, you can select expression evaluates to true and can use functions like countinpagelist, removeduplicates to validate your scenario.

If this not the scenario, can you share some additional details on your configuration masking confidential details?

Thanks.

3

@Valor Hi,

Can you please check using the below functions?

Function.png
Function.png1099×402 35.3 KB

If that doesn’t help you can use expression evaluates to true and use your logic using is in pagelist and is in pagelist when and then set the error message

4

@Valor Hi

Try this Approach

In that select function, Select the expression evaluates true.

In that you have to use the expression is: D_CarList[carID:.carID].pxResultsCount>0

It will check the any duplicate value present in that D_Page. If it is present the result count is 1 and it will throw the error. If it is not present, then it will continue case.

Thanks