Gmail Pack Questions

#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

Any help would be appreciated.

0 Likes

#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

0 Likes

#3

Brilliant! That was it! Thank you.

0 Likes