Sending data from Construct 2/3 to Google Spreadsheet

You're viewing a single comment in a conversation. View all the comments
  • 3 Comments

  • Order by
    • [-] [+]
    • 1
    • Mpr's avatar
    • Mpr
    • 1 points
    • (2 children)

    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

        • [-] [+]
        • 1
        • Mpr's avatar
        • Mpr
        • 1 points
        • *
        • (0 children)

        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!