Scripting.One

How to Capture YouTube Videos Closed Caption Texts Using Google Chrome

2026-03-05T02:53:00.000-08:00

YouTube closed captions can be useful for research, documentation, analysis, or creating rough transcripts. While YouTube does not always allow direct subtitle downloads, you can capture the live closed caption text using Google Chrome’s built-in Developer Tools.

This guide explains how to do it step by step.

Requirements

Google Chrome browser
A YouTube video with Closed Captions enabled
Basic copy-and-paste knowledge

No browser extensions or third-party tools are required.

Step-by-Step Instructions

Open Google Chrome
Launch the Google Chrome browser.
Go to YouTube
Navigate to https://www.youtube.com.
Open a YouTube Video
Select a video that supports subtitles or closed captions.
Enable Subtitles / Closed Captions
Click the CC button on the video player to turn captions on.
Make sure captions are visible before continuing.
Open Chrome Menu
Click the three-dot menu (Customize and Control Google Chrome) beside your profile picture.
Go to More Tools
From the menu, select More tools.
Open Developer Tools

Click Developer tools.
Shortcut:
Windows: Ctrl + Shift + I
Mac: Cmd + Option + I

Open the Console Tab
Inside Developer Tools, select the Console tab.
Copy the Script Below
Paste and Run the Script
Paste the script into the Console and press Enter.

The script will now log the currently displayed closed caption text every 1.5 seconds.

How It Works

The script detects the active caption text displayed on the video
It reads the text from the caption container
Every 1.5 seconds, the text is printed in the Console
As the video plays, captions appear in real time in the Console output

How to Save the Captured Captions

You can:

Manually copy the Console output
Select and save logs for short transcription needs
Extend the script to store captions in variables or files

Notes and Limitations

Only captures captions currently visible on screen
Does not retrieve past or future subtitles
YouTube UI changes may affect class names
Best used for short to medium-length videos

Conclusion

This approach provides a simple and lightweight way to capture YouTube closed captions directly from the browser. It is especially useful for quick analysis, note-taking, and research when subtitle downloads are not available.

MathMaster: My First AI-Powered Adventure in Web App Creation!

2025-10-01T22:28:00.000-07:00

As a newcomer to the world of generative AI, I recently embarked on an exciting journey to explore its potential—and the result is MathMaster, a dynamic web app built on Base44 that makes math learning fun and engaging. Powered by AI, this app is my first foray into leveraging cutting-edge technology to create something meaningful. Try it at https://math-master-0b4f05d5.base44.app/ with JavaScript enabled!

Why MathMaster? A Newbie’s AI Experiment

Diving into generative AI for the first time was both thrilling and eye-opening. With Base44’s AI-driven tools, I crafted MathMaster to transform math education. Here’s what makes it special:
AI-Driven Quizzes: Adaptive AI personalizes math challenges—from basic arithmetic to calculus—tailoring them to your skill level with instant feedback.
Smart Visuals: AI-generated animations and 3D diagrams simplify complex equations and geometry, a feature I was amazed to create as a beginner.
Intelligent Tracking: AI analyzes your progress, offering clear insights into strengths and areas to improve—something I found surprisingly intuitive to implement.
Gamified Fun: AI awards badges and powers leaderboards, making learning feel like a game.
Mobile-Friendly: Built on Base44’s AI-optimized platform, it’s fast, free, and works anywhere.

As a first-time explorer of generative AI, I was blown away by how it simplified app development, enabling me to focus on creativity while AI handled the heavy lifting.

Get Started

Open MathMaster in your browser.
Ensure JavaScript is enabled.
Explore AI-powered math learning!

Join the Journey

Tried MathMaster? Share how it’s helping you conquer math! As I continue exploring generative AI, follow for more insights on AI-driven edtech.

The Power of Connection: Insights from Leadership Is Language

2025-01-24T00:57:00.000-08:00

In Leadership Is Language: The Hidden Power of What You Say—and What You Don’t, L. David Marquet redefines the role of language in leadership, emphasizing how words can create connection and drive engagement. Marquet, a former U.S. Navy submarine captain, challenges the traditional "command-and-control" approach, arguing that leadership today is less about issuing orders and more about fostering collaboration.

