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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    spand 
×
×
  • Create New...

Important Information

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