How to use the commaSeparate to automatically add comma?

I tried using this conditions to make filled field to automatically seperate its number when it reach 999 +.

but when i tried to type on the form, it can only reach 1.000 ,

if i using "Masked Input" widget , we can't do the calculation from that field to another field.

I hope you can understand it, cuz english is not my primary language. Thank you~

Try creating two fields. First field will be your where you input the value and the 2nd field is the one that will capture the commaseparated value.

Here's a sample screencast: 

I hope this helps. Let us know if you have any questions or if you need further assistance. 

but if i create the input field, it will affect my google spreadsheet. What i mean is i only need 1 column with commaseperate function. So i can easily copy paste my own format to other sheet.

How much thousands are you expecting from users to be inputted into the field? If it's only 4 digits, please try using a form calculation field in that case.

Sample:

yes that was the main problem here, if i only use that function it only allow me to do max 4 digit . But still i have other condition that i only want 1 field and can do the calculation from there.

i need the field to have commaseperate with more than 9 max digit with condition : 1 field and we can do calculation from that field. 

You cannot use one field and conditionally change the value in it (in the same field). So, source value field and target value field have to be different if you want to change that value somehow, or this will happen:

So the value will not be able to be inputted.

Aside from what my colleague proposed with form calculation widget, I don't see another way of doing that in the form.

What I would suggest you doing in Spreadsheet (which might be a better solution here) is to format the column directly there, so when data arrive it will be properly formatted.

Please try and let us know if that could work for you.

Thank you!

Yey i did it, no widget needed. What i need to do is only this , Change the decimal place from 2 to 0

Thank you so much for all the help!

Yes, you're absolutely right, I'm sorry I forgot to mention that option!

I'm glad you were able to make it work.

Cheers!