Synchronizing data: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
mNo edit summary
Line 43: Line 43:


; New MEMENTO_ID column
; New MEMENTO_ID column
: In the Google Sheet, an additional column will be created, with a title of '''MEMENTO_ID''' to enable matching of rows to entries in Memento. '''Do not modify or delete this column.'''
: When the link to Google Sheets is created (called ''binding''), an additional column will be created in the Sheet, with a title of '''MEMENTO_ID''', to enable matching of rows to entries in Memento. '''Do not modify or delete this column.'''


; Matching locale settings
; Matching locale settings
: The Locale setting on your device should match the locale setting in Google Sheets.
: The locale setting on your device should match the locale setting in Google Sheets.


; Editing the same rows/entries
; Editing the same rows/entries
: If you edit the same entries in Memento and Google Sheets, you will be offered to choose which version is correct.
: If you edit the same entries/rows in Memento and Google Sheets, you will be prompted to choose which version is correct.


; Adding a new field
; Adding a new field
Line 57: Line 57:
: All entries in the Google Sheet should follow one after another. There should be no empty rows.
: All entries in the Google Sheet should follow one after another. There should be no empty rows.


; Field types for synchronization
; Some one-direction-only field types
: Memento allows you to synchronize fields of all types.<br/>However, Calculation, JavaScript, & Contact fields are synchronized in one direction only - from Memento to Google.
: Memento allows you to synchronize fields of all types.<br/>However, Calculation, JavaScript, & Contact fields are synchronized in one direction only &mdash; from Memento to Google.


== Synchronization between two or more devices without the Memento Cloud, using Google Sheets ==
== Synchronization between two or more devices without the Memento Cloud, using Google Sheets ==

Navigation menu