I understand, but let’s be honest - Airtable is designed to be more database and less spreadsheet. If it weren’t it would be a spreadsheet and you’d still be using Excel.
The vast majority of users, use cases, and data in SMBs (small and medium-sized businesses) for database operations are generally cast in dollars and cents, integers, fractions with three digits of precision, and of course time with 1 second of precision. As such, any failure to address more complex capabilities beyond these basics probably doesn’t rise to the level of glaring oversight in my view.
Not sure if you’re aware but almost every vastly more powerful (and more expensive) database struggles with scientific notation and conversions at varying degrees.
I [too] would like to see milliseconds and scientific notation would be nice as well. But let’s remember this is a free system with a higher paid tier for more records. It’s simply not an ideal place for precision time protocols (PTP) or complex mathematics, right?
And should you desire really complex math or PTP, there are ways to do it with code either in script blocks or in custom blocks. Custom blocks also come with the ability to inject libraries that embrace complex math and scientific notation.