Define columns for table fields for all users

ERPNext
1

Hi Team

We have a custom table in the quotation doctype which has severall columns which are mandatory and some which are just useful to see. I can change which columns are shown for my user but I want to set the default columns for all users. How can I set it, that it changes it for all users on the system?

image
image1013×126 17.2 KB

Thanks in advance,
Kevin

2

Customize the child table doctype and go through the fields, in the field properties, check/uncheck the “in list view” for any field that you want to show/hide.

3

But first, reset the columns

image
image1920×924 36.8 KB

After then follow the @Yamen_Zakhour step.

1 Like
4

Hi @Yamen_Zakhour and @NCP

Thanks for your replies. It worked. :slight_smile:

5

Hi All

I just tried adding another column using the steps in the answers above, but it doesn’t show up. I had to uncheck “in list view” for all entries, save and then check them again and then they appeared. But this doesn’t seem to work anymore. In general the whole thing seems kinda random. From time to time the newly added column appears but mostly it’s missing.
I cleared the cache and reloaded the site, but it’s still not there.

Please advise.

1 Like
6

Hi @cdg

Did you eventually find a solution to this ?

Kind regards,

7

I figured it out. In my case all I had to do was ensure I unchecked all other fields that had ‘In List View’ checked. I’m referring to fields that were checked by default but which I didn’t need in the grid view

Cheers

8

One small addition, on any enabled field with “In List View”, don’t forget to set minimum of 1 in field “Columns”. And as described “Number of columns for a field in a Grid (Total Columns in a grid should be less than 11)” so take that in the account for all enabled fields.