Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Enter sequence of numbers/letters into table cell to obtain a predetermined result in adjacent cell

RLHRLH
Level 1
Level 1

I am using Liveclye Designer ES 8.2.  I have a table with two columns.  A user will enter a code number in Column 1 that has four numbers and a letter (i.e. 1234B).  Codes could be in a range of any number from 0101A through 8999A, 0101B through 8999B and so on.  Based on the letter entered, I want column 2 to show a corresponding size.  A letter "A" in the code number would show "1 L" in the second column, a letter "B" would show "750 ML" or a letter "D" would show "200 ML" etc.

I am trying to use FormCalc and am not sure how to go about this.  Is there a possibility that someone could show me the appropriate language structure?

Example:

Column 1     Column 2

  0669A           1 L

  6522D       200 ML

  7001B       750 ML

Thanks.

0 Replies