Intermittent Auto Sort

[khughes]

I have noticed that when some of my databases are opened, they occasionally begin a sort process, keyword occasionally.

While there may be a script causing this, I wondered if this might be a standard thing for FileMaker when a particular threshold is tripped.

The databases I use were inherited and I am not a FileMaker expert, so I will dig deeper in an attempt to locate a custom sorting script that is being triggered, but if anyone can save me time by letting me know if this is normal behaviour for FM, I would appreciate it.

[khughes]

Follow up - I noticed when opening a database today that the windoid title was Today Calculation. It preceeded to calculate something prior to opening the database.

I can find no mention of Today Calculation in the FileMaker Pro v5 Bible. Anyone know if this is a normal FileMaker routine that gets triggered by a particular threshold and if so what that threshold is?

[Kurt Knippel]

Today is a function that can be used in scripting and/or calculation fields. It is basically an internally stored calculation that is stored in ALL records in the database.

However this is only calculated if it is used somewhere. So check your calculations and scripts for somewhere you must have used the Today function.