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

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.

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.

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

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?

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.

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