Hi
really struggling. I have a simple form that has a multiple select in it. This form is used to update. So, I want the multiple select to select the values previously entered.
I have the select populated with a query from a DB, that all works.
I then do my query to select previously entered values, but not sure how or what to select in the selected value box
I have a multi select form element. It’s values come from the dB. It is a list of unpaid invoices, which is on a form where we enter payment information, so we enter payment information and select the invoices the payment relates to.
That all works
But, if we make an error on the payment we need to edit, so, now I get the payment details we entered and dynamically populate the form, it all works except the multi select list, I want the original selected options highlighted for the edit.
I have the data from the dB and it says it is an array, but adding that to the multi select in the selected value box does not work.
and flatten is just never in my data formatter, the flatten is just not there no matter object i select or what i tell it the object is, string, array, object etc etc, i never get flatten as in data formatter
feels like there might be a bug in wappler here, i never get flatten and, even if i enter the invoice_id manually in the selected value box its not selected