jQuery Grid Plugin - jqGrid - Topic: Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value Simple:Press Version 5.7.5.3 tony on Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1440 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1440 Ok,

When the values are static here is a fragment on how to do that:

afterInsertRow : function(rowid,recdata){

var idtotext;

colid = 2; //the id of the column which holds the select begin from 0

switch (recdata.selectid){

case 'AB':

idtotext = 'ABTEXT';

break;

….

}

$(”#mygrid”).SetCell(rowid,colid,idtotext);

// when we use colid instead of colname this method is faster

}

Regards

Tony

]]> Thu, 07 Aug 2008 10:27:50 +0300 tony on Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1436 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1436 This is true only if the values in editoptions are static. In case of dynamic values in options this will not work since the engine will read the data, but the text are not redy yet.

Instead I will try to investigate this

Thank you

Regards

Tony

]]> Thu, 07 Aug 2008 05:27:36 +0300 daniel.pool on Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1434 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1434 Hello,

Sorry to butt in on a post, but I was about to request the same feature. My drop down lists uses the database ID of a field for the select's value and a text field as it's text. The fact that jGrid returns the value is great as I can simply put the ID into the referencing object. However, I'm having to fudge some nasty look up code (a problem with my companies framework) in order to provide the text value in the cell to resolve the drop down. It would be much easier for me to be able to use the ID and have the drop down resolve using that.

Regards,

~Dan

P.S. Your suggest to use the text and the value element of the select is not really feasible as some of the names can be very long and are not guaranteed to be unique.

]]> Thu, 07 Aug 2008 05:15:33 +0300 tony on Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1433 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1433 Hi Jon,

I think that I do not undertstand something. So let me explain what I know.

To the grid you send the text of the combo - right?

You use formedit to change the values of that field.

But before doing this jqGrid should know what for values and text are

for this combo - right? This is done via editoptions:{value:"key1:value1;...

In other words you should construct editoptions value. This can be

done statically and dynamically depending on your needs - or simply

we should have the key before they is sended to the server.

My question is where are the keys for these combos?

Best

Tony

]]> Thu, 07 Aug 2008 02:55:54 +0300 Jon on Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1430 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1430

Hi Tony. When I supply the JSON data to the grid I send the dropdown text.  When the user saves (I am using formedit -nice job BTW!) the value is sent back.  It would be desirbale to not send the text but instead send teh value and have the form combo box bind to the value instead of the text.  Hopefully that makes sense.

TIA

-Jon

tony said:

Jon,

What about keyvalue = text - I mean you can construct the dropdown to have the same values of key and text - If I understand right.

Regards

Tony

]]> Wed, 06 Aug 2008 19:18:11 +0300 tony on Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1395 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1395 Jon,

What about keyvalue = text - I mean you can construct the dropdown to have the same values of key and text - If I understand right.

Regards

Tony

]]> Tue, 05 Aug 2008 01:42:05 +0300 Jon on Dropdowns bind to a "text" value instead of a key value.... http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1389 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/dropdowns-bind-to-a-text-value-instead-of-a-key-value#p1389 .... but post to the server as a key value.

Hi All,

When binding to a dropdown list my data has to contain the text of the dropdown versus the value of the dropdown.  When the form posts back to the server it contains the value not the text.  Anyway dropdowns can bind to the value instead of the text?  or at least have a switch?  I understand wanting both but the current implmentation mixes them together.

(Again I am total n00be!)

TIA

-Jon

]]> Mon, 04 Aug 2008 20:50:49 +0300