Hi! Some time ago i found great tutorials about sending data to google spreadsheet (by dop2000 https://www.construct.net/en/tutorials/sending-data-construct-23-1447) and creating online database with google spreadsheet (by MarmisDev https://www.construct.net/en/tutorials/create-online-database-google-1373.
I thought I could combine both of them to create online leaderboard. Here is my .capx file:
https://drive.google.com/file/d/13bmqwIaEDE4UPWs-mPNPBY0KTb-WLL_1/view?usp=sharing
and here is my google sheet:
https://docs.google.com/spreadsheets/d/1qHm_tRXZ5pCDciBYT31dJVLODgITNwA5ewImsI4TgXk/edit?usp=sharing
(left part saves data from construct and right sorts them by column B, and then constuct loads top 10 results)
At first sight everything looks O.K. When I send new data for the first time, it automatically shows in leaderboard layout in my game preview. Unfortunately, this does not happen every time. Sometimes new data is saved in the google sheet, but leaderboard layout shows old scores. You can see it easily by sending new data twice, then going back to main menu and clicking leaderboard button again several times. It's quite annoying :(. If anyone has an idea how to prevent this, I would be very grateful.
P.S. I'm not sure but this problem could be simmilar to this topic:
https://www.construct.net/en/forum/construct-2/how-do-i-18/clear-ajax-lastdata-104963 Maybe there is a way to use simmilar trick with google spreadsheet url?