What it does

A simple UI that is the hub for general business operations. Keeps track of orders and inventory.

How we built it

We are building everything so far in google spreadsheet using the Apps Scripts to create the UI in html and handling events in JS. We want to create a small webapp within the spreasheet, that gives the user a easier time inputting and keeping track of data.

Challenges we ran into

We at first were trying to figure out what we could do that was low cost, and soon realized that we could run it on a google spreadsheet. And using the Apps Script, we wouldn't need to host or deploy a huge server to run the webapp.

Now we are needing to keep developing the UI and event handlers, but after doing that we are looking at potentially adding a demand forecast or ingredient forecast. We might need some sample data from the owners (price, cost, outputs, orders, etc) in order to test the accuracy of the actual forecasting itself.

We also will try and search for any apis or libraries that'll cut down on having to create everything from scratch.

Share this project:

Updates