When I use my scanner to enter barcode numbers (889698219730), when I click off of it, it looks like this 8.987e+11.
What am I doing wrong?
This is a the Layout field type default for numbers. In the Inspector under Data Formatting, it defaults to General which converts numbers greater than like 8 digits to exponential notation. Change that to "As Entered" and you'll see it correctly. Or you can make the field text and you won't have this problem.
I knew there was a setting I was missing. Thanks so much.
You may go ahead and mark an answer as correct, or the entire thread as "Assumed Answered". Then other will know this is solved!
Note that a number field will remove leading zeros from the entry: 008453 will be stored as 8453. If there is a likelihood of leading zeros, store them in a text field.
Retrieving data ...