In a mailto-script I encountered a funny problem with entries in a field. For some reason the mail was not generated properly, when there was a "&" in the company name. Is there a workaround for this? PER_COM::Name is a simple text field.
. . .
When ( PER::CompanyID = "" ; "" ; "Company: " & PER_COM::Name & "¶") &
. . .
See if this article gives you clues:
Beverly
Sent from miPhone
Sorry, missed the FileMaker function link:
Sent from miPhone
Beverly - thanks a lot for your quick reply! I tried it with
When ( PER::CompanyID = "" ; "" ; "Company: " & GetAsURLEncoded(PER_COM::Name) & "¶") &
but that scrambled the text with lots of %20. Does that mean, that I have to rewrite the whole script? So far I used
"open url" with "mailto:" & ...
but may be that's a wrong approach ?
When you use mailto: a proper email address is expected. In proper email addresses the character "&" never occurs.
So you cannot construct mail addresses from company names. Store the genuine mail address in his own field.
Sorry - my fault - did not explain it properly. I am trying to get a mailto script with subject and body. The company name is not used as recipient, but as a part of the body. That's the reason for "& Co" in the code :-/
hbrendel wrote:
In proper email addresses the character "&" never occurs.
I don't think that's true:
You should encode each value at once, like
"mailto:" & address &
"?subject=" &
GetAsURLEncoded ( subject calculation ) &
"&body=" &
GetAsURLEncoded ( body calculation )
This mean you should encode ¶ also, total URL should be one line.
I forgot to encode mail address, of couse it should be also encoded if it contain "&" or such "shuld be encoded character"...
... to encode the whole body makes sense, but now it scrambles the whole body with %20 ... ? I'm pretty lost ;-)
( Filemaker 17 on mac OS 10.13.6 using Apple Mail )
Space is encoded to %20, it is no problem. If you don't succeed, there is another reason.
Jepp, must be an other reason then. The whole body is proplery encoded (works fine so far), but when Apple Mail opens, it displays the whole encoded text like it is not computed.
Can you post your full calculation on this? Do you have a small sample you can post (screen shots) of what is happening?
Thank you!
Beverly
Here were go :-) German though, but might be easy to understand ...
"mailto:" & LiesAlsURLVerschlüsselt (PER::eMailBuero) & "?body=" & LiesAlsURLVerschlüsselt (
Falls (
PER::AnredeID = 10062 ; "Sehr geehrter Herr " & PER::Nachname & ", " ;
PER::AnredeID = 10063 ; "Sehr geehrte Frau " & PER::Nachname & ", " ;
PER::AnredeID = 10064 ; "Hallo " & PER::Vorname & ", " ) ¶ &
Wenn ( PER::Vorname = "" ; "" ; "Vorname: " & PER::Vorname & ¶) &
Wenn ( PER::Nachname = "" ; "" ; "Nachname: " & PER::Nachname & ¶) &
Wenn ( PER::TitelID = "" ; "" ; "Titel: " & PER_WERTE#Titel::PER_Titel & ¶) &
¶ &
Wenn ( PER::UnternehmenID = "" ; "" ; "Unternehmen: " & PER_UNT::Name & "¶") &
Wenn ( PER_UNT::Website = "" ; "" ; "Website: " & PER_UNT::Website & "¶") &
Wenn ( PER::TelefonBüro = "" ; "" ; "Telefon Büro: " & PER::TelefonBüro & ¶) &
Wenn ( PER::TelefonMobil = "" ; "" ; "Telefon Mobil: " & PER::TelefonMobil & ¶) &
Wenn ( PER::eMailBuero = "" ; "" ; "eMail Büro: " & PER::eMailBuero & "¶") &
Wenn ( PER_UNT_ADR::Adresszusatz = "" ; "" ; "Adresszusatz: " & PER_UNT_ADR::Adresszusatz & "¶") &
Wenn ( PER_UNT_ADR::Straße = "" ; "" ; "Straße: " & PER_UNT_ADR::Straße & "¶") &
Wenn ( PER_UNT_ADR::PLZ = "" ; "" ; "PLZ: " & PER_UNT_ADR::PLZ & "¶") &
Wenn ( PER_UNT_ADR::Ort = "" ; "" ; "Ort: " & PER_UNT_ADR::Ort & "¶") &
¶ &
Wenn ( PER::TelefonHomeoffice = "" ; "" ; "Telefon Homeoffice: " & PER::TelefonHomeoffice & "¶") &
Wenn ( PER::TelefonPrivat = "" ; "" ; "Telefon Privat: " & PER::TelefonPrivat & "¶") &
Wenn ( PER::TelefonMobilPrivat = "" ; "" ; "Telefon Privat Mobil: " & PER::TelefonMobilPrivat & "¶") &
Wenn ( PER::FaxPrivat = "" ; "" ; "Fax Privat: " & PER::FaxPrivat & "¶") &
Wenn ( PER::eMailPrivat = "" ; "" ; "eMail Privat: " & PER::eMailPrivat & "¶") &
Wenn ( PER::WebsitePrivat = "" ; "" ; "Website Privat: " & PER::WebsitePrivat & "¶") &
Wenn ( PER::Strasse Privat = "" ; "" ; "Adresse Privat: " & PER::Strasse Privat & ", ") &
Wenn ( PER::PLZ Privat = "" ; "" ; PER::PLZ Privat & " ") &
Wenn ( PER::Ort Privat = "" ; "" ; PER::Ort Privat & "¶") &
¶ &
Wenn ( PER::Notizen = "" ; "" ; "Notizen: " & PER::Notizen & "¶")
) & "&subject="LiesAlsURLVerschlüsselt(Mail senden)
... and a small screenshot:
"mailto:" & PER::eMailBuero & "?body=" & LiesAlsURLVerschlüsselt ( "this is line one" & Char(13) & "this is line two") & "&subject=Mail senden"
returns in Apple Mail
this%20is%20line%20one%0Dthis%20is%20line%20two
:-/
Try the same sample without the "LiesAlsURLVerschlüsselt()". Does Apple mail open it?
Perhaps it's only a few characters that need to be encoded:
"?"
"<"
">"
"&"
"="
(the double quote)
A substitute would take care of these.
Or perhaps Apple Mail handles the encoding differently. HmMMMM, a study of their specs is in order.
Jepp, also thought about a substitute - not within the field itself, but reading the field content in a variable first, replacing the character with "and" and using the variable in the script.
Without encoding there's no problem with Mail except that it only sends the part before the "&" and ignores the rest. Handling of almost all addresses works fine, but there are a few that trigger the problem. Those with &. Took some time to figure that out ;-)
I searched for Apple Mail and the urlencoding. I did not find any suggestions other than previously stated. It seemed to ignore the "&" in the field used for the subject. I tested (just the subject):
Substitute ( companyName ; "&" ; Char(65286) )
This is a Unicode character for "&" that is different and does not break the mailto:
"mailto:teddy@bear.com?subject=" & Substitute ($subject ; "&" ; Char(65286) ) & "&body= .... "
There may be other characters that need to be exchanged as well if they are part of the URL syntax.
I leave you to test.
Beverly
Bingo ! That's it ! Saved me a lot of fiddling around with variables !
Thanks a lot for your time and expertise, Beverly !
German translation would look like
URL öffnen [ Mit Dialog: Aus ; "mailto:" & EMPFÄNGER & "?body=" & Austauschen ( (MAILINHALT) ; "&" ; Char(65286) ) & "&subject=BETREFF" ]
I searched for Apple Mail and the urlencoding. I did not find any suggestions other than previously stated. It seemed to ignore the "&" in the field used for the subject. I tested (just the subject):
This is a Unicode character for "&" that is different and does not break the mailto:
There may be other characters that need to be exchanged as well if they are part of the URL syntax.
I leave you to test.
Beverly