Can you provide an example of what this is supposed to produce on your screen when the script runs?
I would like the words "Media Reviews" to be linked to this url" http://www.joannajordan.com/about/" in my script calculation I have included the link below as I would like it to appear in the Email (not sure if it will post as a link as i am new to posting here
For mare about my background, please check out my Media Reviews
Here is how I would like it to look:
Here is some other parts of the email letter that I have created a script calculation for
TextFont(CUSTOME::PriceQuote;Roman) & "Hi " & CUSTOME::DEAR & ":"& ¶ & ¶ & "Thank you for taking the time to fill in my price quote form. At this time, I am available on "& CUSTOME::UPERFORMDA &" from "& CUSTOME::UTIME &" . My fee to perform "& CUSTOME::UTYPEGIG &" "& CUSTOME::UTYPEMUSIC &" is "& CUSTOME::UFEENOGST &" plus HST.
(and so on)
Email sent out via FileMaker's Send Mail is plain text. Sometimes you can sneak in an HTML tag and it works and sometimes not so you would have to test the following in a number of different email programs (on the receiving side of the email) to see if it works consistently:
But here is a quoted string that you migh include in your calculation: "<a href=\"http://www.joannajordan.com/about/\">Media Reviews</a>"
It may look like this in your recipient's email or it may not: Media Reviews
Ultimately, you may need to use an email plug in that supports more options in order to get the formatting and hyperlink that you want.
PS. the above link should be a "live" hyperlink as I used the tool (far left tool in Post A New Answer tool bar) for creating a hyperlink to produce it.
Thanks so much for the suggestion, I tried
Also, please check out some Audio and Video Playlists at my website. Or to see my Meida Reviews "<a href=\"http://www.joannajordan.com/about/\">Media Reviews</a>",
and got this error as this is a calculation field :
The specified table cannot be found.
Sounds like you left out a quote or the backslash (\) needed to "escape" a quote included inside a quoted string.
Is this string the entire calculation or are there other parts that you didn't show?
Did you enclose that entire string in quotes?
What was highlighted when you got that error?
here is most of what is in the calculation
TextFont(CUSTOME::PriceQuote;Roman) & "Hi " & CUSTOME::DEAR & ":"& ¶ & ¶ & "Thank you for taking the time to fill in my price quote form. At this time, I am available on "& CUSTOME::UPERFORMDA &" from "& CUSTOME::UTIME &" . My fee to perform "& CUSTOME::UTYPEGIG &" "& CUSTOME::UTYPEMUSIC &" is "& CUSTOME::UFEENOGST &" plus HST.¶¶I For mare about my background, please check out my Bio or CV (resume). Also, please check out some Audio and Video Playlists at my website. Or to see my Meida Reviews, Please cheick out why I play Electric Harp. or my CHECKLIST OF QUESTIONS TO ASK MUSICIANS.¶¶¶BOOKING PROCESS¶¶¶Confidentiality: The information contained in this e-mail is intended only for the personal and confidential use of the designated recipients of the email. This message is privileged and confidential. You are hereby notified that any review, dissemination, distribution, or copying of this message is strictly prohibited.¶¶¶"
Note, there are some misspellings in that text that you will want to correct (mare instead of more, meida instead of media....)
To repeat, what is highlighted at the instance you get that error message. Check starting from that point to see if you have either a missing or extra quotation mark as such can produce an expression where your fields are treated as quoted text and your quoted text as fields--producing the error message that you have described.
And in a quoted string, putting \ in front of the quotation marks "escapes" the character so that the quotation mark appears as a character inside the string instead of being evaluated as the stopping point for some quoted text.
"This is an example of \"quoted\" text" in a calculation field will show on your layout as:
This is an example of "quoted" text
Thanks so much for all your help, but I still can't get it to work. To try to isolate this and make this part work, I deleted all the text in my template and just copied and pasted
"<a href=\"http://www.joannajordan.com/about/\">Media Reviews</a>"
and got this result
<a href="http://www.joannajordan.com/about/">Media Reviews</a>
That would be the correct result for this calculation.
It will not appear as a hyperlink in the calculation. As I said in my original post, it may appear as a clickable hyperlink when the recipient opens and reads the email where this is included in the body of the email. As I said from the start, you will need to test this and see if it works. If it does not work, then you will not be able to include a hyperlink in your text when using Send Mail, you'd need to investigate email plug ins to see if any offer this capability.
I had hoped that this was what you could get but warned that it might not work. Looks like you will need to either work from a link that repeats the URL text or use a plug in instead of Send Mail.