Anyone got any suggestions for dealing with s...

(Marc Dillon) #1

Anyone got any suggestions for dealing with scientific notation numbers in appsheet? I would like scientific notation to be displayed, instead of a very large number. My first thought was just to have them be inputted and text strings, but then a small number of these fields will optimally need to be added together, thus they would have to be numbers. Does appsheet know how to handle this? I can’t seem to find anything info about it.

(Michael) #2

Try converting the columns back to numbers when you have to calculate them. Something like NUMBER([column w/number as text]) + NUMBER([column w/number as text])…

(Marc Dillon) #3

@Michael Good suggestion, didn’t see that function existed yet.