Central to the book is the idea of replacing "leader-follower" dynamics with "leader-leader" relationships. This shift hinges on the power of intentional communication. Instead of dictating tasks, leaders should ask open-ended questions, encourage thoughtful dialogue, and create a safe space for team members to share ideas. By doing so, leaders build trust and empower others to take ownership, fueling innovation and deeper connection.

Marquet introduces a cycle of "thinking blue" (reflection and creativity) and "doing red" (execution and action), encouraging leaders to balance these modes. Through practical tools and examples, he demonstrates how language can dismantle barriers, unlock potential, and foster genuine engagement.

Ultimately, Leadership Is Language underscores that connection begins with conversation. By choosing words thoughtfully, leaders can inspire collaboration, build stronger teams, and create a culture where every voice matters.

Buy the book here: Leadership Is Language: The Hidden Power of What You Say--and What You Don't

Quantum Computers: Ultimate Questions

2023-12-04T00:18:00.000-08:00

Quantum computers could solve problems in minutes that would take today's supercomputers millions of years

In "The Hitchhiker's Guide to the Galaxy" by Douglas Adams, the ultimate question of life, the universe, and everything is famously revealed to be "What is the meaning of life, the universe, and everything?" The answer, as calculated by the supercomputer Deep Thought, is 42, though the actual question is never known.

When it comes to quantum computers and problem-solving, there are interesting parallels that can be drawn. Quantum computers leverage the principles of quantum mechanics to perform certain computations much more efficiently than classical computers. While they excel at specific types of problems, their application is not universal and depends on the nature of the problem being addressed.

In the context of the Hitchhiker's Guide to the Galaxy, one could draw a parallel between the ultimate question and the challenges that quantum computers are uniquely positioned to solve. Quantum computers are particularly adept at solving complex optimization problems, simulating quantum systems, and factoring large numbers—tasks that would take classical computers an impractical amount of time.

Just as the ultimate question in the Hitchhiker's Guide remained elusive, there are still challenges and limitations to the full realization of quantum computing. The field is continually evolving, and researchers are working to harness the potential of quantum computers for a broader range of problems.

In essence, the connection lies in the idea that both the ultimate question and quantum computing represent a quest for understanding and unlocking the mysteries of the universe—whether that's the meaning of life or the efficient solution to complex problems through advanced computational methods.

Top 5 Black Friday Wishlist

2023-11-16T23:20:00.000-08:00

Tech Marvels:Upgrade your gadgets with the latest in tech! From smartphones to smart home devices, Amazon's Black Friday wishlist promises unbeatable deals on cutting-edge technology.
Fashion Finesse:Revamp your wardrobe with top-notch fashion finds. Whether you're into trendy styles or timeless classics, Amazon's Black Friday wishlist has the perfect ensemble waiting for you.
Home Sweet Home:Transform your living space with home decor, furniture, and kitchen essentials. Amazon's Black Friday wishlist offers discounts that make it easy to give your home a stylish and functional makeover.
Bookworm's Paradise:For the avid readers, Amazon's Black Friday wishlist is a dream come true. Snag deals on the latest bestsellers, e-readers, and book accessories to create the ultimate reading nook.
Fitness and Wellness:Kickstart your health journey with Amazon's Black Friday wishlist for fitness enthusiasts. Whether it's workout gear, fitness trackers, or wellness products, find the tools you need to prioritize your well-being.

Remember to keep an eye on Amazon's lightning deals and limited-time offers to make the most of your Black Friday wishlist. Happy shopping!

Top 10 new technologies 2023

2023-10-01T06:18:00.005-07:00

2023 is almost up and the field of technology have been very interesting for this year. So, before the year is up, Here's top 10 technology that have revolutionized the field

Artificial Intelligence and Machine Learning: These technologies continue to advance rapidly, with applications in areas like autonomous vehicles, healthcare, finance, and more.
Quantum Computing: Quantum computers have the potential to revolutionize computing by solving complex problems much faster than classical computers.
5G Technology: The rollout of 5G networks is expected to enable faster and more reliable wireless communication, paving the way for the Internet of Things (IoT) and smart cities.
Biotechnology: Advancements in gene editing (e.g., CRISPR) and personalized medicine are on the horizon, potentially revolutionizing healthcare.
Blockchain and Cryptocurrencies: These technologies are changing the landscape of finance, supply chain management, and more.
Clean Energy Technologies: Continued developments in renewable energy sources, such as solar and wind power, and energy storage solutions are vital for addressing climate change.
Augmented Reality (AR) and Virtual Reality (VR): AR and VR technologies are increasingly being used in gaming, education, training, and healthcare.
Robotics: Robots are becoming more advanced and are being used in industries like manufacturing, healthcare, and logistics.
Internet of Things (IoT): The IoT is expanding, connecting everyday objects and enabling data-driven decision-making in various sectors.
Space Exploration: Advancements in space technology, including private sector efforts, could lead to new discoveries and commercial opportunities beyond Earth.

