Building an order summary [Closed]

Rasheed - Feb 25, 2018 at 01:41 PM - Latest reply: Ambucias 53976 Posts Monday February 1, 2010Registration dateModeratorStatus August 16, 2018 Last seen
- Feb 25, 2018 at 04:50 PM
Hello,

So I have an order form with a list of SKUs. If you enter a quantity next to any SKU the form then the price and totals show up. If you don't choose any quantity for a given SKU then no price is calculated and nothing is added to the total.

So lets say there are 5 items on the form and 3 of them have been chosen.

SKU QTY PRICE EA. TOTAL
R43 3 $10 $30
R44
R76 7 $7 $49
S87
S38 2 $16 $32

I need to get the summary to only have 3 rows and drop the blank rows. And I don't mean to copy the rows, I mean to look at the table above and copy the content of a cell with a value and then move to the next cell with a value and copy that.

So it could look like

SKU
R43 3 $10 $30 in stock
R76 7 $7 $49 in stock
S38 2 $16 $32 no stock
Can this be done? I think this is like searching an array or something but I've no idea how to do it.

See more 

1 reply

Ambucias 53976 Posts Monday February 1, 2010Registration dateModeratorStatus August 16, 2018 Last seen - Feb 25, 2018 at 04:50 PM
0
Thank you
Greetings,

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator