Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5815 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

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
Posted

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

Posted

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.

Posted

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

This topic is 5815 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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