Need help creating and updating data

Hello,

I am very new to Thunkable and might be overreaching in my excitement to try Thunkable. I started with what I thought was a decently simple project but it has since gotten complicated.

I am trying to create a simple food feedback survey app.

It consists of 10 questions where users will simply choose from the three “:face_savoring_food::neutral_face::face_vomiting:” to express their feelings on a certain food.

The responses get saved to a google sheet, the format of this sheet is each food item is a column so each user response is a row. When the user is finished, the app returns to the main screen and creates a new row for the next user’s responses.

I am not sure if this is the best way to format my data, it made sense in my head at the time of making it.

I have successfully linked my google sheet, when I type data on google sheets and update my sync in Thunkable, I can see the changes I have made. When buttons are pressed though, none of their values are being updated and uploaded to the google sheet.

Here is the logic of a single button, all buttons follow this logic and values just change depending on the type of button:

Here is a small snippet of the function “handleRating” it repeats itself through each food category:

If you would like a closer look here is the project details: Bomber Food Project

Any suggestions are welcome and feel free to ask questions, I tried to explain it as best I could. Thanks!

TLDR: I am using button clicks to upload data to a google sheet-- the data is not being uploaded, how can I fix this?

Where have you defined currentRowId? I was expecting it to be a app variable, which would get updated like
currentRowID = currentRowID + 1
It appears in the “update value” block you have just typed currentRowId …

Hi! I do initialize a variable-- I wrote it in the first screen where it has a button which starts the survey. Here is the blocks for that one:

I have no idea if I am initializing anything correctly here. My thought process was initialize the currentRowId when the screen is open.

When the Start Survey button is clicked, check that you are in an empty row (Just in case something goes wrong and you are in a row with existing data) make sure everything is null for the new row, to get ready to receive responses.

Should I be initializing all this within the screen where I have my actual survey questions instead?