I’ve been thinking about this on and off all day I couldn’t find a way to make, as an example, 245.1 just show 245
I know that we can use zero decimal places so the value in the table shows “245” but when you click into it, it’s really “245.1”
I guess your just trying to remove the .1
Validation and Conditional rules don’t help for this situation. I even tried to see if I could do something with Integromat, before going to the cinema to see the new bond film
Round or ceil are a couple of useful functions but they just round the value up or down to the nearest whole number.
The reason I asked if there was a numeric range is that I have similar situation with a ceramic tiling company and the staff were often putting decimal places into the values.
The quantity was never going to be higher than 50/60 in my case, so I added a related table with numbers 1-100 and connected it to the parent table as a searchable field.
It seems a bit of a waste of 1,000 records to do the same, however, with the connection set as searchable users can type “23X” and get the range from 230-239 quickly to select the correct whole value.
From memory, I then had a number field with a conditional rule looking at the field so I capture the number as it was being used for a calculation.
Not sure if you could get around this with code but as I’m not a coder the above is all I’ve got