Automatically fill in field from first letter of another field

[Funkypsik0]

Hi,

I have a situation where i would like to fill in a field automatically, dependant on the first letter entered in another field.

Here's some examples:

1. Field one - A6805B  Field two - 'UHF' (As A = UHF)

2. Field one - E1234C  Feild two - 'VHF' (As E = VHF)

3. Field one - S5673D  Field two - 'Error - No Frequency' (As S doesn't have an equivalent)

Can anyone help?

Cheers

Rob

[Niall_O_Donovan · Accepted solution]

Hi Rob,

You can do this by assigning the first letter to a variable and then testing that variable.

A sample is here: https://acrobat.com/#d=OoLUPLu1Qy1*8Uxz7*hG6Q

Hope that helps,

Niall

[Funkypsik0]

Aweseome. Once again Niall, thank you.

Rob

[Niall_O_Donovan]

You're welcome.