displayonly tablecontrol ( dropdownbox )

[HarryDeBoer]

Hi,

I have a tablecontrol with a column w dropdownbox. When the tablecontrol is editable it shows the description values in the dropdownbox.

When you set displayonly() to a tablecontrol, it doesnot show the visible values (descriptions) that stood in the dropdownbox, but the values in the database (table). How can this be achieved?

Regards, Harry
[/img]

[Hovik]

Harry,

First of all, the same principles apply whether the dynamic list is in a table column or in a form field

I'm not sure what you're trying to achieve.

Database table has entries:

Desciption1 ID1
Desciption2 ID2
etc

Question1. When the user selects a Desciption, do you want to store the Desciption or the ID in that field.

Question2. When the dropdown has a value and is displayonly, what do you want to show in the field.

[Steve]

Hi Harry,

I think you want to display the Description/Display value instead of the <b>actual</b> value when the table control is read only?

You will have to show a different column and substitute the value with the display value from the List:

Create a before table event that processes the values and write script as follows:

Code: Select all

function convertReadOnlyColumn()
{
  //hide table.MY_TABLE.MY_VALUE field control
  // show table.MY_TABLE.DISPLAY_COL field control
  //..
  //..

  var rows = tables.MY_TABLE.rows;
  while ( rows.next() )
  {
    table.MY_TABLE.DISPLAY_COL.value = table.MY_TABLE.MY_VALUE.getList().getDisplayValue(table.MY_TABLE.MY_VALUE.value);
  }
}

Note:
You will need to display table.MY_TABLE.DISPLAY_COL instead of table.MY_TABLE.MY_VALUE.

I think this should work.

Steve

[Steve]

If you are using Dynamic Lists, then you can map the display field to a table column and the actual value to a table column. Then show the column value required.

Steve

[HarryDeBoer]

Hi Steve,

yes I want to show the display value instead of the actual value. Thanks for your solution. One question: we build our lists in code (js) ..xxx.createCustomlist(). Does your soultion also apply for those lists?

Regards, Harry

[Steve]

Hi Harry,

Yes this will apply for custom lists.

Kind regards

Steve