What are you trying to achieve?
I am trying to build a process that will check for new responses from users of our Academy project in a Google Form and if they filled out an answer (sent a file), A Search Row module will look for a user’s row in Google Sheet by looking for respondent’s address. Then by using Update Row module it should check in each column if the corresponding answer from the Form was filled OR NOT and if yes, then put a checkmark (a simple “X”) to it, if not, do nothing.
The problem is, that now after testing for a while what happens is that when I fill out only one answer and not any other, the Update Row will still update all columns for all answers as if I did answer them all. I thought that maybe the problem is that Google Form returns answers even from previously filled out instances of the form, but I deleted previous responses and it still checkmarks all answers even when it should leave them empty.
Steps taken so far
I’ve deleted older google form responses to not confuse the system. I made sure that the middle Search Row module locates exactly one email/row and then Update Row functions compare data in each column to check if the answer is filled or not. If not, it should CLEARLY do nothing.
