How to convert numbers to text in a form created in LiveCycle Designer?

Peter_Miles

17-06-2009

I am relatively new to Livecycle Designer and very much a newbie with JavaScript and FormCalc.  I have created a Conditional Sales Contract form and when the user enters a dollar amount (1548.95) I would like to know how to  auto fill a text field with its text equivalent ( One Thousand Five Hunderd and Fourty-eight dollars and ninety-five cents).  I have found two forums explaining how to do this in Acrobat 8 but nothing in LiveCyle Designer.   Can this be done in LiveCycle and can anyone please help me with the script?

thanks

Accepted Solutions (1)

Accepted Solutions (1)

_Bruce_Robertson

MVP

20-06-2009

Hi Peter,

You could move the WordNum function to the calculate event of the text field (might be a better place for it anyway).

So you would have something like;

WordNum(NumericField2

, 2)

Bruce

----- form1.#subform[1].DollarAmountText::calculate: - (FormCalc, client) ------------------------------

Answers (11)

Answers (11)

_Bruce_Robertson

MVP

18-03-2010

I see what you mean, very annoying.  I can only guess you could try something really hacky like;

Replace(Replace(Replace(Replace(WordNum(x,2

), "Dollars ",""), "Dollar ",""), "Cents", ""), "Cent", "")

Sorry

Bruce

_Bruce_Robertson

MVP

17-06-2009

FormCalc has a WordNum function that will do this.  So maybe on the exit event of the dollar amount field you could have;

DollarAmountText

= WordNum($ , 2)

Where DollarAmountText is the field to show the text equivalent. "$" is FormCalc's way of referring to the current field and "2" means monetary value with cents.

JainSa

29-03-2018

Hi I'm new to learn Live cycle Designer and very much a newbie with JavaScript and Form Calc.  I have created a Manual form(Amount and Amount in word) in amount Field entered value (100000 INR) I would like to know how to  auto fill a text field with its text equivalent ( One lakhs only).

But the value come Different :One Hundred Thousand only.(I think this is Us Relevant,but I don't need this.i want India Format)

I wrote code in Formcalc:

Concat(WordNum(amount),space(1),"Only").

then try WordNum(amount)


clina12345

10-07-2013

Hi Bruce,

Can I add prefix and suffix to the converted text?

eg.  "SAY US ONE HUNDRED SIXTY THOUSAND DOLLARS AND SIXTY FIVE CENTS ONLY."

Can I make the converted text auto upper case?

Thanks

Jay

stejpal

16-03-2010

Hi Bruce,

    Yes, but this will not also print in words any figure after the decimal. i.e. Amount = 1.25, with wordmum(Amount), the output is One. i want it to print One and Twenty Five as it should.

with wordnum(amount, argument), i get "dollars" and "cents" in the output. can i get the output without "dollars" and "cents" as part of the output.

thanks in advance.

Peter_Miles

18-06-2009

Thanks for the help, I can see how that FormCalc script works on exiting a field where the dollor number has been entered but what do I need to add to it in a field where the amount has been simply carried forward from a calculated field.  Currently in this number field is:

----- form1.#subform[1].DollarAmount::calculate: - (FormCalc, client) ------------------------------

NumericField1[8]