What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Include thousand separators on payment amount field?

    Asked by ACCnational on December 04, 2016 at 04:39 AM
    Also how do I get the results of the calculation to include thousand separators, eg $2,000? And would this then mess with the ‘If less than…’ as in field 42?
    Thanks
    Kind Regards,
    JEFFREY BARTLETT
    General Manager
    AUSTRALIAN CHRISTIAN CHURCHES
  • Profile Image
    JotForm Support

    Answered by EltonCris on December 04, 2016 at 04:47 AM

    If you meant it for the amount field on stripe payment, that's not possible. It only recognizes numbers since symbols would cause errors on checkout.

    However, if it's for the calculation field, you can use the commaSeparate function.

    Example:

  • Profile Image

    Answered by ACCnational on December 04, 2016 at 08:44 PM
    Thanks, but this doesn’t seem to be working for me. is it possible that the CSS inserted to generate the $ sign is messing with the commaSeparate? I have insert commaSeparate in both fields 19 and 20 and it doesn’t seem to make a difference.
    Thanks
    Kind Regards,
    JEFFREY BARTLETT
    General Manager
    AUSTRALIAN CHRISTIAN CHURCHES
    [cid:image001.png@01CF9D0C.37764560]
    PO Box 8093 Baulkham Hills BC, NSW 2153
    Suite 408, Level 4, 12 Century Circuit, Baulkham Hills 2153
    T: +61 2 8853-5150 F:+61 2 8853-5100 W:www.acc.org.au
    Any opinions or advice offered in this email are general in nature. Professional advice particular to specific circumstances should always be sought.
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on December 04, 2016 at 10:30 PM

    The CSS should not affect the commaSeparate. Upon checking the fields, it appears that the values are currently outside the commaSeparate function, which is why they are not making a difference.

    To resolve this, simply insert the formula inside the parenthesis of the commaSeparate function, as seen below.

    The function should then work correctly.

    If you need further assistance, please let us know.
    Regards.