Dialog Set Value Method

[cavj1]

I have a Dialog that gets a value for a field from its parent grid.

var cov = {grid.Object}.getParentObject();
var ncov = cov.getValue("G","COVERAGE",cov._selectedRow);
{dialog.Object}.setValue('COVERAGE',ncov);

This works BUT it combines the values into a long string. See...the Coverage field on the Grid is a multi-select dropdown. So if you choose D&O, EPLI, ELP on the Grid it populates the Dialog field with D&OEPLIELP.

I'd like to separate the values with a comma or even a space as it is causing issues with my validation rules.

Any suggestions on how I can get the values separated?

Thanks
Joe

[Davidk]

Re: Dialog Set Value Method

In my tests the values are, by default, comma separated... for both implementations of a multi-select dropdown. Dropdown control and Textbox/Lookup control. I'm using your code. Opening a UX from the grid with the "Open a UX Component" Action Javascript.

[cavj1]

Re: Dialog Set Value Method

Thanks for the reply but that is very bizarre as I'm looking directly at the values and no comma is present. My Action JavaScript says "Open a Dialog component". This was an app built in the previous version of Alpha then ported over to the new version. Wonder if that has anything to do with it...

[-Jinx-]

Re: Dialog Set Value Method

I usually get comma delimited lists when I use a dropdown with multiple select or a checkbox but I don't think I've tried this. However; I could swear I watched a video on this and the commas had to be put in manually with this method. That doesn't sound like a big deal really. Can't you try that?
ncov = ncov + ','

[Davidk]

Re: Dialog Set Value Method

Ok... now I see it... sorry... I was just displaying the value of the Dropdown Control (you are using a Dropdown Control... not a Textbox Lookup) in an alert statement. I forgot that the contents of a Multi-select Dropdown control is an Array... not a string. An alert comma delimits the Array... but the setValue doesn't.

So... you can do one of two things. Either change your Textbox control on your UX into a TextArea control in which the Array will automatically be handled... or...

work with the array and change it to a comma delimited string with this code...

var cov = {grid.Object}.getParentObject();
var ncov = cov.getValue("G","COMPANY",cov._selectedRow);
{dialog.Object}.setValue('myDropdown', ncov); //myDropdown is TextArea control
var commaNCov = ncov.slice(0, ncov.length).join(',');
{dialog.Object}.setValue('myTextBox2', commaNCov); //myTextBox2 is a Textbox control.

[cavj1]

Re: Dialog Set Value Method

I'm sorry for the long stretch with no reply but I got hung up on another issue. Thank you for the code and input but in digging I've found that my DropDown control on a separate grid (where the data is passed from to the UX component) is storing the multi-select data as D&OEPLIMPL (no comma's...sorry but I think that is a string). Not sure if this is saving the data is correct or if I need to change the control some how. If I do my fear becomes what happens to all of the data already in the table???

Sigh...back to the drawing board.