Go to NEXT Repetition

[Jarvis]

I have a field called Gizmo.

This field has 5 repetitions.

I populate the fields with five scripts that say:

Go to Gizmo[1]

Go to Gizmo[2]

Go to Gizmo[3]

Go to Gizmo[4]

Go to Gizmo[5]

What I would like to do is reduce this to one script that merely says go to NEXT repetition. If Repetition 3 is already populated, I would like filemaker to recognize this then go to Repetition 4.

Any ideas how to do this?

Thanks,

Jarvis

[Wim Decorte]

I believe the "Go To Field [next] will move between reps...

[ThatOneGuy]

Jarvis:

I believe the "Go To Field [next] will move between reps...

... and he's right ... but I think that's only so long as the Reps are included in the layout's Tab Order ... which is probably not a big deal. Keep in mind, though, that you'll need to update the layout's Tab Order if you choose to display additional repetitions.

If, for some reason, you don't want the Repetitions included in the Tab Order, attached please find one alternative. The Go to Next Rep button has a simple button-step of Go to Field. Through Specify, we can put in a little calculation for the Repetition number ... Get ( ActiveRepetitionNumber ) + 1 ... in this instance.

• When the record is not active, clicking the button takes users to the first repetition.

• When the record is active and the cursor is in a rep, clicking the button takes users to the next repetition, ...

• Unless, the cursor is in the last repetition displayed, in which case, clicking the button commits the record. Click it again, and users are taken to the first repetition. Rinse and repeat.

Once more, this does not rely on any Tab Order settings for the field. In fact, if you display more repetitions, the button adapts. Do a little experiment. Go into Layout mode and double-click on the field. Edit its Field/Control Setup to change the number of reps shown from 5 to 10. Back in Browse mode, try the button again.

A caveat with this method (and the same for Mr. Decorte's technique, I think) is that the repeating field's Behavior must always be set to Allow Entry in Browse Mode. But since your design already allows for field entry, this shouldn't be a problem.

The differences are very slight, but thought you might like to know about this option.

GoToNextRepetition.fp7.zip

[Jarvis]

Thanks guys!

That did the trick (for now)/

Jarvis

[ThatOneGuy]

That's great, Jarvis! Hope the example file helped. Call again if you need.

:beer: