default values in a repeating field?

[jsutherlin]

Hello all. I've been trying to create a repeating field that starts off with a default value of "yes" in all the repeating fields but I've had no luck. Only the first "cell" of all the repeating field has "yes" as a default value the rest have nothing in them when the record is created. Anyone know how to set all the "cells" in a repeating field to a default value. Thanks for the help.

[CobaltSky]

I suggest that you look at limiting the menu options for your users (via access privileges) so that the only way new records can be created is via a script and button you provide.

Then, you will be able to include some steps in the script which, after creating a new record, populate each of the repetitions of your field with 'yes' values.

[jsutherlin]

I'm not sure how to access each "cell" in the repeating field but I'll bang away at it and see what I can do. thanks for the suggestion.

[Razumovsky]

in the set field script step, when you specify the field, you can also specify the repition (bottom left in field dialog box).

[jsutherlin]

Thanks!!! That worked like a charm.

[djgogi]

Or you could define an global repeated field gRep with as many reps that you need and an ConstanSelf relationship constOne-->constOne where constOne is calculated as 1.

First populate the global with values that you need and than set auto enter option for your field as look up from filed gRep from relationship ConstantSelf

Dj

[Dania]

It is strange that auto entry options do not seem to allow you to specify what to do about the field repetitions - except mybe the lookups that dj has said.

This seems the design limitation with the repeating fields. And maybe is other reason not to use them, really?

[Razumovsky]

Or you could define an global repeated field gRep with as many reps that you need and an ConstanSelf relationship constOne-->constOne where constOne is calculated as 1.

First populate the global with values that you need and than set auto enter option for your field as look up from filed gRep from relationship ConstantSelf

I like this idea better, but have a question:

Would you need the relationship at all? I would think you could just auto enter the Global repeating field into the text repeating field on creation. Perhaps globals are only visible to each new record after the auto-enter commands have been completed? Havent tried, but curious.

[djgogi]

Too bad that it will fill only the first rep.

The problem is that in auto enter calculation box is lacking option "calculated result is an repetition field" as in standard define calculation box.

Dj

[Razumovsky]

Aha. Good to know if I ever need a repeating field. I assume that lookups circumvent this problem then.

Thanks!