Include thousand separators on payment amount field?

  • ACCnational
    Asked on December 4, 2016 at 4: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
  • Elton Support Team Lead
    Replied on December 4, 2016 at 4: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:

    Include thousand separators on payment amount field? Image 1 Screenshot 20

  • ACCnational
    Replied on December 4, 2016 at 8: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.
    ...
  • Chriistian Jotform Support
    Replied on December 4, 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.

    Include thousand separators on payment amount field? Image 1 Screenshot 40

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

    Include thousand separators on payment amount field? Image 2 Screenshot 51

    The function should then work correctly.

    Include thousand separators on payment amount field? Image 3 Screenshot 62

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