How to completely hide a table column?

[jamesgo]

We are decommissioning a table field but if I don't delete the column, is there any way to complete hide the column from list view, reporting, etc?

[NeilH2]

Add an access control rule   to the field allowing the nobody role to read it.

This will remove it from view on forms and lists

If you want admin to access it when needed set the role to admin

[jamesgo]

Hi NeiIH, that is what I did(see below), it hides the field from form, but not the column on list(the column values are blank out though), it also doesn't hide the column when creating a report. Am I missing something?

ACL name: tableName.columnName

Operation: read

condition: none

script: gs.hasRole("nobody");

require roles: none

[NeilH2 · Accepted solution]

Remove the script and add the role "nobody" to the requries role.

Note: bhaveshumour is correct you can just turn off the field, I should thought of that.

[praveenpara]

I am not able to add the "nobody" to the require roles, because it is reference field, it is not allowing me to add the "nobody".

also will it work if the fields are related fields.

Regards,

Praveen