That's "formatted" email. You cannot natively send HTML (or styled text) from FM. You'll need a plug-in.
However, I have 'simulated columns' by calculated padding what I want to include in a column to make it wide enough so the email "appears" to be columnar.
If the receiving email doesn't display at mono-space fonts, it may not look columnar. So, you take your chances on that...
You'll need to either combine the account number and percentage (and format the percentage) in a calculation field in AV Projects, or use a custom function or script steps to loop through the data and "build" your columns.
Additionally, you really shouldn't be using repeating fields to store information like you are dong. Use a new table.
How about this,
Looping through the repeating fields until you reach the end or an empty field and
add the fields to a variable separated with a tab.
You can also do some formatting for the percentage that way.
hope that helps
AV Projects.fmp12.zip 66.5 K
good idea (looping gets the values), Ruben. However, the tab character may or may not be valid inside email. And certainly is not aligned columns.
Works in Apple Mail, and is the easiest way to get columns. btw it is possible to send html emails with multiple attachments straight from FileMaker without plugin's using Mandrill
yes and no.
If you have a widely variable first column:
burnt umber 456
submarine yellow 789
then a single "tab" probably will not be quite right. the first value needs 2-3 tabs to have the second column be "aligned" with the last value. That's why I said to "pad" the values. But even that is not correct unless the font is mono-spaced. HTML email and plug-ins are for better control.
The articles point to using an external email send and that's great. There are several, and may need additional 'formatting' to get the correct "columns".
We need HTML email in FM!!
The problem is i have had zero luck getting it to translate here.
It doesn't appear to be pulling from the Account dbase but rather from records i made entries in before.
This is what i did for the drop down.
Any ideas what I am doing wrong?
should have added that i wanted to make the list of account numbers show up as a drop down list (its whats shown in the pict). this way would also solve my formatting issue
Account number(s) to invoice against:
A- jim account 3 Percentage: .1
B- jim account 2 Percentage: .25
C- jim account 1 Percentage: .65
D- jim account 4 Percentage:
E- jim account 5 Percentage:
found the issue and I its working the way it was supposed to now. Even have the email squared away. i have one other question which i want to post as a seperate entery.
Thanks all for your help