Jump to content
Sign in to follow this  
magicbbs

removing the "update today field" script

Recommended Posts

If I change the "today" field created by filemaker to be either an unstored calc field or a global field could this screw up calcs in scripts and other calc fields? I want to remove the "update today field" script as I have a comment file with 200,000+ records in it and it takes way too long to update each morning. Thank you in advance.

Share this post


Link to post
Share on other sites

If you change it to an unstored calc or global then it will no longer be indexable and cannot be used as part of a relationship. This will also cascade through into other dependent calculations and relationships also associated.

Share this post


Link to post
Share on other sites

I want to remove the "update today field" script as I have a ...

This must be a migration thingy, you need to explain to us what it does a little more in detail. Since this is the maintance of a very large index, should it be done in another way from a TO away. Typically was is it back then used for tagging overdue invoices, which by todays methods probably is it best served by a multi-criteria relation.

First leg could be a found set established via a non-equijoin, while the second could be a List( made the ID's of the paid invoices, whether or not it's establised as a selfjoin doesn't really matter, but the TOG needs some working in the ties as to what they do, all it then takes is a GTRR(SO) isntead of the "Update..."

--sd

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  

×

Important Information

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