Individually boxed digits in one field

[117Alan]

I have a field for an insurance number that contain up to eleven digits, but may be less.

I would like create 11 little boxes in the data entry layout so that the person entering data can see that they have entered the correct amount of digits.

Something like this, except 11 boxes:

(sorry my drawing will not "cut and paste")

(for now lets assume I do not want to use the “define database” field validation options)

Also each time a digit is entered the cursor moves to the next box.

I have tried using the drawing tools and the field control setup but I cannot seem to achieve a neat result.

Any ideas please?

[fabriceN]

Wouldn't a repeating field with borders between repetitions save the day ?

[117Alan]

Hi

Thanks but that only seems to repeat the same numbers in all the fields

[Raybaudi]

I suggest to use a combination of a normal input field and a calculated repeating one.

INPUT is a text field

SHOW is a calculated repeating field with 11 reps and calc:

Middle ( Extend ( INPUT ) ; Get ( CalculationRepetitionNumber ) ; 1 )

... but you'll still need a validation for max 11 chars or you have to change the calc to:

Case(

Length ( Extend ( INPUT ) ) ≤ 11 ; Middle ( Extend ( INPUT ) ; Get ( CalculationRepetitionNumber ) ; 1 )

)

so the field SHOW remains empty if the user inserts more than 11 chars.

[Fitch]

You could try using a web viewer with this:

[comment]

And then?

[Fitch]

What I had in mind was:

1. Cool web viewer idea

2. ...

3. Profit!

Hmmmm... Fusion Reactor plugin?

[Genx]

11 fields would be kind of annoying... why not just use an autoenter coloring the text red if its length is wrong.