Hello everyone, I am in the progress of building a logistics booking system and wanted to get guidance on the best approach especially from a data management perspective.
I am using GoogleSheets as my database (initially), I have 12 columns (First name, last, mobile, delivery address etc) and expect there to be 250 bookings (rows) per day. This means 12 columns x 250 rows = 3000 cells. Now i know GoogleSheets has a limitation of 5,000,000 cells which means i would get 4.5 years roughly. I’ve also heard somewhere that AppSheet limits you to 100,000 rows from GoogleSheets?
My questions is around both capacity (database limitation) and speed (performance). I have looked into breaking it down into 3 different worksheets (one worksheet for each delivery site location) to utilise the data-partioning methods but then this brings issues when i need to build a dashboard and need all 3 locations consolidated.
Appreciate your help.