How to create an A-Z form

[Digitalbrit]

I am wanting to create a list of letters of the alphabet, which when clicked upon will execute a script (that will return records beginning with that specific letter) and then highlight that letter in the list.

I can envisage 26 buttons each calling the same script passing in the chosen letter. Where I am struggling is with how to highlight the letter somewhere in this process.

I have spent hours barking up lots of wrong trees!!

Can anyone help me please.

Many thanks

Tim

Edited October 18, 2008 by Guest

[comment]

You need to store the chosen letter in a global (field or variable), so that each letter in the list can compare itself to it. A repeating calculation field would be convenient here, e.g.

Let ( 

char = Middle ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; Get ( CalculationRepetitionNumber ) ; 1 ) 

;

Case ( char = Extend ( gChar ) ; TextColor ( char ; 255 ) ; char )

)

[Digitalbrit]

Cool! Thanks for pointing me in the right direction again comment.

I first tried setting up the repeating 26 field as a text field with the code on auto-enter but that wasn't working. Then I realised you'd said a "calculation" field. Now she's sorted.

Thanks again.