I need solution for existing production sheet.
My customer is filling order in spreadsheet (google docs - grey columns). Then i have to prepare product, calculate price and fill same data in other software to make an invoice. It's time consuming.
I would need solution to calculate price automatically (Column K) according to specific material (fabric) and m2 used. If product is laminated then there is extra cost 1m2 = 10 .
There are 2 kinds products that i produce. They are in Materials tab.
IT would be perfect if i could automatically prepare invoice for all products that have status READY.
Invoice numer should be incremented every time we generate that doc.
Every product should have product ID, material, size and price.
I don't know the best solution for me.
Can we do that is gdocs or we import data from gdocs to excel or make php + mysql scripts.
I prefer simplicity. Please let me know how we can do this.