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

Sounds like it is a relationship problem. Check your relationship from contact to assets.

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.