Adaptive Form Table - Validate for duplicate values in table column

[techddx]

Hello,

I am working on an adaptive form table that is dynamic with multiple columns. Users are able to dynamically add and remove rows. In one column is a unique identifier for "Item Name" and all values should be unique in this column. When the user inputs a value in this column, it should give an error and highlight the field if it already exists. Is there an out of the box method to achieve this? 

Thank you

[workflowuser · Accepted solution]

There is no out of the box method to do that

you will have to write some custom code

[Mayank_Gandhi]

@techddx You should create an array in the script editor, as the user is entering the value in the table field you can add that value to the array, and before inserting you can check if the value exists in the array using 'includes'.

const greetings = ['hi','hello'];

greetings.includes('hi'); // => true so you can prompt error message

greetings.includes('hey'); // => false, add this to greetings => ['hi','hey']

refer: https://www.w3schools.com/jsref/jsref_includes_array.asp