How to set a script to find by first letter?

[Rangoon]

I currently have the following script.

If [status (CurrentMode) = 1]

Perform Script [beep beep not in find mode message

[sub-Scripts]

Exit Script

End If

#

[keshalyi]

Have it search against just the first letter of the word, using the 'Left' function. Compare 'S' to Left(Fieldname, 1)

[Jim Chapman]

I don't understand the reply. I'd like to know what you mean be Compare 'S' to Left(Fieldname,1). Is this in a command line? Not it the find field.

Thanks in advance!!

[Lee Smith]

Hi Jim,

You can do this in a couple of ways.

One way is by using the NewField2, calculation field described below, and just do your find in it, or create both NewField1 and NewField2, and streamline it a bit.

NewField1 Global, Text

NewField2 Calculation, Text Result =

Left(NameLast,1)

Substitute "NameLast" with the name of your field for Last Name in the calculation above.

With these two fields, you can set up a script that will perform a find on whatever Initial you type into NewField1 in NewField2.

Or,

Use the two fields in a Relationship (NewField1 on the left and NewField2 on the Right) than use a portal utilizing this relationship. I would put the full name fields in the portal, and then by typing a letter in the global, the portal will reflect all records with that letter as the first initial in the portal.

HTH

Lee