How do I format a field to display in a currency format

  • Schoemans
    Asked on April 15, 2025 at 3:30 AM

    Hi Jotforms

    I have a form that uses an input table as the data source, and I’m using calculation widgets to display the total values below the table. I would like to apply an input mask to these total fields so that the values are displayed in a proper currency format with thousands separators.

    Jotform Thread 26193941 Screenshot
  • Mahmoud JotForm Support
    Replied on April 15, 2025 at 8:24 AM

    Hi Schoemans,

    Thanks for reaching out to Jotform Support. You can use the Comma function via the Calculation widget to show the numbers with a thousand separator. Let me show you how to do this:

    1. In Form Builder, click on the Wand icon of the Calculation widget.
    2. In the menu on the right side of the page, click on the Function icon and search for CommaSeparate and add it to your calculations.
    3. Include the current calculation inside the CommaSeparate and click on Save.

    How do I format a field  to display in a currency format Image 1 Screenshot 30

    This is the result after updating the calculation:

    How do I format a field  to display in a currency format Image 2 Screenshot 41

    Give it a try and let us know how it goes.

  • Schoemans
    Replied on April 16, 2025 at 2:43 AM

    Hi Jotforms


    The solution worked thank you for the assistance.

Your Answer