From Memento Database Wiki
Revision as of 06:55, 24 July 2016 by Admin (talk | contribs)

Jump to navigation Jump to search

Creating and editing a library

What is the template library?

The template library is a set of pre-defined forms allowing quick database creation based on thirteen popular field layouts. The fields can then be customized, removed or added to suit user preference. Within the template library you have additional options to create a blank database, browse the online catalogue of thousands of user uploaded templates or import a database that is synced with Google Drive allowing sharing of databases over multiple devices.
To access the templates library, select the + option from the main Memento interface followed by Add Library.

Can another "Memento" user access a template from my library?

Yes, simply select the relevant library , select context menu > Edit the library. Using the share button at the top right, name the template, select the related category and give a small description to help others.
Additionally, within the library edit menu, context menu > Export, choose a suitable name and click save. This creates a .template file which can later be transferred using a file management application.

Can I change the type of a field?

The only way a field type can be changed is during creation, once a field type is locked in there is no way of changing it.
Pro Tip: If a field type does need to be changed, why not create a new field and field type, sync the database with Google Drive, copy the data and re-sync back to Memento.

Can the value of one field affect the visibility of the other fields when creating or editing an entry?

Yes, if you have a field with multiple choices (String Values & Multi-select Values) you can enable dependences based on the multiple choice.
To enable dependencies, do the following:

  1. Create a field with a multiple choice value (example: Gender, with the values, M|F)
  2. Create another field, select "Dependencies of the field" followed by Add a dependency
  3. Select the visibility of the field based on which multiple choice value is selected. (example: M)

Now when the corresponding multiple choice is selected, the previously hidden dependent fields become visible.

Can I create relationships between libraries?

Yes (partially), when your creating or editing a library:

  1. Select field type Link to entry
  2. Within Advanced Parameters > Select the library

This allows manual selection of records from the linked library.

Can multiple fields be visible on the records list?

Yes, Memento can hold four field functions on the record list: Entry Name, Entry Description, Entry Status & Thumbnail.
Each function places the results is a specific area within the record view. The diagram shows the field layout, the default regular field doesn't appear on the list and can only be viewed within the individual record.

Can I attached a thumbnail to my records?

Yes, if you setup a field with an image type. When selected, the Thumbnail field function becomes available and appears at the left side of the field layout.

Working with entries

Can I search using wildcards?

Yes, wildcards can be used for partial word searching. By using the asterisk symbol ( * ), you can generate a wildcard search and find specific words throughout a record.
Here are some examples:

  • String Result: Memento is the best database application on android
  • Search: Memento* (finds any field beginning with 'Memento')
  • Search: *database* (finds 'database' throughout the field)
  • Search: *best* *application* (finds fields containing both 'best' and 'application')

Can I search libraries using barcodes?

Yes, before you can scan barcodes you must first:

  1. Install “Barcode Scanner” by ZXing Team (also available to download through Memento interface).
  2. Setup a library with the Barcode field type

When the above criteria has been filled, open the context menu > Barcode search then scan the barcode.

Can I copy an existing entry?

Yes, you can copy an entry by opening the relevant library:

  1. Long press the required entry > Copy
  2. A new record is created using existing data (edit if applicable) > Press Done.

Can I send an entry via email?

Yes, entries can be sent by opening the relevant library:

  1. Long press the required entry > Send
  2. Select your preferred email client (Gmail, Outlook, etc.)
  3. Enter recipient(s) and send

Formatting options. You can customize what information is displayed when using this feature by:

  1. Open menu within library > Send all > Formatting...
  2. Select what information you want from which field

Commonly used settings can be stored as a template by selecting the “+” at the top left and naming the template

Is it possible to create a checkbox that is viewable within the library list view?

Yes, this can be done during field creation (or editing):

  1. Create a field using the boolean field type
  2. Within the "Where you can edit" select the option "list entries"

The checkbox will appear at the left of the record allowing selection within the list view.

Where are the images attached to entries stored?

  1. Within Memento’s main interface, access the context menu > Settings
  2. Within the General sub-section > File Storage
  3. Select File storage folder.

My device doesn't have enough free internal memory, can I move the database to the SD card?

Yes, you can move the whole database:

  1. Within Memento’s main interface, access the context menu > Settings
  2. Within the General sub-section > Database Location > Select SD Card