VO2 max in Apple Watch

2023-08-13T08:58:00.000-07:00

The integration of VO2 max measurement into Apple Watch has revolutionized personal fitness tracking. VO2 max, a key indicator of cardiovascular fitness, is now conveniently accessible to Apple Watch users. This feature offers insights into one's aerobic capacity and overall health.

Apple Watch calculates VO2 max based on various factors, including heart rate, age, sex, and workout intensity. During outdoor running and walking workouts, the watch estimates VO2 max by analyzing your pace and heart rate data. This information provides valuable feedback on your cardiovascular health and helps you tailor your exercise regimen.

Tracking your VO2 max with Apple Watch allows you to set personalized fitness goals and monitor your progress over time. As your aerobic fitness improves, you can witness the positive impact of your efforts on this important metric.

However, it's essential to recognize that while Apple Watch provides a convenient way to estimate VO2 max, it may not be as accurate as lab-based tests. Factors like environmental conditions and individual variations can affect the readings. Therefore, it's advisable to view the measurements as general trends rather than absolute values.

Incorporating VO2 max tracking into Apple Watch underscores the device's commitment to enhancing users' health and well-being. It empowers individuals to take proactive steps toward better fitness and offers a glimpse into the potential of technology to support a healthier lifestyle.

Top 5 Free-to-Play Racing Games on iOS (2023)

2023-08-13T08:49:00.001-07:00

In the dynamic world of mobile gaming, iOS users continue to be spoiled for choice when it comes to high-quality, free-to-play racing games. These adrenaline-pumping titles offer thrilling experiences, realistic graphics, and engaging gameplay, all without costing a dime. Here are the top five free-to-play racing games on iOS in 2023 that are revving up excitement among gamers:

Asphalt 9: Legends: Renowned for its stunning visuals and arcade-style racing, Asphalt 9 offers an extensive car roster and a plethora of tracks to conquer.
Real Racing 3: With its emphasis on realism, Real Racing 3 remains a favorite. Featuring an array of licensed cars and meticulously detailed tracks, it offers a true-to-life racing experience.
CSR Racing 2: Focused on drag racing, CSR Racing 2 boasts jaw-dropping car customization and boasts a strong online multiplayer mode.
Mario Kart Tour: Nintendo's iconic racing game takes a joyful spin on iOS, allowing players to race as beloved characters through imaginative tracks inspired by the Mario Kart series.
Racing Rivals: This drag racing game stands out for its intense real-time multiplayer duels and a wide selection of cars to tune and upgrade.

With these five stellar options, iOS users can dive into the fast-paced world of virtual racing without spending a dime. Whether you're seeking realistic simulations or whimsical karting adventures, these games offer a variety of experiences to satisfy every racing enthusiast's craving for speed and competition.

20 Reasons Why Your Facebook Account May Get Hacked

2023-07-27T21:47:00.001-07:00

In today's digital age, social media has become an integral part of our lives, and Facebook remains one of the most popular platforms for connecting with friends and family. However, with its widespread usage comes an increasing risk of account hacking. Understanding the potential vulnerabilities can help users safeguard their accounts. Here are 20 reasons why your Facebook account may get hacked:

