User cannot write to custom table

RichGK1
Mega Expert

I have created an application in studio where the table extends task.

I assign the role needed for a user to access the table but when impersonating the user the fields are greyed out on the table form. The user can access all other aspects of the application and modules that are controlled by the same role OK. Also the user can create records in the table when clicking submit.

The CRWD access controls that are automatically created are all table.none

Is this something to do with inheriting task?

 

 

1 ACCEPTED SOLUTION

OK I've done some reading and even though the rules for the custom table are table.none, the system will check for these and then check the parent task table to see if there are any rules applied there.

As there definitely are rules and they are more specific these are overriding the generic child table rules.

Long story short in order to inherit from the task table and allow users to fully utilise the child table you need to assign the task_editor role to that user as well as the new roles for the child table.

 

View solution in original post

7 REPLIES 7

amaradiswamy
Kilo Sage

Are the fields which were grayed out are inherited from task? if the fields which were grayed out were created in the custom table then you may check Write ACL as your statement indicates that user has access to create but not edit.

Yes the grayed out fields are all inherited from task

Ian Mildon
Tera Guru

The user has the "read" permissions from the ACL rules, but it sounds like they don't have "write" permissions.

You may need to create a new "write" ACL and in the new ACL, set the Name field to the custom table and in the field next to that, select the * to signify all fields on the table. Then insure the role is selected in the Requires Role list.

Thanks I thought that would do it but all the fields are still grayed out. I can verify that the test user has the relevant role garden_fullfiller (yes I spelt it incorrectly!)

find_real_file.png

find_real_file.png