appwiki:googledrive

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
Last revisionBoth sides next revision
appwiki:googledrive [2022/09/13 01:59] – [Google Drive Intro] yingappwiki:googledrive [2024/03/02 15:52] – [Google Form] ying
Line 10: Line 10:
   - go to and select the folder you want to be always availble offline   - go to and select the folder you want to be always availble offline
   - right click > offline access > available 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 junk box")</code>
 +
 +
  
 ====== Google Form ====== ====== Google Form ======
Line 37: 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.txt
  • Last modified: 2024/03/02 15:52
  • by ying