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”
| 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
- Customize Google Form embed looks
- by default, the built-in customize features in Google Form still make it look like a google form.
- deep customization to make it seamlessly fit into your web style, you can check this tutorial
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
- 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