Integer format without comma

[salvadormarchan]

Hi All,
I created a field within a certain table having an integer data type. I tested the value and it automatically provides a comma after every 3 decimal places.

Question: How do I disable this? We don't want the comma. I tried looking at the wiki (and googled it) but no avail.

Thanks,
Dor
(Day 45)

[Bastian Pawlik]

Hi salvadorsarchan,

although it is a decade after you asked for another solution: Use "format=none" as dictionary attribute will remove the thousand-separators on the integer field.

Best regards,

Bastian

[Scot_Soares]

mark.stanger

Curious if there are other options. I'm looking to create a field that will hold invoice numbers. We don't want the commas in this case but would like to enforce that end users can only enter numbers in the field. Perhaps we need to set this as a string field and set up a business rule or client script to enforce that only numbers are entered?

Thanks for any thoughts on this!

Scot

[Mark Stanger]

You can set up a script to validate that the field only contains numbers. This could be done in an onChange or onSubmit client script, or a 'before' business rule. Something like this would work in a client script...

if(/\D/.test(g_form.getValue('YOUR_FIELD_NAME_HERE')){
   alert('Field must only contain numbers'); 
}

[russell_gabriel]

A simple solution for this, say when you want/need to use an integer field for a calculation and thus don't want the comma's, is to add the attribute "format=none" to the dictionary entry. This will drop the comma allowing the calculation to work.

[vince591]

Thanks Russell,

I had a similar issue with integer formatting.