Developing a production calculator

#1

Hey Coda community!

I am working on creating a production calculator for my business.

Theoretically I have three tables: Weekly orders (where I input customer orders), Roast Calculator (where those orders are bundled into basically bulk production), and a Bag Counter (where customer orders of are translated into units)

I successfully got the Weekly Orders to communicate with the Roast Calc utilizing “switchif” but I am struggling to get the orders to accumulate in the Bag Counter.

#2

@Mike_W_Archibald
Please include a screenshot of the Bag Counter table and explain which values are to be accumulated to which location, and I’ll see if I can help.

#3

So there is a rotating menu of coffees that folks order, these coffees come in three different sizes 5#, odd#, and retail bags.

Sorry for not posting this photo earlier, because it was my first post it was restricted to just one photo.

1 Like
#4

@Mike_W_Archibald

This is likely more than you wanted, but below is how I would attack it.

Any business decisions reflected in the screenshots are just dummy placeholders. The main point was to illustrate building from your smallest and simplest tables up to your more complex ones.

In the future, when you’re ready to stop manually processing orders through this setup, you can probably use Coda’s automation features to handle the transactional aspects of this schema.

(images opened in new browser tabs are easier to read)

:coffee::coffee::coffee: :crazy_face:

1/4

2/4

3/4

4/4

3 Likes
#5

Thank you for your help @Ander !!! I’m struggling with the concatenate formula on the “products” table (i’m very new to coda) is there something I might be missing or not understanding about how concatenate works?

#6

@Mike_W_Archibald
Screenshot of your formula?

#7

I got it to work! Thank you so much for your help! I don’t know if there is a direct message part of this community but I’d love to mail you a bag of coffee for your help!

2 Likes