Hi all! Please help, I stuck on this:
I have orders, which contains order number, client, shipping address
AND
items in order, which can be multiple, and quantity and price for each item.
How to realize it best way, without manually filling out client and shipping address several times for each order?
Thank you!
Hi @Roman_Sharapov,
Here is one way to do this - https://cl.ly/b8270bfaa979/Screen%20Recording%202018-09-04%20at%2012.05%20PM.gif
This is the doc in case you want to make a copy and play around with it - https://drive.google.com/open?id=12s5_eu9Z1_GiwbsTN1WmsuDyn6OgfvQ4
Hi Mallika! Thanks for answer!
The problem is that I cannot note the amount of item in case of multiple items in the order table. Furthermore, there will be other atributes of the items that is variable in each order. Please see screenshot.
img-2018-09-05-12-14-12|690x447
Thank you very much!!
Would adding a separate row for each item ( so you can manage amount and attribute work?
You could group by order number or create a canvas formula to get order details as needed.
