I'm new to this Filemaker thing, and I'm trying to write a very complex script that can do the following (complex for me).
To give some background, I have a report that I run from another database on a daily basis. This report includes dates that students made a request, instructors name/email/course.
I import this report, and for any new records that are added, i need an email to go out. Can I create an email template in Filemaker that can pull information from specific fields? Such as an instructor email address from each record, to include: Dear instructor, This is to inform you that "student name" in your "course" is requesting blah blah blah.
Thanks for any help with this! Like I said, this is all new and I'm trying to be more efficient with my time and automate some things.