Setting a Row as a combo box

Suite and Optimus Suite 5
#1

I see there are several ways to set a column as a combo box.

I have a fairly static table. It’s 3 rows by 9 columns.
I want to have the entire second row as a combo box. Is there a way to do this?

Thanks,
Drew

#2

You should enable combo for each cell in a row (feature works only in PRO version of dhtmlxGrid):

<rows> <row id="some1"> <cell> some </cell> <cell> some </cell> <cell xmlcontent="true">1<option value="1">The first</option><option value="2">The second</option></cell> <cell> some </cell> </row> </rows>

#3

I do have the pro version. Whenever I add the cell that should be a combo, I get an error saying:

SCRIPT438: Object doesn’t support property or method ‘toString’
dhtmlxgridcell.js, line 13 character 53

My XML looks like this:

<?xml version="1.0" encoding="UTF-8"?> NAME Date Time Direction Cost Surname Location Duration Extension FIELD Date Time Direction Cost Surname Location Duration 1The firstThe second AGGREGATE Sum Avg Count None None None None Extension

and is called using:
mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.setImagePath("…/…/codebase/imgs/");
mygrid.setHeader(",Field 1,Field 2,Field 3,Field 4,Field 5,Field 6,Field 7, Field 8");
mygrid.setInitWidths(“100,,,,,,,,”);
mygrid.setSkin(“dhx_skyblue”);
mygrid.init();
mygrid.loadXML(“xml/testgrid.xml”);

#4

In your grid’s init you have not defined column types.
Please, try to use setColTypes() method:
docs.dhtmlx.com/doku.php?id=dhtm … etcoltypes

And use “co” or “coro” for combo column.

#5

But that’s the thing… I don’t want the entire column to be a combo.
I want an entire row to be a combo.
The other two fields in this column I did not want to be combos.

#6

The cell or the column should have any defined type.

For a cell:
1The firstThe second

#7

Worked perfectly… thank you so much for your prompt response.

#8

New Question… I must be missing something.

When loading my embeded combo how do I specify (through XML) which combo value is selected by default. I have tried

selected=“selected”
and selected=“1”

but neither seem to work.

SURNAME FIRST NAME SURNAME AND FIRST NAME DATE
#9

Selected value should be defined as a value of a cell:

DATE

SURNAME FIRST NAME SURNAME AND FIRST NAME DATE
#10

Sometimes the easy solutions are the hardest to find.

Thanks again for your quick response.
This forum is great!

#11

One last question.

It would appear as though when I click on the cell, it creates a new entry at the bottom. So in the example below I actually get two “SURNAME” entries in my dropdown list. How do I ensure it selelcts the SURNAME in the list and does not create a new one.

SURNAME

SURNAME FIRST NAME SURNAME AND FIRST NAME DATE

Thanks again,
Drew

#12

Please, make sure that the value in the cell is equal to the value defined in options.
Make sure that there is no spaces before/after the value, or lowercase/uppercase characters are equal.

#13

I think I figured out the problem but can’t seem to figure out the solution.

If I define a grid cell like this

The first

The first The second

Everything works the way it should. When the user clicks the cell it show the right one. This seems to only work if the cell value is equal to the data. My challenge is that I need to specify a value that is not the same as the option text.

Example:
The first

The first The second

When I do this, the text “The first” is added to the bottom of the dropdown. Is there a way to specify the value of the default text to ensure it is selected properly?

#14

Nevermind, I figured it out.

I didn’t realize that the string after the cell tag would match based on ID. The example below does what I need it to.

[The second]

The first The second

Rookie mistake I’m sure.
Thanks anyway

Drew