What's the best way to go about this?

[NCD]

Hi I want to make an Inventory app.

Want to make a Column for Unit Price, but for various reasons the "unit" comes and different forms.

like;

$10 for "one role" 

$10 for "Three meters"

$10 for "two gallons"

... and so on!

What would be the best way to go about this on Google Sheets, and then on AppSheet?

[TeeSee1 · Accepted solution]

This is not a direct answer to your question.

But typically you would create a UOM (Unit of Measure) column to indicate how the smallest unit of each product is managed.

AppSheet is ,at the risk of sounding too simplistic, a UI + data processor over DBMS (be it a google sheet or smart sheet), so just go about it in the same way as you would create an app based on let's say SQLServer, MYSQL, etc.

This help article would be a good start in designing your app.

[NCD]

@TeeSee1 

Thank you sir.

Then maybe it's a good I should have a column like this?

• Unit Price

• Unit

• Unit of Measure

[TeeSee1]

Really depends on what you want to do.

What goes into Unit?

[NCD]

@TeeSee1 

Unit Price = $10 (price of the minimum value)

Unit = 1 (or any required minimum value in order to purchase from supplier)

Unit of Measure = Role, cm, ft, gallon, 

[TeeSee1]

Sure,

Unit is minimum order quantity. I do not see why not.

You can use it to limit the order qty of your order data (Valid-If expression)

[NCD]

@TeeSee1 

Thank you very much!