Jump to content
Sign in to follow this  
edudna

A script to promote students

Recommended Posts

I have student records belong to groups A, B, C, D, E, F.

I need a script to do all the follows in all the records:

Delete all the F students.

Delete all the grades of classes that students took with promoted grades.

Promote A to B, C to D, D to E, E to F students.

Pascal

Edited by Guest

Share this post


Link to post
Share on other sites

Perhaps it obvious what it is to take classes with promoted grades, but I do not get it.

SInce grades ought to be in it's own related table, isn't the selection much of a problem - GTRR(FS) after narrowing the found set down to those with promoted grades ... and then delete the related records.

To change an attribute should either be looped or dealt with via a scripted replace:

http://www.filemaker.com/help/Script-Steps52.html

...to make the promotion via a CF getting the ascii char number is a little overkill, since you overall deals with 5 levels, so a Case( must be all it takes.

--sd

Share this post


Link to post
Share on other sites

I believe it would be better to record the year of enrollment. Then the promotions would happen automatically - unless there was an exception recorded separately for a particular student.

Share this post


Link to post
Share on other sites

Loop sometimes is very slow I do not know why and action "replace field contents" does not work when we have to change values in popup menus. However when we have to work with the enrollment year and we want to keep the old records, I believe that we have to save in the script the old file than to dublicate because we can cause a terrible mess in the database.

Pascal

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    2 members have viewed this topic:
    LabMole  PathGeek 
×

Important Information

By using this site, you agree to our Terms of Use.