April 16, 200718 yr Does anyone know if its faster to use an auto-entered calculation to enter data into a field from a related table versus using Set Field script step? The only way records get created are through scripts, so having to script "Set Fields" isn't hindering to the process itself. As of now, it's taking a while to create records because of auto-calcs, so I'm wondering if set fields would fix the time lag. Thoughts? Thanks!
April 17, 200718 yr Try it and see -) The biggest lag is probably caused by the looking up of the related record and extraction of the data from it - so I doubt either method would be much quicker than the other. If it were me I'd use the script option because it's neater and when I came back to it in a year's time it would be immediately obvious where the records were getting their data from. Yours James
Create an account or sign in to comment