How do I change the sort order from ascending to descending?

Within the related Memento library:

  1. Open context menu > Sort
  2. Select the down triangular arrow of the related field and reverse to an up arrow > Select Save

What limits are there on the number of records I can store?

There are no limitations within Memento, however, the maximum number of records are dependent on hardware restrictions and available storage space.
Larger lists (for example: 10,000 records) will require longer loading times to populate and can be optimize by removing some details from the field layout.


If I don’t like the light theme can I change it?

Yes, there are two theme’s available, these can be alternated from the main interface:

  1. Access the context menu > Settings
  2. View sub-section > Theme > Black Theme

Can I create my own icons for the library?

Yes, any image available on your device can be used as an icon:

  1. When creating or editing a library, touch the icon in the upper left corner
  2. At the bottom select Create your own icon > Select image for icon

Can I change the Memento font size?

Yes, there are 5x customizable font categories:
Entry name, Entry description, Entry status, Field name & Field Value, these can be accessed through:

  1. Within Memento’s main interface, access the context menu > Settings
  2. View sub-section > Font size

Can I open a library from my devices home screen?

Yes, it’s possible to create shortcuts to individual libraries. Within the related Memento library:

  1. Open library > menu > Create Shortcut

This places the library shortcut (including its icon) on the next available space on the devices home screen.

Import, synchronization and backup

Can I import my CSV data into Memento?

Yes, but before you import the data you must ensure:

  • The CSV file must be placed into the Memento directory
  • Memento fields are setup with exactly the same headers as the CSV

To begin the import:

  1. Within the related Memento library > Open context menu > Settings
  2. Data operations sub-section > Import from CSV > Select CSV file

Can I view or edit my database on a PC?

Yes, you can use Memento Desktop Version: http://mementodatabase.com/#desktop

Can I share or move my library over multiple devices?

Yes, you can use sync with Memeno Cloud for this.

Do the photos attached to records get uploaded to Google Drive?

Yes, but option isn't enabled by default, to enable it:

  1. Within your library open context menu > Settings
  2. Google Docs sub-section Synchronizing Files > Select "Google Drive"

The date/time doesn't display correctly when I sync with Google Drive, is there a fix?

Yes, you can format the date format by doing the following:

  1. Within the main Memento interface > Settings
  2. Under Settings Import/Export/Sync > Select Date Format
  3. Change setting to Current Locale

How do I fix the 400 Bad Requested error during sync with Google Drive?

This error usually occurs when using special characters within the field name, ensure you have the latest version of Memento installed. If the latest update is unable to resolve the problem, try searching and removing special characters from the library (and try only letters & numbers).


Can I use calculations for multiple fields?

Yes, Memento can perform an array of calculations:

  1. Within the library creation, add a Calculation field type
  2. Within the Expression sub-section add either field or function and operator(s)

An example (quantity x price): #{price} * #{quantity} the resulting field would be the total.

Can I find the total value for a specific field within a library?

Yes, Memento can display the sum total of a specified field:

  1. Within the library edit screen, select Aggregation tab > click on + button.
  2. Select the function ("Sum").
  3. Select the field required.

Memento allows for a custom string to be displayed (example “Total:”) and can be aligned left or right and is displayed at the bottom of the library list view

Can I perform calculations with dates & times?

Yes, there are a few formulae that can be used to calculate dates:

  • To calculate a date by adding days, months or years to a given date use: dateadd(#{date1},d,m,y) where #{date1} is the value of a date field and d,m,y are integers.
  • For date/time calculations use: dateadd(#{datetime1},s,m,h,d,m,y) where #{datetime1} is the value of a date/time field.
  • To calculate the number of days between two dates, use: datediff(#{date1},#{date2})
  • To calculate the number of seconds between two date/time values use: #{datetime1}-#{datetime2}


What permissions does Memento use on my device?

There are three main permissions currently used for Memento:

  1. Your Personal Information: for contacts fields
  2. Your Location: For Google Maps co-ordinates
  3. Your Accounts: To allow sync with Google Drive


Is it possible to encrypt a library?

Yes, you can encrypt your library by doing the following:

  1. Within the library, open menu > Protection
  2. Enter master password twice and OK to confirm
  3. Tick the Encrypt the contents box and OK to confirm

String fields will be encrypted using AES and searching encrypted entries is disabled.