Non GUI bulk insert Hello fellow retoolers. Please consider the following scenario: I have three tables in my PostgreSQL DB - 1. Lines, 2. Clients, 3. Subscriptions. Each subscription is made of a relation between a line and a client. When adding lines into the database there's also an option t…

Bit of an old thread, but you can bulk insert with SQL mode queries in order to return the created IDs back to the app if the resource doesn't have the prepared statement setting enabled. You essentially need to craft the values part of the SQL query with JS (specifics will depend on your array and…

Bulk insert SQL mode. Is it possible?

💬 Queries and Resources

ScottR May 2, 2022, 2:22pm 2

You would need to run a trigger in the DB itself AFTER the insert happens.....to get that ID

Allow GUI mode when using dynamic resource ID

Topic		Replies	Views
Bulk insert - troubleshooting 💬 Queries and Resources	8	1577	October 23, 2023
Bulk insert records - Pure SQL statement to get IDs of generated records 💬 Queries and Resources workflows	4	730	June 17, 2024
Adding multiple rows into a database via a table 💬 Self Hosted Retool	2	1284	June 28, 2024
Bulk insert to Postgresql with multiple tables 💬 Queries and Resources	8	4523	September 11, 2023
Need Help with Bulk Insert Using JavaScript in SQL Mode 💬 Queries and Resources javascript , sql	4	2059	April 4, 2024

Bulk insert SQL mode. Is it possible?

Related topics