Make columns visible/editable in matrix

[AdKerremans]

Hi all,

It is possible to show/hide columns in a matrix on by example the order screen, but this is a manual action.

In the table cprf I can find if a (udf)column is visible and/or editable.

Is it possible to change this programmatically.

Any help is appriciated

Thanks

Ad

[Former Member]

Hi Ad.

Are you saying:

matrix.Columns.Item(COL_NUMBER).Visible = False

matrix.Columns.Item(COL_NUMBER).Editable = False

or manipulate this table??

Regards

Juli

[AdKerremans]

Hi Juli,

I don't mean this.

First: I want to check if a certain UserDefinedColumn is visible and/or editable

Second: If the column is not visible/editable I want to set it visible/editable programmatically, so my add-on won't crash.

I first thought I could use cprf to check wether a columns is visible/editable, but the table is not changed when I change the column.

Regards,

Ad

[AdKerremans]

Addition,

The table cprf is change when a user/compnay switch occurs or when sbo is closed.

[AdKerremans]

Hi,

I can use the column properties to check if a column is visible and/or editable.

And with the matrix in eg the sales order form I got the following answer from SBO support

As documented in the

UI help file (in the "restrictions" page) when a column (or item) is set to either not visible or not active using the "form settings" window,

you cannot change this properties using the UI. Therefore you must avoid this crash placing the code within an IF statement.