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!
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?
wow, nice idea and beautiful graphic. I should play more.
Member since 14 Dec, 2014