Multiselect to Retool Database


I recently started using Retool and quickly encountered an issue. I have a Retool database table called "Orders," and one of its columns is named "auxiliary_device," which acts as a foreign key to another table I have called "Auxiliary_Device." This "Auxiliary_Device" table has a column named "Device" that contains information about various devices.

What I'd like to do is create a simple application where I can choose multiple auxiliary devices and save them as a new entry in my "Orders" table.

The reason for this is because currently the Retool database doesn't support array type columns yet... assuming you are using Retool database