Newbies CanadaDry Posted November 24, 2006 Newbies Share 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 Link to comment Share on other sites More sharing options...
aldipalo Posted November 25, 2006 Share Posted November 25, 2006 Sounds like it is a relationship problem. Check your relationship from contact to assets. Link to comment Share on other sites More sharing options...
Digital Life Posted November 25, 2006 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now