Goal: Have 3 tables: sensor_db, modem_db, assets_db. Form is populating assets_db with a new entry. this form contains a multiselect for picking what sensors and modems are installed in specific asset. This multi select elements populate foreign keys in modem_db and sensor_db with an id of that ass…

Issue with populating tables with multi select form element arrays

Paulo April 8, 2024, 9:52pm 2

Hi @Scottsky, try using ANY({{ pgArray... .value }}).
Check this SQL Cheatsheet for Retool.
Let us know how it goes!

Topic		Replies	Views
Malformed array literal 💬 Queries and Resources	5	5728	August 2, 2023
If I select multiple rows in a table, how do I mass update them in Retool PostgreSQL database? 💬 Queries and Resources	5	3834	June 26, 2023
SELECT statement expands {{Multiselect.value}} to a string as opposed to an array of integers 💬 Queries and Resources javascript , sql , component	4	1453	August 30, 2023
Connect dropdown to JSONB field in table. Works as key value pairs, not as form object 💬 Queries and Resources dropdown , easter-egg-hunt	8	1158	April 22, 2024
How to format Postgres SQL when inserting an Array data type 💬 Queries and Resources postgres	4	3186	August 2, 2023