cancel
Showing results for 
Search instead for 
Did you mean: 

Maintain the fields on the correspondence form

JesseJSilaen
Explorer
0 Kudos

Our client has a request to add a spelled field ‘Terbilang’ (changing the number 'AmountInTransactionCurrency' to text) using Indonesian on the form. whereas in the FormCalc code provided by Adobe LiveCycle only the WordNum syntax is changing the number 'AmountInTransactionCurrency' into English text

JesseJSilaen_0-1716199297852.png

 

View Entire Topic
Jerry_Lowery
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi JessJSilaen,

As you noted, that function WordNum is designed by Adobe to only convert to English (https://help.adobe.com/en_US/AEMForms/6.1/DesignerFormCalcRef/WS92d06802c76abadb-32254d55129f5ee7c98...

"Returns the English text equivalent of a given number."

If you look in the FormCalc reference, only English is supported 

"As of this release, it is not possible to specify a locale identifier other than English for this function"

It's not an uncommon ask, there are several looking for the same thing since at least 2010... there is even a SAP knowledge base article on it

https://userapps.support.sap.com/sap/support/knowledge/en/3380539

 

Have you considered to code it yourself in FormCalc or Javascript? (i had to once do a bubble sort for a table in a similar manner)

Similar to what they did here (sorry for the external link), see the Self Impementation: https://ourcodeworld.com/articles/read/353/how-to-convert-numbers-to-words-number-spelling-in-javasc...

which draws on this example: https://stackoverflow.com/questions/14766951/transform-numbers-to-words-in-lakh-crore-system

The only other option is maybe define a custom field and use developer extensibility or side-by-side extensibility to update the custom field and pass it to the form.

Thank you

Jerry