How to convert numbers to text in a form created in LiveCycle Designer? | Community
Skip to main content
P
Peter_Miles
Level 2
June 17, 2009
Solved

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

  • June 17, 2009
  • 12 replies
  • 17096 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

    _Bruce_Robertson
    _Bruce_Robertson
    Level 10
    June 18, 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.

      P
      Peter_MilesAuthor
      Level 2
      June 18, 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]

      _Bruce_Robertson
      _Bruce_RobertsonAccepted solution
      Level 10
      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) ------------------------------

        P
        Peter_MilesAuthor
        Level 2
        June 22, 2009

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

        A
        Anonymous
        March 15, 2010

        Hi,

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

        thanks,

          _Bruce_Robertson
          _Bruce_Robertson
          Level 10
          March 16, 2010

          Hi stejpal,

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

          Bruce

          A
          Anonymous
          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
          _Bruce_Robertson
          Level 10
          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

            A
            Anonymous
            March 18, 2010

            Hey Bruce,

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

            thanks again,

            A
            Anonymous
            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

            Show more replies
            Terms & ConditionsAccessibility statement

            Loading footer...