Add display format options for some data fields when creating library.
Real number: Option to set decimal display precision, without affecting data precision, similar to calculation type fields.
Date: Option to set date display format.
Currency:Option to set a currency symbol (e.g. $) instead of ISO code.
M S commented
I have a result such as 27.04489..... How do I obtain round result 27.05?
SQLite (the database engine used by Memento) provides a function called strftime() to format date and time. Perhaps it could be added to the Memento function list.
Bill Crews commented
Four real numbers and integers:
- magnitude separator on or off setting
- a regional setting default for magnitude separator (and decimal separator)
- a space override option for magnitude separator
- exclusion of magnitude separators from import & export operations
Vadim Nemirovsky commented
This would be nice. MM-DD--YYYY.
Chris Mcgee commented
I need just a month and year option also
I just need a month and year option
TT Rich commented
Option to set decimal display precision, without affecting data precision... yes, would be nice
Some additional ideas for formatting data:
Adding leading or trailing characters (such as units), to numeric data
We could then have a more descriptive display and simpler field names.
"Volume: 10ml" instead of "Volume(ml): 10"
We could dispense with Currency fields altogether, and just use Real Number along with whatever leading or trailing symbols we want, and set the precision we want.
I would like to have date format in the numerical form (dd/mm/yyyy) especially because when displaying the daya base it uses less space (month name is always longer than the month number; eg. "December" vs "12"). Please make available this option. Thanks. Laszlo - Brasil
Bob Hossley commented
I strongly prefer the date format yyyy-mm-dd