Query error when updating gsheet

App Building
1

I'm getting the following error when using an action button to update a value in a table loaded from gsheet:

Query Error (query3): argPreprocessFn[operation] is not a function

I'm using a filter in the query that updates the gsheet (pictured below). It was working with names (text) but switching to Number broke it. Could there be a disparity in the data types (meaning Retool is using a string value instead of number to compare)?

Untitled 5
Untitled 5894×165 10.8 KB

2

Hey @carlos-a!

Hmmm, you can see the value that we’ll pass by clicking into the value field — it’ll pop up a green bar below to display the actual value that we’ll pass. Are you seeing a standard int or a string ("")? Also, can you provide a screenshot of the table2.selectRow.data object from the left-pane?