Why bulk update using Update Selected/Update All not working for certain table?

[Khang1]

The specific table I'm working on is 'sn_compliance_control'. From the list view, I select some records, click on the list context menu and choose 'Update Selected'. The editing form popped up but all the fields are read-only and don't let me do bulk update. I check the bulk update with some other tables and it works fine.

Can anyone help pointing out what restriction in place on the table that doesn't allow bulk update? Greatly appreciate it.

[The SN Nerd · Accepted solution]

This is just a reflection of how the ACL's evaluate against a Control record that is empty.

You can work around this by following the steps below:

Create a write ACL on the Control table for the 'list_updater' role.

Add the following script to ensure it only functions for list update screen:

// Makes fields editable on update all screen
answer = gs.nil(current.getValue('sys_id') );

You may need to create a wildcard rule as well if the above does not work.

[Khang1]

This works. Thanks for the help! I had to create write ACL for Control table at both the record (with '*') and table level (without '*') for the role 'list_updater' to make it work. 

Apparently there's a table ACL in place that only allow users to edit only in Attest and Draft state, which restricted the access originally I assume.

[Allen Andreas]

Awesome!

And nice work Paul for the answer.

Please mark any other reply as Helpful, if it was.

Take care!