You might consider a combination of live and stored/updated data:
- Have a stored field which shows the last time & date the updater was run
- Have a button available to run the updater which resets the scores based on latest data.
That way users will have no unstored calcs to deal with in the layout displays, just the latest stored results, but, if they see the updated amounts are not as recent as they want, they can run the script to update the values (SetField script steps) to what the unstored calcs would have displayed if you were using them.
This also makes access via WAN very zippy as there are no calcs at all involved until the updater is run.
If all of the data is stored on one server, you can even set a server-side schedule to run the updater script daily, preferably around 2am, but not during a scheduled backup.
thank You stephen.
You are advocating for stored fields. That makes sense. I may use a new table in which to place to fields so that the admin can go back and look at the progres a teacher has made over time.
I assume i don't have much access to place a server-side script that will update this since we are going to an exterally hosted file. I'm not even sure how to work with those yet. I'll explore that if it be the case i can do something with it.
Your FM hosting service should allow you to administer your FM Server remotely with the Server Admin tool, which is where you set schedule server scripts. Ask them about this, as it is really useful to have updater scripts such as this set to run without requiring client action at regular periods.