Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| appwiki:googledrive [2022/09/13 01:59] – [Google Drive Intro] ying | appwiki:googledrive [2024/03/02 15:52] (current) – [Google Sheet] 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" | ||
| + | | A: Date | B: Status (sold/ | ||
| + | * solution < | ||
| + | |||
| + | |||
| ====== 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 | ||
| + | |||