Set Repeating Field Script

[Jarvis]

I have a text field with 10 repetitions.

For the purpose of this database, I would like to enter one value into the first repetition and have the remaining repetitions repeat that same value.

Can this be scripted?

Thanks for any insight.

Jarvis

[IdealData]

When you set a field using SetField you get the option to specify the repetition number.

Look closely at the dialog box, the repetition number is below the list of fields.

[Fenton]

Also look at the Extend(field) function, in the Repeating section of the calculation dialog. It is expressly for including the value of a regular field in calculations with repeating fields.

[Jarvis]

Mark,

I had no problem specifying the number of repetitions that I wanted, but thank you for making sure I wasn't stumbling there.

Fenton,

I tried the Extend(field) function as you suggested but it did not produce the result I was seeking.

What I am trying to do is produce a grid of repeating fields that kind of resembles a spreadsheet. Each field name would represent a task description and each repeating value would represent a cabinet identification number.

The grid would look like this:

(TASK 1) 123456789

(TASK 2) 123456789

(TASK 3) 123456789

(TASK 4) 123456789

(TASK 5) 123456789

As tasks are completed you select the cabinet (repetition) you worked on and hit a button/script to clear the field. The view you would see is kind of the reverse of a picture puzzle. When all of the pieces have been cleared, no more tasks remain and the project is complete.

To complicate this further, I would like the option to type some text (worker name) into the first repetition of the field and have the rest of the repetitions repeat the same value:

Option 1: TASK 1: 1-2-3-4-5-6-7-8-9

Option 2: TASK 2: Skippy-Skippy-Skippy-Skippy etc.

Any suggestions on how to automate the data into the repeating fields?

Thanks again,

Jarvis

[-Queue-]

Perhaps I am missing something here, but why not use a normal field and just duplicate instances of it on the layout for as many 'repetitions' as you need?

[Ugo DI LUCA]

Hi,

Look back to Fenton answer. If you just set your field as a calculation it woud work. If you want it to be text, set it to be a lookup from the calculation and trigger a relookup.

[Jarvis]

Queue,

You were right.

I just did a weak job of explaining what I was looking for.

Ugo,

I stared at your answer, tried Fenton's approach, still didn't get anywhere. When you use the EXTEND(field) function on a field with repetitions it produces a very unusual integer.

I thank both of you for your help. Anyway.

Jarvis