CWM Workspace "Add Column" in board

[pramodkumar]

Hi All,

In CWM workspace board, we have an option to add new column from list. When we create new column, is this a new field in table ? Do we have any limitations on number of columns since users can create columns in different boards.

Thanks!

[Sunil B N]

Hi Pramod,
Adding a new column doesn't add new field technically in the table. It purposes one of the available columns in the table. We have limitation of 100 custom columns per Space.

• 25 Columns are reserved for types : people(multiple), url, long_text, label, reference multiple
• 30 Columns are reserved for date fields
• 45 Columns are reserved for small text, single reference, dropdown, number, true/false & other types.

I hope this helps you

Best Regards,

Sunil B N

[pramodkumar]

Thanks @Sunil B N 

Follow up questions, if there are 10 spaces created by users technically there can be 1000 columns is this right understanding? if yes, can you provide the table name where those columns are available? Also, can we report on these custom columns? Are these configurations available in ServiceNow docs?

Thanks!

[Sunil B N]

Hi Pramod

Yes, each space can have 100 custom columns. sn_cwm_task holds this data. You can report on standard columns, for custom columns you would need to build using scripted pa indicators. 

May I know what kind of reporting are you planning to have so that we can provide more information. 

 Thanks and regards 

Sunil B N

[kkulyeshie]

Hi @Sunil B N  -

We are using a board that has a total of 21 columns.  18 of these columns are labels.  I am reading the response above that we should be able to add a few more labels and even more "small text" columns or other etc... However, any new column we try to add returns a message of "Alert level: critical.

No columns for requested type are available in this space".  Any insight would be appreciated.  Thanks.