appwiki:googledrive

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
appwiki:googledrive [2021/08/28 08:39] – created yingappwiki:googledrive [2024/03/02 15:52] (current) – [Google Sheet] ying
Line 2: Line 2:
  
   * Google Drive is a set of online applications, including file management, office softwares, data collection and processing tools.   * Google Drive is a set of online applications, including file management, office softwares, data collection and processing tools.
 +
 +====== only sync selected online folder ======
 +
 +ref: https://www.ubackup.com/articles/google-drive-only-sync-certain-folders.html
 +  - Google Drive tab: choose stream files
 +  - click "Open in Explorer" button above, 
 +  - go to and select the folder you want to be always availble offline
 +  - right click > offline access > available offline
 +
 +====== Google Sheet ======
 +
 +**case and solution**
 +
 +  * case: calculate sold sum of all the item with note "from showroom" <code>
 +| A: Date | B: Status (sold/bought) | C: Name | D: Price | E: Note |</code>
 +    * solution <code>=SUMIFS(D2:D, B2:B, "sold", E2:E, "from showroom")</code>
 +
 +
  
 ====== Google Form ====== ====== Google Form ======
Line 29: Line 47:
     * the default email collection and response from Google form can only send people a single text email     * the default email collection and response from Google form can only send people a single text email
     * by install this in your form, you can do HTML email with your own design once people fill the form.     * by install this in your form, you can do HTML email with your own design once people fill the form.
 +
 +===== Google Drive Problem and Fix =====
 +
 +  * Problem: the desktop sync tool is on, but the file is not updated to latest
 +    * solution: in the tool tray icon, pause the sync and resume the sync will fix and get all files updated
 +
  • appwiki/googledrive.1630139987.txt.gz
  • Last modified: 2021/08/28 08:39
  • by ying