Edit Grid Dropdown

[rsnell]

I'm setting up an edit grid that has an editable field. The editable field has a drop down for selecting the required value. In this application, the dropdown presents the user with user names in order to be able to return the user id. The dropdown seems to work fine, but the field on the grid shows the code rather than the selected name. Is there a way to get the grid field contents to match the values displayed in the dropdown or have I just configured something incorrectly?

[Johnny Major]

If I understand correctly, I would update the edit grid data source and its columns to display the user name for the user id, not the id itself. I assume that you might need to join the table that contains the user name corresponding to the id.

[rsnell]

I'm not sure if I explained correctly. Take a look at the image I've included. The dropdown for editing shows the user name, but the grid has the the user id.

FireShot Capture 093 - Valence 6.1 - i.drakeextrusion.com.png

[sean.lanktree]

The data source for your grid is already returning back the ID of the "assigned to" user. Let's call this field "ASSIGNID".
Change your data source to also include the name that matches that "ASSIGNID" value...let's call the new data source field "ASSIGNNAME".

Now you can apply a custom formatter against your "Assigned To" column:

return rec.get('ASSIGNNAME');