Application studio multiple columns using ComboBox

I am building a custom Kinetic application. I have a Combo Box that has its EpiBinding set to a dataview and the combo is retrieving data from a UD code. I would like to pass the CodeDesc and LongDesc from the selected UD code to a function. I can obviously do this by setting the Value Field on the combo, but how would I access a second column based on the selected combo value?

I assume I would need to add both as Retrieve Columns, but not sure how to reference that column when calling my function or possibly have that combo mapped to two different columns in my dataview.

I’ve never actually done this, but shouldn’t the epBinding on the Text Column grab the displayed text?

Then again … you might not be displaying the long desc…

Yes, I have the combo set up to display the CodeDesc in the list of items using TextField and it uses the CodeID as the Value Field. Basically, I’m trying to also use LongDesc as a second Value Field. I am using the LongDesc on the UD code to store some additional data that I would like to pass to my function.

I could just have my function pull in the UD code data again, but I was trying to avoid this since I already have the data in the application, just not sure how to reference it.

image

I see

I’m not sure where the data is held after it’s loaded for a combo box … or whether it is accessible

You could call for it using the UserCodesSvc and an erp-rest widget, and store it in a data view, then fill the combo box that way… then all the data would be available to pull from (maybe a dataview-condition to select the right row and get your long desc?)

Much easier to write a BAQ for the data you need (or call the same service again) and just pull what you need at the time you need it.

Unless someone knows how to access that data initially pulled in for the combo… :man_shrugging:

Thanks, I’ll take a look at the dataview-condition. I had already tried this, so I do have the User Codes stored in a separate dataview already. I’ll see if I can make it work that way.

2 Likes

Did you actually found a way to do this? I am running into the same situation