How to comma separate the Number field?

Yes, but I wold also like to know how i use comma to separate decimals in the field "Taxas" for example, which is a user inpt

Hi Daniel,

Thanks for reaching out to Jotform Support. Unfortunately, adding a comma separator in the Number field is impossible. I suggest adding a Form Calculation widget and then reintegrating your Google Sheets integration. Let me show you how:

1. In Form Builder, add a Form Calculation widget and enter the formula shown in the screencast below.
2. Next, hide the Form Calculation widget you added. Right-click on the widget and select Hide.

Since it will not automatically add a new column to your Google Sheets, you need to reintegrate Google Sheets. Here's how:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.

2. In the Settings menu, click on the Integrations option on the left side of the screen.

3. Select the Google Sheets integration.

4. Then, click on Remove Integration, and then Yes, Remove!

5. Now, let's connect the Google Sheets Integration again:

6. Now, select Google Sheets and connect your Google account. 

7. Select an option.

8. Choose your form fields including the Form Calculation you added. 

9. I unselect the Taxas so it only maps the Form Calculation widget to the Google Sheet but that's up to you. You can select both.

10. Click on Save, and that's it, you're done.

Checkout the screenshot below to see my result:

Additionally, if you want just put a comma separator in the Taxas field itself. You need to replace the field with a Short Text element and enable the Input Mask feature. Please note that deleting a field will also delete its data. Please make sure to download your submissions first. Let me show you how:

1. In Form Builder, add a Short Text element.
2. Click the Gear icon and toggle On the Input Mask option under the Options tab.
3. Enter #(depends on the number of numbers) and a comma to separate the numbers.

You can check our guide about Getting Started With the Basics of Input Masking to learn more.

Let us know if you have any other questions.