After submitting a form I want to change a cell in another sheet?

I have a form created to create a new row when submit is clicked. I would also like to find a way to make an edit to an existing row in another sheet. Is this possible with Glide?

It’s possible, but might get a bit tricky.

What is your criteria for determining which row in the second table needs to be updated?

Is it based on pre-existing data, or new data that is submitted via the form?

Its a system to track people on a bus. So it will be a boolean or a toggle between “on the bus” and “NOT on the bus”. We just want to be able to see the current status of each person.

So it would be pre-existing data we want to be able to change on a separate page.

Sorry, I’m a bit confused. And I don’t think you answered my question.

How would you know which row in the second table needs to be updated?

1 Like