There are 30 types of Fields available in Memento Database. Type defines the sort of data stored in this field, its attributes and the way how it is displayed.
Text is a container for a string. It is a basic field used for titles, names, short lines of textual information. While adding a text field, you can define its default value, allow one or several lines for a text, add a possibility to autocomplete the data depending on the previous entered values and define whether this field is required or optional.
Integer is used for positive, negative or zero integer numbers. The maximal absolute value is 2147483647. While adding it, you can define the default value: the specific one, the value from the previous entry or incremented value from the previous entry. Also, you can add a “calculator” button to integer field in order to make it easier for a database user to add and edit data. In addition, you can choose the unit of measure for the field; add a separator for big numbers and define whether the field is required or optional.
Real number is used for rational numbers. It has almost the same properties as an integer field type, except for the default value: you can set only a specific number here. Also, you can define the increment for this field type to make adding data easier.
Currency is a container for international currency value. While adding this field type, choose one of the predefined currencies from the list. Other properties are similar to real number field type.
Image is used to store photos or pictures. However, you don’t actually add an image file to the database but a link to it. Note that if the image file added to this field was deleted, renamed or moved, a database user should fix the link. While adding a field, you can set the orientation for all images: vertical or horizontal.
Date is a container for a specific calendar day. While adding this field, you can define its default value — the today’s date.
Date/Time is used to add both the calendar date and the specific point of time to one field. While adding this field, you can define its default value — the today’s date and the current time. If one or several Date/Time fields are added to the table, Calendar view is available for it. It shows all the dates from entries and allows you to see the timeline of entries instead of the list.
Time is a container for the certain point of time that is set by hours, minutes and seconds. While adding this field, you can set the current time as a default one.
Checkbox is a container for binary-state data, i.e. it has two possible values: true or false. Unlike other field types, this one can be edited from the compact library view, so a database user doesn’t need to open a field to check or uncheck it. This possibility is optional and can be set while adding or editing this field.
Single-choice list is a container for several options set as lines of text. A database user can choose only one option from this list. Unlike other field types, this one can be edited from the compact library view, so a database user doesn’t need to open a field to choose something from the list. This possibility is optional and can be set while adding or editing this field.
Multiple-choice list is a container for several options set as lines of text. A database user can choose as many options as needed. This field type can be edited from the compact library view just like the single-choice list.
Radio buttons has the same properties as a single-choice list but another representation.
Checkboxes allow you to add a group of checkbox fields at once. This field type has similar properties as a multiple-choice list but another representation.
File is used to store any data file you need to attach. However, you don’t actually add a file to the database but a link to it. Note that if the file added to this field was deleted, renamed or moved, a database user should fix the link.
Rating is used to add a kind of assessment for an entry. The maximal score is 10, but you can set a smaller maximal value.
Password is a container with a text line to add a password for an entry. While entering data to this field, it’ll be hidden in the Library.
Phone is a textual container for a phone number. Once the phone number is added to an entry, you can click it to launch the default phone app.
Hyperlink is a textual container for a link. Once it is added to an entry, you can click it to launch the default browser.
Email is a textual container for an email address. Once it is added to an entry, you can click it to launch the default mailing client.
Link to Entry allows adding relationships between the current entry and the entries from other libraries. You can set many-to-many, one-to-many or one-to-one links while adding this field.
Contact is a link to the contact from an address book. The data can be filled from mobile app only.
Barcode is a container for a textual data interpreted as a barcode or a QR code.
Integer values is a list of integer values. While adding this field, you can define the start and end number. While adding an entry, a database user can choose a single one number from the list.
Audio is used to store any audio file you need to attach. However, you don’t actually add a file to the database but a link to it. Note that if the file added to this field was deleted, renamed or moved, a database user should fix the link.
Paint is a container for a picture that a database user needs to create while adding a data. While adding this field, you need to set the default parameters: canvas size, background color, brush size and brush color.
Location is a container for the geographical coordinates. While adding this field, you can choose your current location as a default one. While adding an entry, a database user can locate the point using the Google map.
Calculation is a container for simple calculated expressions. It allows you to add math, logical, date and time or string functions and use other fields as variables. You can set the calculated value while adding this field to the library and test it on any entered link on this stage.
JavaScript is a container for small executed scripts that use the core methods of JavaScript 1.7. The script may consist of several lines and operations, but the value added to the entry is the final result of calculations. The other fields are used as variables here.
Rich text is a textual container that includes formatted data. While adding an entry, a database user can format the data in this fields using different fonts, adding lists or headlines, change the font color and many more.
Subheader is a separator that divides all fields in groups to make it easier for a database user to work with numerous fields and immense libraries.