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