Replace numbers with letters

[Accountability]

I would like to create a field that is populated with letters that are the result of numbers in other fields. I would like to accomplish the following.

From:

Field 1) Price: $12.50 (will be grabbing intiger only .. disregarding any .50)

Field 2) Percentage: 15%

Field 3) Date: 01/14/2012

Desired Result:

[based on conversion table 1=A, B=2,C=3,D=4,E=5 etc.]

Field 4) AB-AE-AL (AB=12 from field 1, AE = 15 from field 2 and AL = 112 (month/year) from field 3.

I want to get the desired values from fields 1,2,and 3 then convert those values, cancntenate and insert into field 4 (with a "-" between values).

Would appreciate any help. Thanks !

[HongTaiLang]

I think this need to add JavaScript code.

[Kurumi]

Hi - just an update. You may now use Calculated Value in this kind of workflow. If you want to change the numerical value to a corresponding letter, you can use this formula:

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE([@field:FIELDNAME_NUMBER], '1', 'A')
, '2', 'B')
, '3', 'C')
, '4', 'D')
, '5', 'E')
, '6', 'F')
, '7', 'G')
, '8', 'H')
, '9', 'I')
, '10', 'J')

For example, if you have 123.45 the result will be ABC.DE

For reference: https://howto.caspio.com/datapages/datapage-components/calculated-values/