Adding several rows to posgres retool db

Ana · July 3, 2023, 2:19pm

Hi there!
another question :)
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.

here is my table

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

Ana · July 3, 2023, 2:22pm

I have the error, it says the values are null

ScottR · July 3, 2023, 2:22pm

Try this doc

Ana · July 6, 2023, 7:35pm

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

Tess · July 7, 2023, 6:36pm

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.

Ana · July 9, 2023, 1:50pm

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

Tess · July 11, 2023, 8:13pm

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!