Newbies CanadaDry Posted November 24, 2006 Newbies Posted November 24, 2006 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
aldipalo Posted November 25, 2006 Posted November 25, 2006 Sounds like it is a relationship problem. Check your relationship from contact to assets.
Digital Life Posted November 25, 2006 Posted November 25, 2006 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.
Recommended Posts
This topic is 6575 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 accountSign in
Already have an account? Sign in here.
Sign In Now