0

When trying to enforce certain business rules on list Forms, there's always the risk that users will use QuickEdit to circumvent them.

Is there a way to detect if QuickEdit is enabled (or whether this option changed)?

enter image description here

Quick tests show that SchemaXml is not affected by changing this radio button (only list version changes) and there's no obvious property to check in REST API or CSOM.

Any ideas would be appreciated.

Improve this question

3 Answers 3

Reset to default
2

You can get the Quick Edit property value of list using SharePoint REST API.

For all lists on the site:

https://tenant.sharepoint.com/sites/siteName/_api/web/lists?$select=Title,DisableGridEditing

For single list:

https://tenant.sharepoint.com/sites/siteName/_api/web/lists/getbytitle('listName')?$select=DisableGridEditing

If Quick Edit is set to "No", DisableGridEditing returns true value.

Improve this answer
4
  • 1
    Thank you Ganesh, but we're using an on-prem 2016, not SPO/O365
    – Alexey Krasheninnikov
    Commented May 19, 2022 at 11:47
  • Oh ok. Right now I don't have 2016 environment to test above API. Can you check using it on your 2016 environment? Meanwhile I will check if there is another way to check this in 2016.
    – Ganesh Sanap - MVP
    Commented May 19, 2022 at 12:03
  • 1
    Check this article which might help you.
    – Ganesh Sanap - MVP
    Commented May 19, 2022 at 12:11
  • Thanks a lot, that article is very interesting for UI customization, which is a valid, but rather different scenario. Anyway, very much appreciate your effort, @Ganesh.
    – Alexey Krasheninnikov
    Commented May 19, 2022 at 12:44
1

If you want to restrict the users from modifying list settings (ie, changing the Quick Edit settings) , why can't you restrict them using permission levels?

If you provide 'Contribute' permission to them, I believe users won't be able to change the settings then.

enter image description here

I know this is not the answer to your question ("Is there a way to detect if QuickEdit is enabled (or whether this option changed)?"), but after understanding the requirement I thought about this approach.

Improve this answer
1
  • Thank you for the contribution. Even if they are restricted at some point in time, somebody could have a valid case to re-enable it for a short period of time and then forget to re-disable. We'd like to detect that issue proactively.
    – Alexey Krasheninnikov
    Commented May 19, 2022 at 13:55
0

For the time being, we surely can and will parse the list's Advanced settings page, but a more elegant solution is very welcome.

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.