Form values coming back as an array

💬 App Building
1

Hi,
This feels like it should be something simple, but can't see it at the moment.
I have a form, with a few text input fields in. When I fill in the fields on the form, then use and update query, with the Object Changeset.
I've then set it up to run a select query to refresh the data in the form, because I was finding that the data in the form was going back to the values after the update query ran.
However when that data comes back, the values seemed to be wrapped in an array, i.e. a value saved as "test" then comes back as "["test"]", and saving again wraps that in another array.
I can't see how I've got to the point of getting arrays as my values, any thoughts or ideas welcome.

Thanks,
Matt

2

Hmm, ok. I guess it was the data coming out of the SQL query. That comes out as an array for each field, which when the form first loads seems to hide the array of data? But then the next load starts putting the array into the form fields.
I changed the load function to transform the results with formatDataAsArray(data), which then gives the single result object I thought I was getting before. So, that now looks to be working ok.