Datatable validation not working

Forms SharePoint Online
1

Hello, I am new to plumsail and am stuck with the datatable (list or library) validation.
I want check that atleast one file is uploaded.
I have tried the following but i can still submit my button:

fd.spRendered(function () {
    validateUpload();
});
function validateUpload(){
    fd.control('FilesTable').addValidator({
        name: 'DMP upload validator',
        error: 'Upload at least one DMP into the table',
        validate: function(value) {
            if (value.length == 0) {
                return false;
            }
            return true;
        }
    });
}

The error I get is:

image

Could you please look at it for me?

2

Dear @asmita_adh,
Welcome to the community! List or Library control simply doesn't have validators, instead, use form validators to check it:

fd.validators.push({
        name: 'DMP upload validator',
        error: 'Upload at least one DMP into the table',
        validate: function(value) {
            if (fd.control('FilesTable').widget.dataItems().length == 0) {
                return false;
            }
            return true;
        }
    });
3

Hi @Nikita_Kurguzov , thank you for your reply!
Unfortunately it doesn't seem to work for me. I do not get any error message.
Is there a way to block form submission when there are "errors" on the table?

Thanks :slight_smile:

4

Dear @asmita_adh,
What errors are you talking about? This should prevent submissions, if there are 0 records/files in the List or Library control:

eRavCysevD
eRavCysevD1426×752 472 KB

5

Hi @Nikita_Kurguzov ,
By errors I mean the ones shown before submission when dataLength is 0.
I think my errors do not show maybe because I use custom save button.
Is it possible to catch these errors when using a custom button?

Thank you already!

6

Dear @asmita_adh,
Shouldn't be related to a custom save button. Check browser's console for errors.

8

No errors :frowning:

9

Dear @asmita_adh,
What if you remove the rest of the code from the form and leave just this:

fd.spRendered(function(){
    fd.validators.push({
        name: 'DMP upload validator',
        error: 'Upload at least one DMP into the table',
        validate: function() {
            if (fd.control('FilesTable').widget.dataItems().length == 0) {
                return false;
            }
            return true;
        }
    });
});

Also, check the Name of the List or Library control, is it FilesTable?

10

Hi @Nikita_Kurguzov ,

Yes, I tried that.
However, the errors is only shown when i used fd.save() on my custom button. I need to however be able to update sharepoint list and add the files to dynamic folders.
But the check is useless when I add the codes to do anything.

I also tried using fd.isValid() before saving. That partially works only: I have two different validations - one for the List or Library table, other for a dropdown. the fd.isValid only catches the length check but not the dropdown check.

The validators are added to the spRendered function. This is my code on my button for your reference:

$('.saveButton').on("click", function () {
        var statusTxt = fd.field('statusDropdown').widget.text();

        if(fd.isValid){
            addFileToRootFolder();
        list.getListItemEntityTypeFullName().then(entityTypeFullName => {
            let batch = pnp.sp.web.createBatch();
            list.items.getById(fd.itemId).inBatch(batch).update({
                Status: statusTxt
            }, "*", entityTypeFullName).then(b => {
                console.log(b);
            });
            batch.execute().then(d => {
                console.log("Done");
                fd._showAlert('Files sucessfully saved to folder ' + fd.field("Title").value);
            });
        });
    } });
11

Dear @asmita_adh,
Okay, can you share the dropdown validator? Previously, we've only discussed the List or Library validator.

12

Sure :slight_smile:

image
image1613×376 23.4 KB

fd.field('statusDropdown').validators.push({
        name: 'Status validation',
        error: 'Please select a status for your submission.',
        validate: function(value) {
            console.log(value, '***************');
            if (!value) {
                console.log('test');
                return false;
            }
            return true;
        }
    });
13

Dear @asmita_adh,
This validation should still work, I've just checked. What if you try the following, would get the error?

$('.saveButton').on("click", function () {
        if(fd.isValid){
            alert('Hello, world!');
        }
  });
14

Hi @Nikita_Kurguzov ,
Thanks for your guidance.

It works now. :slight_smile: