I have created a CRM Application which has been in use for the past year. It has 30 or so tables so I use Google Sheets. However, it eventually went over the 10 Million cell limit in a single spreadsheet. To combat this, I split the most data intensive tables into Different Spreadsheets to solve this in the short run while I look at other databases for a long term solution.
However, I used to use Copies of apps as regular backups as well as primarily to allow multiple R&D works to be done simultaneously by different persons. After making this change, now when I make a copy of the app enabling “Make a copy of the data for the new app”, it ignores this input regardless of Save app to setting, and always creates a new app with the same database.
I need this feature to allow multiple users working simultaneously as well as to make fresh copies of the apps for other teams in my company. Matter of fact, for these copies, I would not mind empty data as well, only primary concern is Data structure is retained in database (Headers) and App Copy.
Thanks in Advance