Is there a way to format a Short Text field to include $ and comma for data consistency?

  • CIVIC_DealDesk
    Asked on August 16, 2018 at 12:33 PM

    Is there a way to format a Short Text field to include $ and comma for data consistency?  Thanks!

  • Richie JotForm Support
    Replied on August 16, 2018 at 1:47 PM

    You can use the Form calculation widget to show $ and comma .

    Just add $ the dollar sign using your keyboard to your Form calculation widget.

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 1 Screenshot 60

    To add the comma to separate hundreds, you can use the  Math Function comma separate.

    Go to your Form calculation widget and click the option button ...

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 2 Screenshot 71

    then go to Math Functions and choose commaseparate().

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 3 Screenshot 82

    sample screenshot: The calculations should be inside your commaseparate.

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 4 Screenshot 93

    Screenshot of the sample form output:

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 5 Screenshot 104

    Sample form:https://form.jotform.com/82275356993975

    Let us know if you have further questions.

  • CIVIC_DealDesk
    Replied on August 17, 2018 at 8:43 PM
    Thanks! I don’t understand the a 0-9 + b 0-9 part. I am not combining/calculating values of two fields. I just want to format the field so input will automatically include commas.
    Christopher Sy
    Deal Desk Manager
    D: 424.336.7925
    NMLS ID 1099109
    http://www.civicfs.com
    [http://gallery.mailchimp.com/e033df581a72b470353232e78/images/b04a8a51-8534-4425-958a-0182beca6521.png]
    Civic Financial Services
    2015 Manhattan Beach Blvd
    Redondo Beach, CA 90278
    ...
  • Mike_G JotForm Support
    Replied on August 18, 2018 at 12:11 AM

    If you are referring to the field A and B in my colleague's sample form, the value of those fields is added to the "total" field.

    1534565411t00 05 54 Screenshot 10

    I hope this helps. Otherwise, please feel free to let us know.

  • CIVIC_DealDesk
    Replied on August 20, 2018 at 11:43 AM
    Thank you. I just want to know how to format a field with comma separator when a number is input. No calculation from other fields involved. Is that possible?
    Christopher Sy
    Deal Desk Manager
    D: 424.336.7925
    NMLS ID 1099109
    http://www.civicfs.com
    [http://gallery.mailchimp.com/e033df581a72b470353232e78/images/b04a8a51-8534-4425-958a-0182beca6521.png]
    Civic Financial Services
    2015 Manhattan Beach Blvd
    Redondo Beach, CA 90278
    ...
  • Richie JotForm Support
    Replied on August 20, 2018 at 12:24 PM

    Yes, just add the comma separate calculation option to your Form calculation question field.

    Here is an example.

    I have a Form calculation field named "a" and I have added commaseparate calculation to its own field.

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 1 Screenshot 40

    Do note also to change your decimal places, I have set mine to 0. Go to your Form calculation settings then options and change the decimal places value.

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 2 Screenshot 51


    Sample screen cast:

    Is there a way to format a Short Text field to include $ and comma for data consistency? Image 3 Screenshot 62


    Sample form:https://form.jotform.com/82275356993975

    Please give it a try and let us know how it goes.

    Thank you.

  • CIVIC_DealDesk
    Replied on August 20, 2018 at 2:43 PM
    Do I have to create an a separate “a” field to accomplish this, and just hide it so it is not visible?
    Thanks,
    Christopher Sy
    Deal Desk Manager
    D: 424.336.7925
    NMLS ID 1099109
    http://www.civicfs.com
    [http://gallery.mailchimp.com/e033df581a72b470353232e78/images/b04a8a51-8534-4425-958a-0182beca6521.png]
    Civic Financial Services
    2015 Manhattan Beach Blvd
    Redondo Beach, CA 90278
    ...
  • Richie JotForm Support
    Replied on August 20, 2018 at 3:00 PM

    No need, you can use your own field. I would suggest using a Form calculation as your field. Do you have a form that you want to place this field?