Weak Passwords: Easily guessable passwords make it easy for hackers to gain unauthorized access.
Phishing: Falling for phishing scams can lead to divulging login credentials to malicious actors.
Malware and Keyloggers: Infected devices can capture login information without your knowledge.
Unsecured Wi-Fi: Logging in from public Wi-Fi exposes your credentials to potential attackers.
Password Reuse: Using the same password across multiple platforms increases the risk of compromise.
Social Engineering: Hackers can manipulate individuals into revealing sensitive account information.
Account Recovery Weaknesses: Inadequate recovery options can be exploited by attackers.
Outdated Software: Using outdated apps or systems may expose known vulnerabilities.
Insider Threats: Trusted individuals with access may misuse account privileges.
Phony Apps: Installing unauthorized third-party apps can compromise your account.
Clickjacking: Hidden malicious links can trick users into clicking and compromising their accounts.
Brute Force Attacks: Repeated login attempts with various passwords until one succeeds.
Account Sharing: Letting others access your account can lead to unauthorized use.
Public Profile Information: Sharing sensitive details openly can aid hackers in impersonation.
Insecure Browser Extensions: Certain extensions may compromise your account security.
Lack of Two-Factor Authentication (2FA): Absence of an extra layer of security leaves accounts vulnerable.
Account Cloning: Hackers may replicate accounts to conduct scams or phishing.
Forgotten Logins: Abandoned accounts might be easier targets if recovery information is outdated.
Third-Party Website Compromises: Using Facebook credentials on untrusted sites may expose your login information.
Data Breaches: Security breaches on Facebook's end can lead to compromised accounts.

Protecting your Facebook account involves staying vigilant, using strong passwords, enabling 2FA, being cautious with links, and staying updated on security best practices. Regularly reviewing and adjusting privacy settings can also minimize the risk of falling victim to hacking attempts, ensuring a safer and more enjoyable social media experience.

How to build site with google apps script

2023-07-08T00:52:00.001-07:00

To build a website using Google Apps Script, you can follow these general steps:

Create a new Google Apps Script project:

Go to https://script.google.com and create a new project.
Give your project a name and save it.

Set up the HTML and CSS files:

In your Apps Script project, click on the "Files" menu and choose "New > HTML file" to create an HTML file.
Write your HTML code in the editor.
You can also create a CSS file by choosing "New > HTML file" and writing your CSS code.

Write server-side code:

In your Apps Script project, go to the "Code.gs" file.
Write server-side code using JavaScript.
You can handle requests, process data, and interact with other Google services.

Create web app deployment:

In your Apps Script project, go to the "Publish" menu and choose "Deploy as web app."
Set the access permissions and choose the version you want to deploy.
Click on "Deploy" and copy the generated web app URL.

Test and iterate:

Open the generated web app URL in a browser to test your website.
Make any necessary adjustments to the code and redeploy the web app.

Enhance your website:

Add functionality using client-side JavaScript code in the HTML file.
Interact with external APIs, databases, or other services as needed.
Customize the design using CSS.

Remember that Google Apps Script has certain limitations and is primarily designed for automating tasks within Google services. It may not be suitable for building complex websites with advanced functionality. If you require a more robust and scalable web development solution, consider using other frameworks and technologies like JavaScript, HTML, CSS, and hosting platforms like Firebase, Google Cloud, or other web hosting services.

Examples:

https://ashfull1979.blogspot.com/2020/07/how-to-build-web-app-in-google-apps.html
https://ashfull1979.blogspot.com/2020/07/attendance-log-application-in-google.html

Fireworks photography

2023-07-03T20:03:00.002-07:00

Settings for fireworks photography

Photographing fireworks can be a beautiful and exciting experience. Here are some settings and tips to help you capture stunning fireworks photos:

Use a Tripod: Stability is crucial when shooting fireworks. A sturdy tripod will keep your camera steady during long exposures.
Manual Mode: Switch to Manual Mode on your camera to have complete control over the settings.
Low ISO: Set your ISO to the lowest value (typically ISO 100 or 200) to reduce noise in your images.
Aperture: Start with a mid-range aperture like f/8 to f/11. This allows you to have a good balance of sharpness and depth of field.
Shutter Speed: For most fireworks, a shutter speed of 2 to 6 seconds works well. Experiment with longer exposures for multiple bursts in a single frame.
Manual Focus: Set your lens to manual focus and focus to infinity. Fireworks are often far away, and manual focus ensures sharp shots.
Use a Remote Shutter Release: A remote shutter release or the self-timer function will help eliminate camera shake during exposure.
Turn off Image Stabilization: If your lens has image stabilization, turn it off when using a tripod to avoid unintended blur.
Composition: Consider the composition of your shots. Include interesting foreground elements, like a city skyline or a landmark, to add depth to your images.
Shoot in RAW: Photograph in RAW format to retain more information for post-processing adjustments.
Be Prepared: Anticipate the timing of the fireworks and be ready to capture the bursts as they happen.
Experiment and Have Fun: Fireworks photography can be unpredictable, so experiment with different settings and enjoy the process.

