Hi guys so I’ve made an invoice app that works pretty well. the sales person fills in the fields item 1 artichokes item 2 broad beans etc. PIC A
once everything is captured the client gets an email and all is well.
now every month I would like to use a graph in googlesheets off the source data to show for example all products being sold.
now because all the products are in different columns eg item 1 and item 2 it’s difficult to create the chart. google sheets would prefer it if the data was in the format below.
just want to know if anyone else ran into a problem like this?
Ultimately I would like to report on all the produce sold, but the structure of the data currently does not allow me.
I could not find a good sample app that would give me the app in the format I wanted because most invoice apps only catered for one line item.
thanks for the read guys and any thought would be appreciated.