Write, Bureaucrats, Administrators
275
edits
(Created page with "__TOC__ == 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 o...") |
No edit summary |
||
Line 145: | Line 145: | ||
This error usually occurs when using special characters within the field name, ensure you have the latest version of Memento installed. | 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). | If the latest update is unable to resolve the problem, try searching and removing special characters from the library (and try only letters & numbers). | ||
== Calculations == | |||
=== Can I use calculations for multiple fields? === | |||
Yes, Memento can perform an array of calculations: | |||
# Within the library creation, add a ''Calculation'' field type | |||
# 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: | |||
# Within the library edit screen, select ''Aggregation'' tab > click on '''+''' button. | |||
# Select the function ("Sum"). | |||
# 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} | |||
== Privacy == | |||
=== What permissions does Memento use on my device? === | |||
There are three main permissions currently used for Memento: | |||
# Your Personal Information: for contacts fields | |||
# Your Location: For Google Maps co-ordinates | |||
# Your Accounts: To allow sync with Google Drive | |||
== Protection == | |||
=== Is it possible to encrypt a library? === | |||
Yes, you can encrypt your library by doing the following: | |||
# Within the library, open menu > ''Protection'' | |||
# Enter master password twice and ''OK'' to confirm | |||
# Tick the ''Encrypt the contents'' box and ''OK'' to confirm | |||
String fields will be encrypted using AES and searching encrypted entries is disabled. |