Default Value for a column in matrix

[Former Member]

Hi,

How to set default value for a column in matrix which is of type combo(Yes/No).

The cell has combo in it

Manoj

[Former Member · Accepted solution]

I'm not sure, but I guess that if you set the values and the default one in the field on the table, it will appear as default in the matrix column!

[Former Member · Accepted solution]

Hi,

Can anyone give me a clear example on this ?

Manoj

[barend_morkel2 · Accepted solution]

Hi Manoj,

The column is set as combo. Now you need to tell SBO what constituates a Y or N. In my example my Column "Col6" must display Yes if the RENTED column = 1 and No if the RENTED column = 0. (I'm obviously using a datasource to tie the data to the matrix)

oMatrix = frm.Items.Item("YourMatrixID").Specific

oColumns = oMatrix.Columns

oColumn = oColumns.Item("Col6")

oColumn.DataBind.SetBound(True, "@VIDEO", "U_RENTED")

oColumn.ValOn = "1"

oColumn.ValOff = "0"