saraswati Posted October 29, 2002 Posted October 29, 2002 I have to create a script which accomplishes the following. There is a master file which consists of student records (student name, social security number, courses the student has enrolled, the name of the prof who course the student has enrolled in, enrollment date, no. of lessons in a particular course, mid term test grade and the final exam grade). The script should search for all the professors and display the number of lessons the each prof graded, the no. of mid term exams the prof graded and the no. of final exams a prof graded. If a professor is teaching more than one course I need the total no. of all the courses lessons, mid terms & exmas she has graded. Another thing is a student may have enrolled to take 20 lessons in a particular course but may complete only 12 lessons so in that case the prof has graded 12 lessons for that student not 20. There is a field which lists each lesson and grade the student got in that lesson. Is it possible to implement such a script in Filemaker Pro. I cant figure out how to go about this script. If anyone has a clue then plz reply to me. Thanks Sara
CobaltSky Posted October 30, 2002 Posted October 30, 2002 Hi Sara, Most of what you want to do is not going to be best achieved by a script as such. The display of data and the calculation of summaries is something that it would likely be better for you to first set up in Layout Mode and Define Fields. If you don't already have them you are going to need a field which tells you which prof graded each student course, and for each student course, whether or not it was completed (and therefore is to be counted). The summary data can be generted using summary fields (and a layout which can be sorted by sub-summary) or, alternatively, using unstored calculations which perform aggregating calculations on your data. Nased on your description of what you want to do, I'd suggest that you consider creating one or more relationships from a separate table (file) of professors based on Prof, and then create a series of calculating fields which will generate the data you want using aggregate formulae such as Count( ), Max( ) and Sum( ). For example, a calculation with the formula Count(Professor::GradedLessons) should return the number of lessons graded by a given professor. If you have the required calculating fields in place and display them on a suitable layout, then your script need do no more than call up the appropriate file (eg the profs table) and display the summary layout you have created.
Recommended Posts
This topic is 8059 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