You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a Google Sheet with just a few columns. The primary column is "Vehicle Number". Then there are columns for "Status", "Driver", and "Time" (this is an employee vehicle check out/in system). The Google Sheet has a list of all our vehicles and their status (checked in or out). When a button is pressed on one of my screens, I want it to update the row on the Google Sheet based on the value of "Vehicle Number" that I'll have previously stored via an "Update State" binding from a previous screen. The idea is that when the "confirm" button is pressed after a driver selects their vehicle and chooses if it's a check in or check out, the Google Sheet will reflect whether the vehicle is "in" or "out". I'll already have state bindings for both the vehicle number and status. I just can't figure out how to properly format the "save row" action to update the correct row on the sheet. I can hard-code the row number and get it to update that way, but I need to have it find the correct row based on the vehicle number that's been selected. Any help with this is appreciated. Thanks!
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have a Google Sheet with just a few columns. The primary column is "Vehicle Number". Then there are columns for "Status", "Driver", and "Time" (this is an employee vehicle check out/in system). The Google Sheet has a list of all our vehicles and their status (checked in or out). When a button is pressed on one of my screens, I want it to update the row on the Google Sheet based on the value of "Vehicle Number" that I'll have previously stored via an "Update State" binding from a previous screen. The idea is that when the "confirm" button is pressed after a driver selects their vehicle and chooses if it's a check in or check out, the Google Sheet will reflect whether the vehicle is "in" or "out". I'll already have state bindings for both the vehicle number and status. I just can't figure out how to properly format the "save row" action to update the correct row on the sheet. I can hard-code the row number and get it to update that way, but I need to have it find the correct row based on the vehicle number that's been selected. Any help with this is appreciated. Thanks!
Beta Was this translation helpful? Give feedback.
All reactions