I'm new to Ajax and its functions (and still kinda new to CS in general...). I followed a tutorial and made an app to store data in a Google Sheet (like a live scoreboard). Everything is peachy and goes to the designated cell. What I can't find is anything telling me how to pull that data from the Sheet back into Construct.
I tried a tutorial that required that the Sheet be turned into a CSV file - but then I can't read/write to it at the same time (that I know of). My best guess is to have Ajax request the sheet and then somehow specify what data to pull using ajax.lastdata but I get lost there. Is there a way to specify individual cells?
*update - after some digging I’m starting to see that CS can talk to Sheets, but reversing that requires changing the format of the Sheet - which can’t be done in real-time? Again, I don’t know squat about this so if anyone can at least confirm whether I’m right or wrong that would save me some headache.