Hello. I've been developing an order processing Zoho application for one of my clients. I would like some ideas / suggestions / assistance on helping put together a "Receipt" e-mail that creates a dynamic table or as a minimum the right amount of items on the e-mail message of the Receipt.
I have multiple items and need to put them on a dynamic table (so it grows with the size of the pulled data) where for example:
Table:
<PNfield 1 rec.n+0> <Descfiled2 rec.n+0> <QTYfield rec.n+0> etc.
<PNfiled 1 rec.n+1> <Descfield2 rec.n+1> etc.
<PNfield 1 rec.n+2> <Descfield2 rec.n+2) etc.
How do I get each item to be put in the right "cell" of the dynamic table? I get all items in commas like:
PNfield1 rec.n+0, PNfield1 rec.n+1, PNfield1 rec.n+2, etc.
Descfield 2 rec.n+0, Descfield2 rec.n+1, Descfield 2 rec.n+2 etc.
On one of my attempts, I did a loop that ended up sending 1 e-mail per ordered item - which I don't want - I want to consolidate all ordered item information on 1 e-mail message.
I am getting the correct data but it doesn't look good in a comma separated format. I'd like to be able to put it into a dynamic table or some better structure so that it adjusts its size according to the amount of items ordered.
Thanks.