credit card number
I created a field for a number, but when I type in a number of 16 digits it shows a weird number like 3647389E+15
Right click on the field (while in layout mode) and choose Number Format. Then choose Leave data formatted as entered.
Did you click Okay in that dialog? Is the field long enough to show the full 16 digits?
In the Number Format dialog window when you have General Format selected then FileMaker will format the number as you described. When you choose the Leave data formatted as entered then it will show the full number.
In a sample that I created here when I enter 1234567890123456, I get 1.2346e+15 when General Format is checked. But when Leave data formatted as entered is checked then I get 1234567890123456.
Leave data formatted as entered should work. Nevertheless, I suggest you change the field's type to Text - because that's what it is.
Incidentally, you might also check the legal implications of storing credit card numbers.
TKnTexas wrote:My general practice is to use a text field and restrict data to numbers. I only use number field type if there will be math done. Or numerical sorting. Otherwise 20 sorts after 1000 instead of the reverse.
Retrieving data ...