Forums

Email a table view

kkurtz 16 Dec, 2018
I am able to generate a short listing of several table rows. If printed, the list would be less that one page. Is there any way I can email that entire listing?

Karen
healyhatman 16 Dec, 2018
EASY. Just put {view:tablename} in your email body.
kkurtz 18 Dec, 2018
Not working quite like I want it to. If I just put in the {view:tablename} I get nothing but the table headings. So here is what I did:
On the table view page I have a toolbar button that calls the email event (email_pink_sheet}. The email_pink_sheet event has a call to the read table function, then {view:pink_sheet}, then {fn:email_pink_sheet}.

In the email I get the data, but it is not formatted like the table view. The table view has some special formatting for example {var:pink_sheet.row.Reps.Rep}, {var:pink_sheet.row.Reps.Division} {var:pink_sheet.row.Reps.Position}.</br> {var:pink_sheet.row.Reps.Phone}</br>{var:pink_sheet.row.Reps.Email}. In the email this comes out all in one line not in three lines as in the table view.

Please advise.
Karen
healyhatman 18 Dec, 2018
Well yes you need to read the data first, and then put the {view:} in the email body (NOT THE EVENT).
kkurtz 19 Dec, 2018
OK, I gave you incomplete information. My bad.

The {view} was and is in the email body. I have removed it from the event.

As I mentioned the formatting for one of the table cells is {var:pink_sheet.row.Reps.Rep}, {var:pink_sheet.row.Reps.Division}
{var:pink_sheet.row.Reps.Position}</br> {var:pink_sheet.row.Reps.Phone}</br>{var:pink_sheet.row.Reps.Email}. For the table view on the web page this puts the data in three lines because of the </br>. However when the email is generated the </br> is ignored.
GreyHead 20 Dec, 2018
Answer
Hi kkurtz ,

It might be a problem with the HTML; please try the correct version - <br /> instead of </br>

Bob
kkurtz 21 Dec, 2018
That worked. All this time I have been using </br> and it worked - until it didn't.
thanks.
This topic is locked and no more replies can be posted.