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

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

Recommended Posts

Posted

I have a script that runs automatically every time new records are imported. It does the job well enough but is getting slower as the file size increases. It would speed things up if the script only had to loop through the records of one year. The problem is, I can

Posted

Create a calculation number field of Year(PayPeriodEnd). After your import, set a global number field with Year(PayPeriodEnd). Then, either

Enter Find Mode [ ]

Set Field [PayPeriodEnd; globalnumberfield]

Perform Find [ ]

or create a relationship between the global and the Year calculation field, and use Go to Related Record [show only related; "yourRelationship"].

This topic is 7248 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.