-
fauzanabidAsked on July 16, 2018 at 10:04 PM
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~
-
Jed_CReplied on July 16, 2018 at 10:53 PM
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.
-
fauzanabidReplied on July 16, 2018 at 10:59 PM
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.
-
Jed_CReplied on July 16, 2018 at 11:23 PM
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:
-
fauzanabidReplied on July 16, 2018 at 11:43 PM
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.
-
fauzanabidReplied on July 17, 2018 at 1:03 AM
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.
-
Nik_CReplied on July 17, 2018 at 2:33 AM
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!
-
fauzanabidReplied on July 18, 2018 at 12:24 AM
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!
-
Nik_CReplied on July 18, 2018 at 1:40 AM
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!