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 “
” 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?
So what I did was initialized the currentRowId as text string. The reason is the green block row id will be something like id1234abcd or id4254fhre in other words alwaus id. It is not an object for sure. So that I have corrected.
You had given the green block user id_vlaue = row id. That is not right, I assigned it to some random number 1234 and subsequently it will be id_vlaue+ 1
Lastly in the happy not happy screen I have used the saved currentRowId for the row id
I am no expert, has some spare time so trying to help. I will be busy tomorrow …Hopefully this will work.
1 Like
Thanks for your advice and help!
I had no idea row id worked that way, and initializing strings instead of objects made so much more sense.
I still didn’t quite get it to work with my original way of thinking but the changes you provided got me on track to a different process and I managed to get it working! 
Thanks a bunch! 
1 Like
