With Cloudstitch, anyone can use a Google spreadsheet (or a Microsoft 360 spreadsheet) to store data, powering interesting features like dynamically changing listpickers to easy to understand mapping databases. (Cloudstitch requires you to manually sync your spreadsheet to your app unless you upgrade services).
Ted from Cloudstitch here. Just wanted to say hello and thanks to the Thunkable team for adding this support! We love what you all are doing and are excited to help you build some awesome apps powered by spreadsheets.
Don’t hesitate to ping us for support on this message board or by email at hello@cloudstitch.com.
Looking forward to trying out this feature. I also really like that clicking the link clones the project and opens it directly in my Thunkable. Excellent UX, thanks @albert
You can! We try to leverage the spreadsheet whenever possible, so the way to do it is with a spreadsheet trick. I’ve shared a spreadsheet here with an example.
Assume you’ve got the raw data in a worksheet called RawData. Just create a second worksheet called Sorted that will always project a sorted version of the raw data.
In cell A1 of that new sheet, use the formula =ArrayFormula(RawData!A1:Z1) to copy the header row.
In cell A2 of that new sheet, use the formula =SORT(RawData!A2:Z, 1, true) to copy (and sort) everything else.
You could use a similar trick to create a third worksheet that only grabs the top 250 of your leader board by placing the formula =ArrayFormula(Sorted!A1:Z251) in cell A1. With this approach you’d have three worksheets: the raw data, the sorted data, and the top leaders.
Remember you’ll have to sync your spreadsheet in Cloudstitch to publish it to the API (or set it to auto-sync). And note that some of the references in the arguments above depend on the particulars of your spreadsheet.
Then just use the sorted data inside Thunkable. You can grab the data from only one worksheet by appending /WorksheetName to the URL see for the API Endpoint in the Thunkable editor
where i can found information about Microsoft 360 spreadsheet ? I just can work with Google drive.
working with Google; i just can upload data to Sheet1; i tryed changing name Sheet in Thunkable Project, but not work, continue uploading data to Sheet1.