I have searched through a lot of posts but couldn’t find, or didn’t know if I’d found something that would help me.
I have my app connected to google sheets which is working, however it is slow when creating and displaying a list once an object has been selected. The app deletes rows in a specific sheet, then reads data from elsewhere and updates that sheet.
I would create local data sources but that would be time consuming as i would have to rename each column header, I would also have to push out an app update each time the local data changed.
How can I best sync the data from the google sheet and create local data in the app please? I feel like it would be better for my app to have the data stored locally, but open to cloud options if i can get the sync speed faster.
I want to try and keep the amount of screens i use to a minimum also.
https://x.thunkable.com/copy/eaee5feaaf987d7a057604984a6b26f2