This doc is like a CRM and its made for me and my girlfriend to easily be able to track the products and projects that we are working on. When working on a lot of different things it can be hard to keep track of all of the projects that are all happening at once.
Why the schema?
This doc implements the following schema:
“One Big Table” which is the In The Works table and it contains most of the data.
2. “Extraction” which is what is happening when the Google Bot extracts data from the the Coda doc and then it stores it on Google Sheets.
How does it solve the problem?
This doc solves the problem by organizing all of the products and projects into statuses that are visually colored and organized. It makes it to see how far along the process of work they are.
Overview of the Database Layer
The Database Layer is rather simple, the main table is the In the Works Table it contains all of the projects. It has a lookup column to the Status table so that the Statuses can easily be changed. The Current Products for Sale table uses a lookup to the In the Works Table for the Names of the products.
Overview of the Interaction Layer
The User interacts with this doc is super simple and minimal. To add a product, you can do so on the Products in the making page and click the button. It’s easy to click the cards and edit the data and status. The same is with Current Products. To use the Google Bot there are two clear buttons. One runs the bot and the other is a link to the Google Sheet page.