I imported a huge (for me) data file, with 1200 forms, from a Numbers table. It has 26 fields, and the first of them is the catalogue number. I tried to select “number’ as field type, but it does not work. Each form has a catalogue number made up of the year, the month, and a serial number. It looks like this 2020/06-01. It is not accepted as number. I tried variations like 2020-06-01, 2020.06.01 , 2020/06/01, etc, without success. Is the “numbers’ field limited to simple basic numbers ?
Similarly, I found strange that there would be no field for price. This should accept prices in various currencies (US$, C$, HK$, €, £, CHF, etc) in the same field.
Hi Jean,
That’s right. The Number field requires actual numbers that can be used in a mathematical expression. So 2020.06 would work, but not 2020/06-01. That’s text because it has the / and - characters in it.
To get currency, use a Number field and set the Number Format property to Currency and set the Decimal Places to 2 or whatever you’d like.
Thanks,
Brendan
Thank you. I did not mention that this is for a collection of books. And yes, 200606.01 will work. It is a just a serial number, based on the date of purchase, to keep the possibility of sorting the books in chronological order.
As for the price in different currencies, I’ll just keep it in text, and add the 3 letter symbol for the currency (USD, EUR, CHF, etc) placed before the number. That will do.
Thank you for your quick reaction and answer.
Jean
When put into practise, it does not work as easily as that. 200606.01 will not work. I figured I could set year and month first, and then, after the decimal point, a double digit for the serial number within that month. But the decimal point is not accepted. I can only use the whole number, all 8 digits of it, as one number. 20060601 is a bit much to read as a number.
Make sure you set your decimal points on the field to be two, the default is 0.
And also set the Number Format to Decimal. Or the Decimal Places setting will be ignored.
.
