Problem:
Number and Formula fields don’t handle very large values correctly. Integers with ~15+ digits get rounded, and values around 1e21 are forced into scientific notation. This makes it impossible to store or display exact large numbers or IDs.
Steps to reproduce:
2. Enter 1234567890123456 in a Number field → the last digits change.
4. Enter 1000000000000000000000 (1e21) → the value is shown in scientific notation, and formulas return the wrong number.
Expected:
Large numbers should be stored and displayed exactly, or there should be a way to output them as text to preserve precision.
Actual:
Numbers are silently rounded and displayed in scientific notation with no option to disable.
Impact:
Critical workflows that depend on exact large integers (finance, science, IDs, ETL) break due to inaccurate values.
Request:
Support a high-precision/decimal type or add a setting for formulas/fields to preserve digits exactly (with optional sci-notation display toggle).
Problem:
Number and Formula fields don’t handle very large values correctly. Integers with ~15+ digits get rounded, and values around 1e21 are forced into scientific notation. This makes it impossible to store or display exact large numbers or IDs.
Steps to reproduce:
2. Enter 1234567890123456 in a Number field → the last digits change.
4. Enter 1000000000000000000000 (1e21) → the value is shown in scientific notation, and formulas return the wrong number.
Expected:
Large numbers should be stored and displayed exactly, or there should be a way to output them as text to preserve precision.
Actual:
Numbers are silently rounded and displayed in scientific notation with no option to disable.
Impact:
Critical workflows that depend on exact large integers (finance, science, IDs, ETL) break due to inaccurate values.
Request:
Support a high-precision/decimal type or add a setting for formulas/fields to preserve digits exactly (with optional sci-notation display toggle).