Forums

UPDATE - SOLVED - SEE DISCUSSION FOR SOLUTION
I have a form that includes a multi-select dropdown. This stores the selected items in a db field, delimited by commas, as expected. For example, 'red,green,blue'.

The form use a record loader to also edit the record. This works fine for all other fields, displaying them correctly, and when saved again all changes are saved.

But on an edit the selected items in the drop down are not reselected.

Should a multi-select dropdown reselect all previously selected items, or do I have to do something to make this happen?

Hi JeffP,

I think that it should be automatic (provided that it is saved as a comma separated list as your are). There was a bug with checkbox groups which behave in the same way but I thought that Max had fixed that. I'll take a look later.

Bob

Thanks Bob. It definitely is saved as a comma delimited list. But even one item selected isn't reselected.
Look forward to what you can find.

Hi Bob
So far I have had no luck with getting this to work for multiple select, but found out it does work for single select.

How did you go looking at this?

Just an update. I have upgraded my installation of the component to the latest V4.0 RC3.4.1 and still can't get multi select drop down to reselect items on an edit.

Really need help here as this has me totally stumped and is a brick wall.

Without this I am not sure how I can give auser the ability to select multiple items from an extensive list.

Hi JeffP,

It's a known bug (see this post). Please try contacting Max for the fix.

Bob

Thanks Bob. Will do.

UPDATE - SOLVED
To make a multi-select work so it reselects items when editing a record you need to do the following -
In your DB Record Loader action go to the Advanced tab.
Add the name of the field you are storing the data in to the Array Field Sets property.
Add the delimiter for the array to Array Separators property - which is a comma.

Hi JeffP,

Thank for the update - I didn't know about that option (or if I did I had forgotten).

Bob

Later: I added your post as a FAQ