Jump to content

Need help with email script


This topic is 6359 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello,

I am new to FileMaker Pro and need some help editing a script for the Lending Library template.

I want to insert the First Name of the person who checks out a library item in the reminder and late notice email. So the email would look something like this:

--------

(Contact First Name),

You borrowed (item x) by (author y) on (check out date)from the library.

This item needs to be returned on (Due Date).

---------

Everything works in my script except the first name field.

I've tried entering the History Contact ID: Contact Name field as well as the Contact: First Name field into my script, but it isn't working.

I'm not sure which field I should be using and/or if I have the script commands down right.

Here is my script as it stands now (without the first name at the beginning):)

"You borrowed: ¶¶" & Assets::Title & " by " & Assets::Author & "¶on " & GetAsText(History Asset ID Flag Checked Out::Check Out Date) & " from the Library. ¶¶This item needs to be returned on " & GetAsText(History Asset ID Flag Checked Out::Due Date) & ".

--------

Any help would be most appreciated.

Cheers,

CanadaDry

Link to comment
Share on other sites

I think I would use the set variable command in the script. So name a variable say $MessageText. Then click on the "Specify" button next to the "Value" area. Then define the value to be something like:

"Dear " & FirstNameField & ¶¶" &

the rest of the message you've alreay calculated.

Then in your SendMail type in $MessageText in the "Message" box.

Link to comment
Share on other sites

This topic is 6359 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.