Write, Bureaucrats, Administrators
273
edits
mNo edit summary |
No edit summary |
||
Line 27: | Line 27: | ||
To initiate Sheets synchronization for a library: | To initiate Sheets synchronization for a library: | ||
# Link the library to a new or existing Sheets file on Google Drive by opening the Library Entries List screen and then its Action menu. If the library is already set up to synchronize with a Sheets file, the option will be entitled "Sync with Google Sheets". If not, it will be entitled "Link To Google Sheets". Since we are initiating sync, select ''Link to Google Sheets''. | # Link the library to a new or existing Sheets file on Google Drive by opening the Library Entries List screen and then its Action menu. If the library is already set up to synchronize with a Sheets file, the option will be entitled "Sync with Google Sheets". If not, it will be entitled "Link To Google Sheets". Since we are initiating sync, select ''Link to Google Sheets''. | ||
# A card will appear with | # A card will appear with an option ''Link to new document''. If you want to create a new Google spreadsheet with records from the Memento library, select ''Link to new document''. In this case, a new Google Sheets file will be created on the Google Drive (access to that account required) in the root (My Drive) directory, and a sheet row will be created for every library entry. You can then use Google Sheets to view, edit, add, and delete rows/entries. | ||
# To synchronize changes made in Memento and Google Sheets, open the library's Action menu and select ''Sync with Google Sheets''. | # To synchronize changes made in Memento and Google Sheets, open the library's Action menu and select ''Sync with Google Sheets''. | ||
Line 35: | Line 34: | ||
* All files attached to entries of a library are uploaded to Google Drive, in a folder called Name_library.files | * All files attached to entries of a library are uploaded to Google Drive, in a folder called Name_library.files | ||
* Links to uploaded files are saved in a column of the Google spreadsheet with the name Name_field.http | * Links to uploaded files are saved in a column of the Google spreadsheet with the name Name_field.http | ||
=== Notes === | === Notes === | ||
Line 55: | Line 48: | ||
:; 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. | :; 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. | ||
[[Category:Overview]] | [[Category:Overview]] |