Remember, each fireworks display can be different, so don't be afraid to adjust your settings as needed throughout the event. Take the time to review your shots as you go, making adjustments to get the best results. With some practice and creativity, you can capture stunning fireworks photos to celebrate the 4th of July or any other fireworks event.

Top 5 4th of July hacking movies

2023-07-03T19:52:00.002-07:00

As of my last update in September 2021, there aren't many 4th of July-specific hacking movies that are well-known. However, there are some great hacking-themed movies that you might enjoy watching on Independence Day or any other day:

WarGames (1983) - Directed by John Badham, this classic film follows a young computer whiz who inadvertently hacks into a military supercomputer and almost starts World War III.
Hackers (1995) - Directed by Iain Softley, this cult classic features a group of young hackers who uncover a conspiracy while navigating the world of hacking and cybercrime.
Sneakers (1992) - Directed by Phil Alden Robinson, this movie revolves around a team of security experts who are blackmailed into stealing a powerful decryption device.
The Matrix (1999) - Directed by the Wachowskis, this iconic sci-fi action film showcases hackers discovering the truth about their reality and their role in a simulated world controlled by machines.
Live Free or Die Hard (2007) - Directed by Len Wiseman, this is the fourth installment of the Die Hard series, where John McClane battles cyber-terrorists attempting to shut down the entire United States.

Please note that the hacking landscape in movies can be fictionalized and exaggerated for entertainment purposes, and real hacking may have different implications and consequences. Nevertheless, these movies can be a fun way to enjoy some tech-related action on the 4th of July.

Travel itinerary template google sheets

2023-07-02T07:07:00.001-07:00

Are you planning a trip and looking for a convenient and organized way to keep track of your travel plans? Look no further! With our custom Travel Itinerary Template on Google Sheets, your travel planning will become a breeze.

Our template is designed to help you stay on top of all the important details for your trip. It includes sections for dates, destinations, accommodation information, transportation details, activities, and even a packing checklist. With this template, you can easily input and update your travel information, making it accessible from any device with an internet connection.

Why choose our Travel Itinerary Template on Google Sheets? Here are a few key reasons:

Convenience: Access your travel itinerary anytime, anywhere, as long as you have an internet connection and a device to log in to your Google account.
Customizable: Tailor the template to your specific needs and preferences. Add or remove sections, adjust the layout, and make it truly your own.
Collaboration: Share the itinerary with your travel companions, allowing them to contribute and stay informed about the trip's plans.
Real-time Updates: Keep your itinerary up-to-date with real-time changes. Whether you modify the schedule or add new activities, your travel plan will reflect the latest information.
Easy Organization: Stay organized with a comprehensive overview of your travel arrangements, ensuring nothing is overlooked.

So, if you're ready to make your travel planning smoother and more efficient, give our Travel Itinerary Template on Google Sheets a try. Create a new sheet, customize it to your liking, and embark on your journey with peace of mind, knowing that all your travel details are well-organized and easily accessible. Happy travels!

https://docs.google.com/spreadsheets/d/1cwZxpA5ONcwzkGGJKomhR_Usbnm_uWbJeI01m4g39ig/edit?usp=sharing

https://docs.google.com/spreadsheets/d/1qRJx82_TMkrfAOLwKY8IIB67QTX7PWxJITLPvx2V9KE/edit?usp=sharing

binary search tree

2022-11-30T19:23:00.005-08:00

In computer science, a binary search tree (BST), also called an ordered or sorted binary tree, is a rooted binary tree data structure with the key of each internal node being greater than all the keys in the respective node's left subtree and less than the ones in its right subtree. Wikipedia

Books for Learning

Chapters on Binary Search Tree and Microprocessor-Microcontroller

Binary Search Tree (BST) is a node-based binary tree data structure. It is one of the most widely used techniques for searching in non-linear data structure. Microprocessor and Microcontroller is a part of computer that plays an important role in today's technology. Reading these chapters will equip the readers with a summarized understanding of Binary Search Tree (BST) using C-Language and current trends on Microprocessor and Microcontroller

Advanced Algorithms and Data Structure

Advanced Algorithms and Data Structures introduces a collection of algorithms for complex programming challenges in data analysis, machine learning, and graph computing

Algorithms on Strings, Trees, and Sequences: Computer Science and Computational Biology

