finding next blank repetition in a field

[tim ryan]

I want to use a start/stop button to track an operator's time. Every time the button is clicked, the time should be recorded in a repeating field. I need to see a list of all start/stop times, and then summarize how much time was spent on the job. How do I automatically jump to the next available (i.e. blank) repetition in that field?

[bruceR]

You don't. You use a proper relational design and set up a related table. You can't summarize repeats.

[DykstrL]

You can do it with repeating fields, but it's not pretty and most of the data in the repeating fields must be manipulated with scripts.

I have attached a sample file that will show one way to do it.

A related file would be a better method - you would not be restricted to a set number of repetitions. The scripts would also be simpler.

TimeStartStop.zip