What’s AppSheet? I will describe it as a more mobile-device-friendly version of GSheet. Within a few clicks, we can setup an app to collect, display, modify data (can be text, date, image…) in a GSheet 💛 In this article, we will create an issue management app using these handy AppSheet…

延畢的那一學期，我申請 10 間 2021 Fall 的 HCI Master，主要是想學習怎麼更好的 "定義問題"，申請的過程中也和很多戰友互改文件、慢慢對於什麼東西要怎麼寫比較有概念了，所以想透過這篇分享一路申請下來的經驗 🚲 接著會主要分享 👉 (建議的) 申請時程 各項文件的注意事項 (SOP, Resume, 推薦信) 我的申請 最最最需要先思考的事… 為什麼要念研 …

In our team, we have a lot of Google Sheets 📃 and we often need to show the same content between sheets. (e.g. 2 Sheets both need data in tab Average Daily Order. One is for internal analysis, another is a report for leaders.) …

In my new company, we have 100+ stores on Google Map, and we are aiming for collecting reviews of all stores for further analysis. In this post, we will use Google App Script (One of my favorite language 💞) to get reviews through Google Business API with 3 steps: Many…

Swinging between both design team and frontend developing team, I am recently dealing with icons, including those drawn by our designers 🎨Hence, this post will guide you to use svg icons in an developer-friendly, easy-to-style method 👩‍💻 Our Goal Enable frontend to apply the same styling logic, especially changing color, among all…

My new company was looking for a way to remind members to punch in/out everyday. As they mainly use LINE, I thought maybe LINE bot can be helpful if I can trigger it to send messages periodically 🤖 In this post, I’ll show you how to achieve this with Google…

I have a database on a GCP VM, Ubuntu 18.04, that will be updated everyday. I want to backup the data on a daily-basis and save it in Google Cloud Storage, which is a safer option in comparison with merely having a local sql file in VM. …

Imagine this, you get super powerful hardware device (In my case, it’s NVIDIA GEFORCE RTX 2080 Ti 💪) We now plan to use it for machine learning 🔅 But wait, there are so many things with different versions to install. …

This time, I finished a Flask backend application running on GCP. As I want to change the virtual machine’s url to Https, we will need Let’s Encrypt, an open certificate authority. We will also use Nginx as our reverse proxy server. We will follow these steps to achieve our goal: …