How to update data from a dropdown to Big Query

Queries and Resources
, ,
1

I have a table that has a drop down menu. I want to select a new string in the dropdown and then have it update in my database. This is what I have so far:

UPDATE officeNames
SET Brand = {{table1.selectedRow.data.Brand}} ,Code = {{table1.selectedRow.data.Code}}
WHERE Id = {{table1.selectedRow.data.Id}}

2

@djbeto2209

Hey there :wave: Would you mind sharing a screenshot of the drop down menu in your table?

3

Sorry for the late response. I was able to resolve the issue.

The solution was a permissions issue with BigQuery. I had to update my permissions so Retool could see the tables. Once that change was made, I was able to do a bulk update.