Traditionally an area of study in computer science, string algorithms have, in recent years, become an increasingly important part of biology, particularly genetics. This volume is a comprehensive look at computer algorithms for string processing. In addition to pure computer science, Gusfield adds extensive discussions on biological problems that are cast as string problems and on methods developed to solve them. This text emphasizes the fundamental ideas and techniques central to today's applications. New approaches to this complex material simplify methods that up to now have been for the specialist alone. With over 400 exercises to reinforce the material and develop additional topics, the book is suitable as a text for graduate or advanced undergraduate students in computer science, computational biology, or bio-informatic

auto click mac

2022-11-29T23:37:00.002-08:00

Giguid USB Mouse Jiggler Undetectable Auto Clicker RGB Switchable with ON/Off Button Mouse Mover Plug & Play (ROBYMICE Series, 1 Item)

About this item

Tiny powerful smart chip with high-tech alien face, make all the difference.
Built in power saving LED indicator, can be turned off manually or automatically in standby.
7 light color options with memory function, breathe softly while moving, flicker softly while click.
Make cursor moves randomly, or switch to automatically click 2 times per second on the target location.
Plug and Play, no driver needed, no software installation required, easy and simple.
USB Type-A connector can plug into any USB 1.0, USB 2.0, USB 3.0 port on the computer.
Compatible with popular desk PC and laptops, like Windows, Mac, Linux, Android, Chrome.
1 year warranty with no reason to exchange, just feel free to contact us if there's any problem.

Should you Learn VBA or Power Query?

2022-11-27T22:05:00.000-08:00

Should you Learn VBA or Power Query? Data Analytics and Business Analytics is quiet making some attention lately. It's a not new subject or system. Instead a very interesting approach and drives demands in the industry.

