Sunday, October 31, 2021

Online Alarm Clock



Most of us were, or maybe still, working from home. It's one of those new normal where we spend most making a living at home. Though we are in the comfort of our homes, we often stricken with procrastination.

Guilty yet? With no pressure of commuting to the office. No pressure of those prying eyes of your every move. Concealed with all the corners of our house we can never deny that there are times we are off tracked of things to do. 

Complacent or just being lazy?

Here's a convenient way of poking those ears and pay attention to your todo's. Conventional todo list is sometimes boring. Sticky notes seems static and most of times in hidden view. Why not integrate alarm clock with notes. Although we have some mainstream apps out there. But, since we are all in the virtual environment with our PC in front of us most of the time. This tool well surely be of use. 

Check out the app below.

Tuesday, October 19, 2021

Create Online Quiz

test depo


When I started coding with Google Apps Script, this web app was one of those that is very clumsy yet working. I remember developing this one with the intent of providing a skills assessment for my team and other teams in my previous employer.

I've spent many hours creating this one and we did rollout this. The app was misunderstood at that time. As far as I could remember, that was 5 years ago. Today, this app makes even more sense. Especially, with online or virtual classrooms are a necessity. Distributing exams to students online is even more a requirement.

The Goal
  • To create a web based application that could hold multiple exams from different topics/subjects.
  • To have an easy setup of questions. Using google sheets as database.
  • To have a quick turn around of the results.
  • Teachers and proctors can have visibility of the students progress.
I've embedded the app on this article and leave a comment below if you'd like to try and setup an exam. No further development was done in the app. So bare with it if experiencing issues. As of the moment open for those with Gmail accounts.

Sunday, October 17, 2021

Amazon Reviews Scraper



Amazon has the clout in the eCommerce segment. Most the brands, big and small, are crowding the platform hoping to get a pie of the consumer dollars. Selling through this platform is profitable and very competitive as well. So, how to gain advantage in understanding consumer profiles on line and learn how your products fits their needs and behaviors, The most important is understanding there feedbacks.

Star ratings and Reviews
Customer feedback still the key. More reviews means more sales. Yes, but how was the reviews? Good or Bad, 5 star or 1 star? How your product stack up against the competition? Amazon provides access to reviews if you a seller. To your own listing only. So, how would you capture those reviews from other sellers?

Web scraping
A staple and still useful. I'm not going to discuss the Customer Metric analytics. Instead, I'm going to share a tool to small Amazon sellers out there who would like to capture customer feedback and understand there sentiments. Please see link below: