I am creating a multipage page app, each page will be connected to a DB and updated using a form. I populate the form using SelectedRow which loads the table’s latest entry. One of the fields I am using updates a column for a record, the specific field is connected to a separate DB to select the values to populated (in this case keywords). The field needs top be able to add multiple values once.
Issue:
Currently I am using multi-select input field to update multiple values, however the when I enter values submit the form the DB is storing the values in this form:
{ value1, value2 }
Subsequent pages do not show the values in the form, despite the table displaying the field.
Steps I've taken to troubleshoot:
I’ve tried switching input type to Multiple Listbox however I get the same issue.
Additional info: (Cloud or Self-hosted, Screenshots)
In a multi-page app on a Cloud instance, a multi-select input writes its selections into a text column as a Postgres array literal (e.g. { value1, value2 }), but on subsequent pages the form's multi-select does not display those stored values even though the table shows the field.
AI Response
This is a data round-trip/formatting issue rather than a bug. The multi-select outputs a JS array, but once it is saved to a text column it comes back as a single string like {"value1","value2"}, and the component's Default value expects an actual array of strings — so it renders none or only one. Parse the stored string back into an array before binding it (e.g. {{ query.data.field.split("'").filter((_, i) => i % 2 == 1) }} for a Postgres array literal, or UNNEST the array in the read query), and make sure the saved values exactly match the option values, including type (string vs. number). Also note that the multi-select on each page is a separate component, so each page needs its own query that re-reads the record (e.g. via selectedRow or a URL param) and points the Default value at the parsed array.
Sources
Mult page app - Multi-select values are not being displayed on subsequent pages
A staff-diagnosed thread on the identical multi-page scenario, explaining that the saved string must be parsed back into an array for the Default value and that each page's multi-select needs its own query to re-read the record. Multiselect default value not loading
A solved thread with the exact { "value1", "value2" } storage format not displaying on load, where the fix is splitting the array-literal string into an array or using UNNEST in the query.
The Community Team is testing out a new automation. Let us know if it's helpful (or not) by leaving a , , or . Or by marking this post as the "Solution"! Let us know if you have any feedback here.
First, check the database column where the multi-select value submitted through the form is stored. Make sure its data type is String. If it is not, change it to String first.
Then, when storing the multi-select value through the form in GUI mode, it should be stored in the format shown in the image.
, 
, or 
. Or by marking this post as the "Solution"! Let us know if you have any feedback 
