jameshoty

Selective Email blast base on value in ValueList in a 2-level portal setup

Discussion created by jameshoty on Mar 25, 2013

Dear FileMaker Developers,

 

I need to email to person who did not turn up for the session, which they have signed up for previously. The 3 tables are

 

 

Subject
Module

Registration
Subject ID
Module ID

Register ID

Subject Name
Module Name

Student Name

Start Date
Date
Email
End Date
Location
Attended
... ...
... ...
... ...





ONE SubjectHasMANY Modules








ONE ModuleHasMANY Registration





 

The field ATTENDED is a Value List containing YES and NO. I am able to send email to ALL students that have registered for a particular module to remind them. On the day when the module is conducted, the teacher will take attendance for the student. IT is either Attended (YES) or Did Not Attend (No).

 

The question I encounter now is how to send email to all students who DID NOT attend across ALL the module EXCLUDING those register for modules that fall after the current date.

 

The module is conducted serveral times a year and student who fail to attend can register for the next date. My job is to email to invite them to attend the next schedule but I do not want to include those that are already registered for that schedule.

 

Eg. the next date for Kinetic Energy module is on 2.Apr.13. Some may have already registered themselves for this date. The email should exclude these group of users.

 

Hope the decription is clear enough for your analysis.

 

Regards,

James

Outcomes