Prevent users from selecting duplicate data item in Data Table Control

Forms SharePoint Online
1

Hey Plumsail,

Is there a way to stop users from select the same data item twice in a datatable?

If I select Oct-24 in the first record and Oct-24 in the second record, I want the form table to throw an error:

image
image818×346 10.3 KB

I only want the user to provide a single monthly update not multiple.

Thank you!

2

Hello @DryChips,

You can add column validation. This is an example:

fd.control('DataTable1').addColumnValidator('Column1', {
    error: 'Error message',
    validate: function(value) {
        let column1 = [];
        fd.control('DataTable1').value.forEach(i => column1.push(i.Column1))
        column1.some(v => v === value)
    }
})
3

When I set this up in the JS section, nothing happens.

I have the datatable set up with default names like in the example.

4

Dear @steinn_sig,
Very simple code, try it out:

fd.rendered(() =>{
    fd.control('DataTable1').addColumnValidator('Column1', {
        error: 'Already exists',
        validate: (value) => {
            let hasValue = 0;
            fd.control('DataTable1').value.forEach((row) => {
                if(row.Column1 == value){
                    hasValue += 1;
                }
            });
            return hasValue < 2;
        }
    })
})