Based on response from user update correct row in google sheet

(David Grünbaum) #1

Hi,

Is there a way where I can, based on the users response, update the correct row.

For example:
Q1. Which of the following rows do you want to update? X, Y or Z?
R1. Y.
Q2. type the correct value
R2. 12345

Update row: Y with 12345.

Or do I have to make three different update rows with filters based on the outcome of Q1/R1 and Q2/R2?

(Daniel Beckett) #2

@david1

After you’ve asked the question you can do a search rows action and insert their answer as the search value. The search will return the row ID which you can then use in your update a row action.