How to update data from a dropdown to Big Query

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 = {{}} ,Code = {{}}
WHERE Id = {{}}


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

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.