Gmail Pack Questions

Making Packs
1

Hi,

I was playing with the Gmail pack this morning and I’m not sure if this is a bug or my not understanding the workings of it.

I’d like to send an email with information from a table. In the content field, I entered “=QBO”. This resulted in an email with the body “[unknown object], [unknown object], [unknown object], [unknown object]”

I changed the content field to -
="<table><tr><th>Customer</th><th>Invoice</th><th>Date</th></tr>"+QBO.FormulaMap(Format("<tr><td>{1}</td><td>{2}</td><td>{3}</td></tr>", Customer, InvoiceNumber,InvoiceDate)).ToText()+"</table>"

But then I saw commas between rows as below

MD_Test_Lab-gmail
MD_Test_Lab-gmail.png1146×832 94.4 KB

Any help would be appreciated.

1 Like
2

Hi Michele,

The issue here is your FormulaMap is resulting in a list of strings which automagically get concatenated together with commas when you call ToText(). The fix in this case is to join them together with an empty string by using Join("").

Cheers,
Chris

1 Like
3

Brilliant! That was it! Thank you.