$\color{#4fb0ae}\Huge\textsf{Part Orders}$
$\color{#4fb0ae}\Huge\textsf{Parts \& Inventory}$
//^^^^^Parts DB formulas^^^^^
//logic & messaging around ordering more stock
if(prop("001 Bolts from Purchase Orders") < prop("001 From Stock"), "001 - Out of Stock, Purchase More.", "")
if(prop("002 Bolts from Purchase Orders") < prop("002 From Stock"), "002 - Out of Stock, Purchase More.", "")
if(prop("003 Bolts from Purchase Orders") < prop("003 From Stock"), "003 - Out of Stock, Purchase More.", "")
if(prop("004 Screws from Purchase Orders") < prop("004 From Stock"), "004 - Out of Stock, Purchase More.", "")
if(prop("005 Screws from Purchase Orders") < prop("005 From Stock"), "005 - Out of Stock, Purchase More.", "")
if(prop("006 Screws from Purchase Orders") < prop("006 From Stock"), "006 - Out of Stock, Purchase More.", "")
//combine
concat(if(prop("001 Bolts from Purchase Orders") < prop("001 From Stock"), "001 - Out of Stock, Purchase More.", "") + if(prop("002 Bolts from Purchase Orders") < prop("002 From Stock"), "002 - Out of Stock, Purchase More.", "") + if(prop("003 Bolts from Purchase Orders") < prop("003 From Stock"), "003 - Out of Stock, Purchase More.", "") + if(prop("004 Screws from Purchase Orders") < prop("004 From Stock"), "004 - Out of Stock, Purchase More.", "") + if(prop("005 Screws from Purchase Orders") < prop("005 From Stock"), "005 - Out of Stock, Purchase More.", "") + if(prop("006 Screws from Purchase Orders") < prop("006 From Stock"), "006 - Out of Stock, Purchase More.", ""))
//in stock calc
if(prop("Part Number") == "001", prop("001 Bolts from Purchase Orders") - prop("001 From Stock"), toNumber(""))
if(prop("Part Number") == "002", prop("002 Bolts from Purchase Orders") - prop("002 From Stock"), toNumber(""))
if(prop("Part Number") == "003", prop("003 Bolts from Purchase Orders") - prop("003 From Stock"), toNumber(""))
if(prop("Part Number") == "004", prop("004 Screws from Purchase Orders") - prop("004 From Stock"), toNumber(""))
if(prop("Part Number") == "005", prop("005 Screws from Purchase Orders") - prop("005 From Stock"), toNumber(""))
if(prop("Part Number") == "006", prop("006 Screws from Purchase Orders") - prop("006 From Stock"), toNumber(""))
//one formula to display inventory as single property
concat(format(prop("001 In Stock")) + format(prop("002 In Stock")) + format(prop("003 In Stock")) + format(prop("004 In Stock")) + format(prop("005 In Stock")) + format(prop("006 In Stock")))
$\color{#4fb0ae}\Huge\textsf{Products}$
$\color{#4fb0ae}\Huge\textsf{Product (Customer) Orders}$
//^^^^^Product (Customer) ORders DB formulas^^^^^
//add P1 and P2 parts required
////001 Product Order Parts Committed
((toNumber(prop("P1 001 Single")) * toNumber(prop("# of P1"))) + (toNumber(prop("P2 001 Single")) * toNumber(prop("# of P2"))))
////002 Total Committed
((toNumber(prop("P1 002 Single")) * toNumber(prop("# of P1"))) + (toNumber(prop("P2 002 Single")) * toNumber(prop("# of P2"))))
////003 Total Committed
((toNumber(prop("P1 003 Single")) * toNumber(prop("# of P1"))) + (toNumber(prop("P2 003 Single")) * toNumber(prop("# of P2"))))
////004 Total Committed
((toNumber(prop("P1 004 Single")) * toNumber(prop("# of P1"))) + (toNumber(prop("P2 004 Single")) * toNumber(prop("# of P2"))))
////005 Total Committed
((toNumber(prop("P1 005 Single")) * toNumber(prop("# of P1"))) + (toNumber(prop("P2 005 Single")) * toNumber(prop("# of P2"))))
////006 Total Committed
((toNumber(prop("P1 006 Single")) * toNumber(prop("# of P1"))) + (toNumber(prop("P2 006 Single")) * toNumber(prop("# of P2"))))
//calc total parts committed by product package
////001 Total Committed
toNumber(prop("Committed Orders")) * prop("001 Bolts Required") * prop("# in Product Package")
////002 Total Committed
toNumber(prop("Committed Orders")) * prop("002 Bolts Required") * prop("# in Product Package")
////003 Total Committed
toNumber(prop("Committed Orders")) * prop("003 Bolts Required") * prop("# in Product Package")
////004 Total Committed
toNumber(prop("Committed Orders")) * prop("004 Screws Required") * prop("# in Product Package")
////005 Total Committed
toNumber(prop("Committed Orders")) * prop("005 Screws Required") * prop("# in Product Package")
////006 Total Committed
toNumber(prop("Committed Orders")) * prop("006 Screws Required") * prop("# in Product Package")