How do I have players submit inputtext which goes to a Google Sheet?

Post reply

❤Follow Topic(3)

0 favourites

4 posts

From the Asset Store

Numbers and Letters and Everything That Goes With Them

$9.99 USD

The ultimate voice pack filled with 1,536 files of .......wav and mp3 of individual numbers, letters, and words (that go

B. Squid

- ynuredin
- - Joined 19 Dec, 2019
  - 26 topics • 57 posts
- 2
- 4 Jul, 2020
- Quote
Hi, I tried following dop2000's tutorial, but I'm not sure where I'm going wrong. I'm creating short educational games for students and need them to submit their names at the end so that they can get credit for completion. I tried to send the information to a Google Sheet, but got an error code after running the function. Perhaps it's Google's new Apps script? Anyway, here's the portion of my project that attempt's to replicate Dop2000's tutorialhttps://drive.google.com/file/d/1i3MJbrqAY-bd6TDz-gqeXPCRSi5u-5Ex/view?usp=sharing, and the Google sheet:

Any help is greatly appreciated!
Try Construct 3

Develop games in your browser. Powerful, performant & highly capable.
Try Now Construct 3 users don't see these ads
- dop2000
- - Joined 26 May, 2016
  - 139 topics • 12,544 posts
- 2
- 4 Jul, 2020
- Quote
Move "Button on clicked" condition to event 2. Otherwise this event is running on every tick, sending data to the spreadsheet 60 times per second.

.

I don't know why there is an error, try to re-create the script again, following each step from the tutorial closely. It's important to publish the script when you make any changes in it, and select "version=New" every time you do it.
- ynuredin
- - Joined 19 Dec, 2019
  - 26 topics • 57 posts
- 2
- 5 Jul, 2020
- Quote
That worked! I can't thank you enough!!!
- dop2000
- - Joined 26 May, 2016
  - 139 topics • 12,544 posts
- 2
- 5 Jul, 2020
- Quote
Thanks for the coffee! :)