appwiki:googledrive [ShiningWiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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
  - 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 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 

  * Customize Google Form embed looks
    * by default, the built-in customize features in Google Form still make it look like a google form.
      * like this, http://www.techrepublic.com/article/google-forms-customize-colors-images-and-fonts/
    * deep customization to make it seamlessly fit into your web style, you can check this tutorial
      * https://www.youtube.com/watch?v=58eY-XzECOg
      * https://www.youtube.com/watch?v=FfOx9j_Y5Wg

===== Customize Google Form =====

  * Other than the form, google form can insert 
    * image block
    * text block
    * video block

  * To Share the form to fill by people
    - click Send button and check short form link (so that "Request Edit Access" text button is not on the top right corner)

  * Advanced Form notification
    * https://chrome.google.com/webstore/detail/advanced-form-notificatio/dgfgjiiggmkinlbnpppplbdkffacigki?hl=en
    * 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.

===== 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