Expand my Community achievements bar.

SOLVED

Automatically fill in field from first letter of another field

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

3 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 2

Aweseome. Once again Niall, thank you.

Rob