Hi,
I’m working on a daily habit tracker. The idea is that once a day I would fill a Google Form that has yes/no type of questions about daily habits. These habits are updated to a Google Sheets that has Mon-Sun as columns and the “habits” as rows.
First module is Google Forms - Watch Responses. Second module is Set Variable to format the date similarly to the Google Sheets columns - formatDate(now; “ddd”) This allows me to map the current day to the final module that updates the sheet.
My issue is that I don’t understand how I’m able to map the rows to dynamically update the correct row based on the question answer in the form. I’m currently ending the scenario with Update Row module and it only has “Row Number” as a way to define the row that needs to be edited. Should I use a different module for this?? I’ve tried using chatGPT to help me troubleshoot but it has only given me very complex options that I don’t think make sense.
Can someone help me out!