appwiki:googledrive

Google Drive Intro

  • 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

  1. Google Drive tab: choose stream files
  2. click “Open in Explorer” button above,
  3. go to and select the folder you want to be always availble offline
  4. right click > offline access > available offline

Google Sheet

case and solution

  • case: calculate sold sum of all the item with note “from showroom”
    | A: Date | B: Status (sold/bought) | C: Name | D: Price | E: Note |
    • solution
      =SUMIFS(D2:D, B2:B, "sold", E2:E, "from showroom")

Google Form

  • Google Form App works together Google Sheets App to collect data from people online and store in a spreadsheet format
  • Google Form can be viewed in a standalone page or embedded in your web page
  • Other than the form, google form can insert
    • image block
    • text block
    • video block
  • To Share the form to fill by people
    1. click Send button and check short form link (so that “Request Edit Access” text button is not on the top right corner)
  • 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