How to convert numbers to text in a form created in LiveCycle Designer? | Community
Skip to main content
Peter_Miles
Level 2
Jun 17, 2009 10:56 PM UTC
Solved

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

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.
    _Bruce_Robertson
    _Bruce_RobertsonAccepted solution
    Level 10
    Jun 20, 2009 4:41 PM UTC

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

    View reply

    13 replies

    Show previous replies
    Peter_MilesAuthor
    Level 2
    Jun 18, 2009 2:51 PM UTC

    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]

    Translate
    _Bruce_Robertson
    _Bruce_Robertson
    Level 10
    Jun 18, 2009 12:02 AM UTC

    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.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...