Rearange Columns visual order.

[Former Member]

hello experts,

is there, any way to re-order the columns of one matrix object?

let's say that I have the matrix on the Invoice, and need to show some user fields columns before all the system columns..

how can I perform this in code?

thanks for the help

best regards,

gab.

[former_member201110 · Accepted solution]

Hi Gabriel,

You can use Form Settings to change the order of the columns in any system form that has a matrix. This can done manually by opening the Form Settings window and dragging and dropping the column names to get the order you require. Please note that these settings are user and form type specific so you'd have to repeat the process for each user.

There is a way to set Form Settings via the DI API but it's not very pratical because the settings aren't saved and displayed on the form until the user logs out and logs back in again. The object you need is called FormPreferencesService. There are some code examples in the SDK documentation. Again, this must be used on a user-by-user basis for each system form type.

Kind Regards,

Owen

[Former Member · Accepted solution]

Thanks for the help, this object do the work as I need... Thanks again...

Best regards.

gab