Include thousand separators on payment amount field?

  • Profile Image
    ACCnational
    Asked 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
    EltonCris
    Answered 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
    ACCnational
    Answered 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
    Chriistian
    Answered 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.