List and Library to Auto Change ReadOnly

Forms SharePoint Online
1

Hi,

I set List and Library as read-only for Edit view since users are not supposed to edit it after submitted. But there is a request to allow for edit before the form is approved.

I want the table to be editable if the status field is not equal to Reviewed or Approved.

What is the correct script for that?

image
image1196×181 8.41 KB

image
image260×522 8.88 KB

2

Hello @noorshahida88,

You can change List or Library control read-only property dynamically using the code:

fd.field('Status').$on('change', function(value) {
    if(value == 'Approved') {
        //make control editable
        fd.control('Control1').readonly = false;
    }
   else {
      //make control read-only
      fd.control('Control1').readonly = true;
  }
})
3

Hello @Margo ,

I have tried but nothing changed.

fd.spRendered(function () {
fd.field('WorkflowStatus').$on('change', function(value) {
if(value == 'Requested') {
fd.control('SPDataTable1').readonly = false;
}
else {
fd.control('SPDataTable1').readonly = true;
}
});
});

fd.spRendered(function () {
fd.field('WorkflowStatus').$on('change', function(value) {
if(value == "Requested") {
fd.control('SPDataTable1').readonly = false;
}
else {
fd.control('SPDataTable1').readonly = true;
}
});
});

4

Hello @noorshahida88,

What Plumsail Forms version are you using?

Are you getting errors in the browser console(F12)? Please share the screenshot.

5

Plumsail for version 1.9.4

no error found

image
image542×691 26.4 KB

6

@noorshahida88,

Please update to the latest version of Plumsail Forms designer which is 1.9.8.

And share errors from the console tab:

image
image882×176 18.7 KB

7

Version updated but I don't see any error when opening the Edit form.

image
image1294×513 29 KB

image
image621×516 21.9 KB

8

@noorshahida88,

Do you need to make control editable/disabled on form load? If so you need to call the function within spRendered also:

function enableDisableControl () {
        if(fd.field('WorkflowStatus').value == 'Requested') {
                fd.control('SPDataTable1').readonly = false;
        }
        else {
                fd.control('SPDataTable1').readonly = true;
        }
}

fd.spRendered(function () {

        //call function on field change
        fd.field('WorkflowStatus').$on('change', enableDisableControl);

        //call function on form load
        enableDisableControl();
});
1 Like
9

Hi,

It's worked! TQVM!

1 Like