How to convert numbers to text in a form created in LiveCycle Designer? | Community
Skip to main content
New Participant
June 17, 2009
Solved

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

  • June 17, 2009
  • 12 replies
  • 17034 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by _Bruce_Robertson

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) ------------------------------

12 replies

New Participant
August 30, 2020

how to convert words to numbers using adobe 

JainSa
New Participant
March 29, 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)


New Participant
December 14, 2022

Hi Jain,

          

           I am also looking for the Indian currency in adobe form. could you help to solve that.

 

Thanks,

Bijesh RB.

 

July 10, 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

March 18, 2010

Hey Bruce,

   thanks man. the replace works great.  i dont mind being hacky .

thanks again,

_Bruce_Robertson
New Participant
March 18, 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

March 16, 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.

_Bruce_Robertson
New Participant
March 16, 2010

Hi stejpal,

Just leave of the second argument, that is just use WordNum(NumericField2)

Bruce

March 15, 2010

Hi,

    Using the WordNum formcalc function, how can i get the output without the "Dollars" and "cents"?

thanks,

New Participant
June 22, 2009

Thanks very much for your help Bruce that's done it!!

_Bruce_Robertson
_Bruce_RobertsonAccepted solution
New Participant
June 20, 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) ------------------------------