But the core of this two sciences (if I'm attributing them correctly) is of course Data and the Efficiency in managing the models. Speaking of efficiency is of course Automation ( to some degree if not totally ).

VBA

Visual Basic for Application is a legacy platform and it's been in existence, like ever since. It's a staple, comfort tools to some office productivity tools developers out there. Many applications have been build around it. It offered some relief to some office suite automation requirements. Very effective, but some find it hard for it needs programming skills to be able to build. Though there's Macro Recording, in Microsoft Excel, it really comes in handy.

Yet, just like any other technology new comes along, offers alternative and no coding involved.

Power Query

"Data prep done smart, fast, easy. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources" ---https://powerquery.microsoft.com/en-us/

ETL - Extract, Transform and Load are three basic steps for data usage and application. Most of the time in repetition and with repetition needs automation. In power query this is a guided steps and no coding involved. Every steps recorded instantaneously with less worry of maintaining a code base. We can say, like a Macro Recorder in a way that you can rearrange your steps without going into the actual codes. Convenient it is.

What's the verdict?

Data manipulation, cleansing or modelling. Power Query can be a very potent tool specially if we're dealing with large sets. It can also, deal a multitude of data sources. Local or online data streams.

Automation and Repetition, both VBA and Power Query can efficiently offer. But, VBA can give level of customization with your applications. Specially with User Interaction, tapping other applications and just simply doing thing the other way.

So which should you choose?

Online Alarm Clock

2021-10-31T07:04:00.006-07:00

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.

Create Online Quiz

2021-10-19T23:50:00.008-07:00

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.

Amazon Reviews Scraper

2021-10-17T21:23:00.005-07:00

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:

Perseverance pictures straight to your Gmail

2021-08-30T00:13:00.007-07:00

Mars Perseverance Rover is at Sol 186 on Mars. Since it's landing last February 18, 2021, it already roamed 1.97 km (1.22 mi) and spent 4611 hours on an alien planet. I'm going to describe the science and the technical aspect of the Rover. Instead, I will share to you on how to capture the raw images from Mars as captured by Mars Perseverance rover's many camera.

Note: The script/code is not a gmailapp, it's a stand alone script written with Google Apps Script

NASA Open API

The images are open for public to view. Stay tune on their Mars Perseverance Multimedia site when it's published. Or, you can always get ahead using NASA Open API. Of course, we'll make use of Google Apps Script to fetch from the API. Run the code on a daily basis. Then email the images properly into our Gmail inbox. Now, that's really cool way to get those images fresh.

Sample email output

Just a caution, the script only allows upto 100 images to be embedded in the Gmail body. It's the html table with rows capped at that number. Beyond that cap, will cause an error. As a remedy, I've added a line where the full html saved into a text file, saved into a my GDrive then attach it to the email notification.

The Script (have fun!):

Google Sheets as API database

2021-08-27T22:35:00.001-07:00

API - An application programming interface is a connection between computers or between computer programs. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how to build such a connection or interface is called an API specification [wikipedia].

It's a popular resource for developers in tapping external databases. A staple of every web application consumables. It may sound high-tech. But, the application is a very foundational and with the right approach and basic database knowledge, it is a very powerful tool.

API is most of the time offered for free or premium to developers. Depending on the application and level of data exposure, sometimes this is very expensive. But, for hobbyist and early stage learners. There's ready platform we can take advantage and host your own API.

Here comes Google Sheets

Google sheets it's not just a spreadsheet. Just take off your mind on the Microsoft Suite comparison. Google Apps offers great flexibility in terms of customizing your sheets application. In this article I will show how you make use of sheets as database for your API.

In this application, I will use my existing API integration with NASA API on Mars rover weather collection in Mars. This will not cover the process where I tap the Mars Weather API and pulling them into a spreadsheet. Please see Mars Weather and how to fetch the data for understanding how I was able to pull the resources automatically.

Sample Calls:

Manifest - available api syntax, definition and URLs [ https://script.googleusercontent.com/macros/echo?user_content_key=Aqvh_KWEIkA2y72sJUDkCq3hU0qyXQJnj2MY29elW17YkqH_9WqrLKEd2A_dpFBZCGVVXo3_52JBGkEeehzmavQ-ppmUFbCam5_BxDlH2jW0nuo2oDemN9CCS2h10ox_1xSncGQajx_ryfhECjZEnNqjJ-H5eu9M7hqa9rZt3J7OQe700Q-3vo4cEmcA_c3tBQ5jxh7l-ylMvMB8kT3jmtDBYm40MhAYFuROh1Y-nIh_GIAPxO1ID8oZHxDdzmO3C_sCiQ09SOE&lib=MW1B9XzBuEwJYul5IBb74tZFLmJLFTjNj]

Weather Data call - [https://script.googleusercontent.com/macros/echo?user_content_key=EMlwT2RkgM13AT10bAuo0TbzjraDC-Z4-XNpJo5GvvdFv_CvqE4WXV6M03vvLUYaL7kzSLYrjubVMx5xQHycqtpeFWBiFdSrOJmA1Yb3SEsKFZqtv3DaNYcMrmhZHmUMWojr9NvTBuBLhyHCd5hHawIWrx158g9ghwEUxqgSEa5KtJBr5sPtkjuU9tGy-vudCkvZiKecNgWVlIehvtkCU-XxdbYzwXU8oHAueA3CHIeDde1CekoEMvFYsbopCL01u3Oyxs4-figriVs6AL4mbfcBa1ty0FXNsjgFrM-It9o&lib=MW1B9XzBuEwJYul5IBb74tZFLmJLFTjNj]

Here's the Script:

IP what is my address

2021-08-23T22:00:00.004-07:00

IP what is my?

It's a really weird question. It's like asking a genie for something. Basically asking for an address. This is an age old question in the context of internet history. A very basic information, yet most of us are yet hitting search on Google.

On average, 1 million - 10 million monthly searches for this question. It's a very interesting information considering majority of us went through computer class/lessons. I'm pretty sure this was mentioned many times. And for those are searching for this information, for sure, are well versed enough with these code.

So, what my ip address and how to determine this?

Let's start with the simplest approach. On Google search, type "what is my ip". At the top of the search result is the actual information. This is also the same address that Google used to return local result using your location.
Then there's the searching through your PC setting.
Then there's the command prompt. A very straight forward approach, by the way. A good way to show-off as well. You know just want to impress, how good you are with IT stuff, typing and going into the telnet aspect of identifying your IP Address. On windows, go to Search and type cmd and it enter. Then type Ipconfig in the black screen =). Just look for the blinking cursor =)

And before I forget, on a Mac..

Go to your System Preferences and follow the images below.

If you're that confident with the MacOS Terminal

Start Terminal
Enter the command ipconfig getifaddr en1 at the command prompt. Or...
Enter the command ipconfig getifaddr en0

There you have it. Be aware of this information as you will encounter or be needing this as more devices are connected in the internet. Even in your homes, this will be a staple and to provide proper allocation of internet usage and level of control as well.

Ingenuity's flight

2021-08-21T07:37:00.004-07:00

It's not news anymore that powered flight was successfully conducted on Mars. First flight was on April 19, 2021 and had logged 12 flights with almost 22 hrs of flight time. That's impressive for an autonomous helicopter on a planet 300 million miles away from Earth. This is not your typical NASA Mars Exploration article. Instead an idea that was influenced with Chrome's Dino Run and a fun side of with Mars Helicopter's Ingenuity as it takes flight in a webpage.

How about we keep it flying?

I'm sharing a project that I've been working to do just as this. I will not create an actual helicopter. Instead, I'll create a web app that could apply the same dynamics as Google Chrome's Dino run. Well...the foundation...for start.

I'm not going to create the game. But, I'm going to share the baseline on how that endless strip of scene as the main character run its way through the desert. On this case, I'll let Mars Helicopter fly endlessly with the Martian terrain and mountains as the background. I'm using Google Apps Script to build this project. Long term goal is to make this interactive like that Dino run above. Who knows, I might get bored some more...

So, here's the script(see it fly on this link > https://script.google.com/macros/s/AKfycbzuXWmwAxdiaT2LTDyumpEOjLfXV9HeLNoU1qituMkqARRmCcrbEZCNKYqCbKbTRCEslQ/exec):

Embed code from github two ways

2021-08-21T02:48:00.004-07:00

As a blogger and a programmer at the same time. Bringing your code to the general audience creates sense of pride. It depends on the language, presenting them as close to how it appears in an IDE would be very helpful for the readers. You can always take screens shots and post them on your blog as an image. But, most of the coder out there, that code in an image is not useful. Every coder needs a text based blocks of scripts to copied easily.

So how would you post your script to a blog post and retail the visual text representation just like in an IDE?

Github

It is a popular platform for software developer to host codes. It simply offers the ability to share scripts for multiple developers and offer version controls to managed source code systematically. For mainstream developers, it does that efficiently. But for a blogger, it gives that flexibility, to capture those posted scripts and share it through a blog.

Embed code from github two ways

This involves editing your site in html level. You are reading this article upto this line, for sure you know what I'm talking about.

https://github.com/ - the main site and how to embed your code from this domain. It should look same in the image below. Just incase the actual implementation works on this article.

The script embedded:

https://gist.github.com/ - this approach works similar with above approach. In the main github repository, on url is good for single file repository. In gist, single gist file can hold multiple blocks of codes in different file type (i.e., .html, .js, .css and etc). Below is how you copy your gist url and write on the html level of your article.

The script embedded:

Which is better?

Lately, using the http://gist-it.appspot.com causes some intermittent issues of showing up. Or, not really working at all. There could be some new guidelines or new link, I don't have any information as of the moment. But, if you have, feel free to share in the comment below.

Hoodies for guys

2021-08-17T07:58:00.004-07:00

I'm a hoodie guy and wearing gives me such expression of one being in the tech industry. It also reflects my introvert side...you know with the hoodies on, gets you that concealment and do your stuff privately. Being a coder, it give's such incognito profile.

10 favorite hoodie designs

Here are some of my top choices if you want to express as a coder with a hoodie. Hope you'll like them as well.

	Any coder will figure this out. Miss this one and debug mode is a "killer".
	All of us thinks we are a ninja. The red color give's that strength and the brute side of it...I think
	This funny geek t-shirt is great for computing programmer, computer science, geeks, coders and software developers. They think and breathe code from HTML, Javascript, PHP, C, C#, C++ or Python. This programmer meaning t-shirt is perfect as a gift for Christmas, birthdays or a fathers day tee for your dad.
	You love fixing bugs, errors, coding and programming? Sounds like you need to purchase this Computer Specialist Debugging Tee for to show it to the nerds or admin in the office or purchase it as a gift for a friend geek, hacker, software developer or designer.
	This is actually something you should never do. A trolling design created to cause your fellow programmers blow a gasket. That's how focused we are.
	It's not a bug...it's a feature...so what really is it? only a programmer knows...
	The idea is to use binary code to write the statement. So the T-shirt statement is "I AM A HACKER"...Or is it? Figure it out...
	THESE HEADPHONES ARE ON FOR A REASON...So just back-off
	It's actually true...just trust us...
	To be clear it's not an infinite loop...