Differences

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

@@ Line 1: / Line 1: @@
+====== 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