Hello! Firstly, I'm a materials engineer, not a programmer, but I'm learning my way through Retool so that I can build some apps for data collection in the lab. One such app is so techs can fill out a form and copy mass spectroscopy data into a cell, then submit this data to a database; right now I'm just trying to submit data to a table that acts as the database, until I transfer it to our intranet.
I've created this transformer to import the MS data:
And I've set up the form this way:
The two queries I've created to add and update the row look like this:
but have been getting this set of error codes:
and while it will add a row, it won't import the MS data, but I'm not getting an error regarding the transformer, primarily the 'addRow' query, having to do with assignment, but there is assignment!!
Any advice would be appreciate.