Library: Difference between revisions

From Memento Database Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
(42 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div align="right"><small>''&laquo; as of 2016-08-25, editions Mobile 3.9.7, Desktop 1.0.3 &raquo;''</small></div>
{{Stamp|2016-12-03|4.1.0|1.0.7}}
-----
In Memento, the fundamental data structure is the library. A library contains data '''''[[Entry|entries]]''''', each of which is made up of typed '''''[[Field|fields]]''''' each of which contains a value.
In Memento, the fundamental data structure is the library. A library contains data ''[[Entry|entries]]'', each of which is made up of typed ''[[Field|fields]]'' each of which contains a value.


The set of a library's fields may be subdivided into ''pages''. By default, fields fall into the page named "MAIN".
Memento is relational; a library is equivalent to a '''table''', and an entry is equivalent to a  '''row'''. Libraries can be linked together in similar fashion to relational tables.
 
The set of a library's fields may be subdivided into '''''pages'''''. By default, fields fall into the page named "MAIN". Fields may be again subdivided by '''''subheaders''''', which allow visual separation within a page.


When a value is stored for some field types, an external file is created or referenced, so the user's database consists of his or her libraries and its associated files.
When a value is stored for some field types, an external file is created or referenced, so the user's database consists of his or her libraries and its associated files.


In addition to fields, a library can contain ''[[Aggregation|aggregation functions]]'' to be displayed in entry lists.
In addition to fields, a library can contain '''''[[Library Edit screen#AGGREGATION tab|aggregation functions]]''''' to be displayed in entry lists.
 
A library can also be set up to ''[[Autofill]]'' certain fields from Internet-based sources.
 
Libraries may be encrypted to protect the privacy of their contents.
 
The set of a user's libraries may be subdivided into ''groups''. By default, libraries fall into the group named "My libraries".
 
In the Mobile Edition, libraries are stored locally and may or may not be synchronized with [[Cloud storage and Teamwork|the Memento Cloud]] along with their associated files. The Desktop Edition, however, works on libraries and files stored in the Memento Cloud.
 
Libraries may be imported from and exported to comma-delimited (CSV) files, which are often exported from or used to then import into other database products or spreadsheet file formats.
 
If the user is logged into a Google account, his or her libraries may be synchronized with Google Sheets files stored on the user's Google Drive. To do this, the library must already exist, so if the user wants to create a new library from a Google Sheet, the user must first create the library and its fields to match those of the Google Sheet and then set up the new library to synchronize with the Google Sheets file.
 
== Library Edit Screen ==
 
The Library Edit Screen comprises four tabs.
 
=== MAIN ===
 
The MAIN tab allows the user to set the following settings.
 
; Color of library
: One of 20 colors may be chosen from a palette to be used as the color of the library's tile on the Library List screen.
 
; Put on the tile
: Any or all of 4 pieces of information may be selected to be placed on the library's tile on the Library List screen: library icon, number of entries, editing time, and Add Entry button.
 
; Entry Name
: Names of defined fields, if any, are displayed, and any or all of them may be selected to comprise the Entry Name, when those fields' values are concatenated using a space separator.
 
; Entry Name is unique
: Set to Off by default, this may be set to On to specify that the Entry Name is to be unique.


; Entry thumbnail
A library can also be set up to '''''[[Library Edit screen#AUTOFILL tab| autofill]]''''' certain fields from Internet-based sources.
: Names of defined Image fields, if any, are displayed, and any one (or none) of them may be selected to function as the entry's thumbnail image on the Entry List screen.


; Entry color
[[Library Protection|'''Libraries may be password-protected and encrypted''']] to protect the privacy of their contents.
: Names of defined single-value selection (Single-choice List or Radio Button) fields, if any, are displayed, and any one (or none) of them may be selected to determine the color of the entry on the Entry List screen.


=== FIELDS ===
The set of a user's libraries may be subdivided into [[Library Groups|'''''groups''''']]. By default, libraries fall into the group named My Libraries.


The FIELDS tab ...
In the Mobile Edition, libraries are stored locally and may or may not be synchronized with [[Cloud storage and Teamwork|'''''the Memento Cloud''''']] along with their associated files. The Desktop Edition, however, works on libraries and files stored in the Memento Cloud.


=== AGGREGATION ===
Libraries may be [[Importing and exporting data|'''imported from and exported to comma-delimited (CSV) files''']], which are often exported from or used to then import into other database products or spreadsheet file formats.


The AGGREGATION tab ...
If the user is logged into a Google account, his or her libraries may be [[Synchronizing data|'''synchronized with Google Sheets files''']] stored on the user's Google Drive. To do this, the library must already exist, so if the user wants to create a new library from a Google Sheet, the user must first create the library and its fields to match those of the Google Sheet and then set up the new library to synchronize with the Google Sheets file.


=== AUTOFILL ===
== See Also ==
'''[[Libraries List screen]]'''<br/>
'''[[Library Edit screen]]'''


The AUTOFILL tab ...
[[Category:en]] [[Category: Overview]]

Revision as of 14:08, 17 August 2021

« Page as of 2016-12-03, editions Mobile 4.1.0, Desktop 1.0.7 »

In Memento, the fundamental data structure is the library. A library contains data entries, each of which is made up of typed fields each of which contains a value.

Memento is relational; a library is equivalent to a table, and an entry is equivalent to a row. Libraries can be linked together in similar fashion to relational tables.

The set of a library's fields may be subdivided into pages. By default, fields fall into the page named "MAIN". Fields may be again subdivided by subheaders, which allow visual separation within a page.

When a value is stored for some field types, an external file is created or referenced, so the user's database consists of his or her libraries and its associated files.

In addition to fields, a library can contain aggregation functions to be displayed in entry lists.

A library can also be set up to autofill certain fields from Internet-based sources.

Libraries may be password-protected and encrypted to protect the privacy of their contents.

The set of a user's libraries may be subdivided into groups. By default, libraries fall into the group named My Libraries.

In the Mobile Edition, libraries are stored locally and may or may not be synchronized with the Memento Cloud along with their associated files. The Desktop Edition, however, works on libraries and files stored in the Memento Cloud.

Libraries may be imported from and exported to comma-delimited (CSV) files, which are often exported from or used to then import into other database products or spreadsheet file formats.

If the user is logged into a Google account, his or her libraries may be synchronized with Google Sheets files stored on the user's Google Drive. To do this, the library must already exist, so if the user wants to create a new library from a Google Sheet, the user must first create the library and its fields to match those of the Google Sheet and then set up the new library to synchronize with the Google Sheets file.

See Also

Libraries List screen
Library Edit screen