Adding several rows to posgres retool db

Queries and Resources
1

Hi there!
another question :):slight_smile:
I have an array that comes from a form component (with listView with radioSelects) which I want to submit to a table in retool database. This should create several rows.

Screenshot 2023-07-03 at 16.16.31
Screenshot 2023-07-03 at 16.16.31836×878 51.3 KB

here is my table

Screenshot 2023-07-03 at 16.16.43
Screenshot 2023-07-03 at 16.16.431280×458 27 KB

how to correctly transfer the 'grade' and 'skill' value to the table, to correct columns?

2

I have the error, it says the values are null

Screenshot 2023-07-03 at 16.21.31
Screenshot 2023-07-03 at 16.21.312034×934 112 KB

3

Try this doc

4

thank you! I've made it :slight_smile:
I want to also pass a variable via additional scope, and it doesnt read it :frowning:
but other JS query reads it perfectly..

Screenshot 2023-07-06 at 21.34.22
Screenshot 2023-07-06 at 21.34.221286×554 43.6 KB

5

Hi @Ana,

Can you try removing the {{}} around currrentFId? Since you already have {{}} on lines 1 and 7, you shouldn't need to add them again.

6

hi Tess, wich bulk insert it didnt work either way unfortunetly:(

7

Hi @Ana,

Can you please let us know the current error message & send us a screenshot of the debug tool showing what values are being passed from the JS query (as described here)?

I'm also linking our additionalScope post in case it's helpful

Thanks!