I am confused what is the best approach for self project and project made for clients using data.
For self project having google sheets makes sense but for clients ( clients may not want me to access their user data , due to privacy issues ).
I though to ask clients to have their own google drive and app will connect to it. but my thunkable account will have access to only mine google sheet/drive.
If i create new thunkable account for client how can i copy my project to client account, if i wish to use some screens ??
If i switch to Airtable, it has limitations of 1200, to 5000 rows only.
Thanks Muneer, but then i cannot copy my existing screen if i want to used them. I have re-develop them, isn’t it.
I thought about Firebase, but then JSON, i have to migrate my entire code which is in Google Sheets to Firebase, which is a little tricky , when we have nested arrays.
I have realized, when data is been created in app itself it is better to store that table in Firebase ( Example, Users, Profile, Payments) , this way when your app has been built for other clients you don’t have to manually create these base tables. However, if you app takes inputs from table, which you need to dynamically change, example : Products, Price list, it it would be better to keep in Google Sheets or Airtable, because we can ask clients to update price list, products.
There is no way these clients would be able to work on JSON table to update tables.
Hybrid is good approach in my opinion.