- simplytastefulAsked on December 23, 2017 at 08:56 AM
Good morning! I'm trying to get my hand on item order tracking by date. I can export each day's order to excel/csv/google docs but all items ordered are placed into the same cell. Is there any way to get them to appear in separate cells to help me track the orders better?
What I do now is view the form submission in the phone app and then edit my own spreadsheet based on the order. If I could figure out a way to simplify that process it would help. We have only one client that uses our form (on purpose) and then I charge them at the end of the week for their orders, not daily. (We're a bakery.)
- JotForm SupportArdian_LAnswered on December 23, 2017 at 10:04 AM
As I can see you have already integrated the form with Google Spreadsheets. Every submission it is separated with date so you can sort the orders with date. But, unfortunately you can not separate the products in different cells as that is automatically generated by Purchase Order element. I tried to create a workaround but without luck.
Please let us know if you have any other question.