How to hide fields that are unused from personalize list columns without Deactivating the field.

[mouli7]

Hi all,

How to hide unused/duplicate fields from the personalize list columns of a table without deactivating the field. what would better approach to hide it.

There are some 30 fields and are not being used by the end users on a table(Business applications) that reported by client.
But somehow i saw still there are some data and scripts involved in it,  so we are not ready to deactivate those field.

ISSUE: The end user is getting confused as there a fields with same column name and the field that are un used. This affect when reporting they are confuse which has the right data.

[Harsh Vardhan]

@mouli7  Create one READ ACL, select name as <table>.*

Sample script:- 

eg: 

answer = true;
var rr = root_rule.split('.')[1];
var excludedField = ["field1","field2","field3"];  // define field name based on your need. 
if (excludedField.indexOf(rr) > -1) 
	answer = false;

Hope it will help you.

Thanks,

Harsh

[mouli7]

This solution not hiding field from the personalize line.

it is hiding from the form.

why is that so?

[Harsh Vardhan]

Hi @mouli7  READ ACL hide fields from "Form" and the "List" view .

To hide column from personalize bucket , you need to use "add_to_list" ACL, but you won't be able to write script on it, it's limitation, that's why I had suggested for READ ACL . 

Note: 

add_to_list

Prevents users from viewing or personalizing specific columns in the list mechanic. Note: Conditions and scripts are not supported.

Doc Link:

If READ ACL does not work then you have only one option, Create add_to_list operation ACL for each field.

Thanks,

Harsh

[mouli7]

can you please give me some ide on how to do that scripting