Sometimes you may need to collect data from players. This could be their scores, game statistics, feedback, survey answers or anything else. There are many ways...
Hi dop2000, I've gotten this to work and it works well. However, how can I increase the amount of coloumns I'm submitting data to from C3? For example, date, location, name, DOB, etc.
I've tried to copy and paste the lines of code and republish as app from google spreadsheet but nothing works...
Yes, add new lines to the script, for example:
sheet.getRange(nextRow, 5).setValue(e.parameter["location"]);
Re-deploy the app. Make sure to send this new data in URL parameters.
Cheers dude. It was because I wasn't selecting 'new' when I deployed again. I brought you a couple of coffees.
Thanks, glad it worked!
Ok hola
Hi! I'm trying to add some columns too, but i need a little help here :P How can I send new data in URL parameters? I need to add something in .capx, right? I tried something like this:
1. I added new line in the script:
sheet.getRange(nextRow, 4).setValue(e.parameter["xxx"]);
2. I created new textbox on Layout 1 and named it Enterxxx
3. In Event sheet I added line (in second event, before Ajax action):
system -> set s to s & "xxx=" &Enterxxx.text
As result in google spreadsheet I get data from Enterxxx textbox in column B (Player Score). For example I put player score = 10 and Enterxxx is z, and I get: 10xxx=z in column B. I want z in column D . How should I do it correctly?
Hi,
I think you missed one "&" in front of "xxx"
Try this:
system -> set s to s & "&xxx=" &Enterxxx.text
Thanks, but it looks I missed something else... Now I get only score (10 in column B, column D is still empty)
EDIT!!!!
Wait, its working now! I think I published script without saving changes before :P I just saved changes and now everyting is ok :) Thanks again for this tutorial and quick answer!