Dynamic time schedule
Hi! Im working on a film-making database for scheduling film shots. Each shot has a scheduled time and an specific duration during the shooting day. The STARTING TIME of each shot is related to the previous shot ENDING TIME. I need a solution for autocalculate and autofill starting and ending time of all the shots when duration of one shot is modified. Right now Im using a script that goes throught al the shots, grabs the previous shot ending time, calculates and replace the stating time but its to slow. Thanks for reading. Thanks for your time.
You might be able to figure something out using the getNthRecord function. This function let's you refer to data in a record that is in a specified spot in your found set.