You need to sign in to do that
Don't have an account?

How to remove comma from Number field
Hi,
I have a number field (Number, 0) but when i put valuee 10000 in it it will diplay it as 10,000 i want to display it without comma.
I have selected number field because i need to select Max number from it and add 1 in Max number for new entry.
Can any body help me how i can do it.
Thanks,
Faraz
I have a number field (Number, 0) but when i put valuee 10000 in it it will diplay it as 10,000 i want to display it without comma.
I have selected number field because i need to select Max number from it and add 1 in Max number for new entry.
Can any body help me how i can do it.
Thanks,
Faraz
Create a new custom field, where type is "formula" and the formula return type is "text".
In the formula, use the TEXT() function, and pass the existing number field value into this formula. For example, if your number field is MyNumber_c then your formula would be: TEXT( MyNumber_c )
Your users will enter values into the existing number field, but you can use the formula field (which doesn't display thousands separators)
And don't forget to mark this answer as best, if answer this helps you :-)
--
Regards,
Grazitti Team
Web: www.grazitti.com
All Answers
Create a new custom field, where type is "formula" and the formula return type is "text".
In the formula, use the TEXT() function, and pass the existing number field value into this formula. For example, if your number field is MyNumber_c then your formula would be: TEXT( MyNumber_c )
Your users will enter values into the existing number field, but you can use the formula field (which doesn't display thousands separators)
And don't forget to mark this answer as best, if answer this helps you :-)
--
Regards,
Grazitti Team
Web: www.grazitti.com
You can do this by creating Text field, I think for Number field you are querying for Max(Number) , so for text field you can retrieve last created record, retrieve value of string and convert the string into integer using integer.valueof(s); and add 1 in it.
If this solves your problem, kindly mark it as the best answer.
Thnaks,
Vatsal
I am very glad that you are very active in Forum.
I want to ask you if there is any way through trigger to hide a field.
If we can do that, then in the above senario, he can take a number field and then a text field field with formula displaying the same number which is entered in the number field. After save he have to hide that number field through trigger so that in the front end he can show up only one field. He can also perform his calucations on number as usual..
What do you say???
But after entering the number on click on save formula runs and text field will be displayed with that number with out cama.
Then trigger have to hide Number field after insert.
So its better dont give access to user to entering the value. Update the field using trigger only, take the last value and add 1 in it.
Or you can create a visulforce page which contains number field, which we will call on edit button and after saving display another page which contains formula field.
To display a number without a comma, convert the field data type from a Number to Text. If you want to prohibit A-Z characters then create a validation rule to make sure only numbers are entered into this new field.
You don't need a number field to find the Max value. Instead you would convert the text to a number and then find the max value by using the Value(Text) formula in your calculations. The Value(text) function converts a text string that represents a number to a number.
> If you want to prohibit A-Z characters then create a validation rule to make sure only numbers are entered into this new field.
Font Generator (https://fancyfont.allinhindi.co.in/" target="_blank)
Regards: driving checklist (https://www.nationalaccidentsupportline.co.uk/checklist-new-drivers-check-driving/)
LiteBlue (https://www.liteblue.app/)
if you want to download full screen WhatsApp Status then visit - Full Screen Status WhatsApp Status Download (https://fullscreenstatus.in)
Whatsapp Status Video (https://statusour.com)
New Status Video (https://pagal4status.com)
Liteblue (https://liteblue.tech/)
For ERP Software visit ERP Software UAE (https://erp-software-uae.ae/)
Thanks from ERP Software Dubai (https://www.penieltech.com/erp-software-uae-dubai.php) - Team