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.
Marc_Dillon (Marc Dillon) #1
Michael (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])…