The Perfect YouTube Video Length: 10 Minutes

August 18, 2023 / / 0 Comments

In the vast landscape of online content, YouTube stands as an undeniable giant. With over 2 billion logged-in monthly users, the platform offers an extensive array of videos covering everything from educational content to entertainment, vlogs to music. As creators strive to capture their audience’s attention and maximize watch time, the question of video length becomes pivotal. Is there an ideal duration that strikes the balance between engagement and viewer retention?

I would argue that Youtube videos should only be 8 to 12 minutes long,  and that the 10-minute mark might just be the sweet spot. Beyond that, I’d rather just click Next.

Continue reading

OneDrive is an intrusive piece of app

August 4, 2023 / / 0 Comments

Leo Notemboom explains how the OneDrive can be so invasive on your computer’s document files if you’re not too careful.

I might have enabled OneDrive backup by accident in the past. I just hope I didn’t lose files by accident as well because of Microsoft’s and OneDrive’s stupidity ineptitude.

Power Query function to count number of months between two dates

June 28, 2023 / / 0 Comments

Power Query has a built-in Duration.Days function. But what about Duration.Months?

Why don’t we create a custom function for that?

(Date1 as date , Date2 as date) =>
let
    Source =
        List.Generate(
            () => [x = 1, y = Date.AddMonths(Date1,x)],
            each [y] <= Date2,
            each [x = [x] + 1, y = Date.AddMonths(Date1,x)],
            each [y]
        ),
    Months = List.Count(Source)
in
    Months

Note: Date1 should be earlier than Date2.

BDO PERA Annual Contribution Limit Increase

May 17, 2023 / / 0 Comments

Following the directive of the BSP, I received an email today from BDO stating that the limit for my annual contribution to my PERA account with them has increased from P100,000 to P200,000.

This is timely — with the elevated inflation rates in the past year or so, we’d better have enough come retirement age. Plus, this is an opportunity to average down faster with our PERA account subscriptions being down in the past 3 years.

Rich Dad Poor Dad – from overrated to trash

April 13, 2023 / / 0 Comments

After reading the book (or rather, listening to the audiobook) of Rich Dad Poor Dad by Robert Kiyosaki, I thought it was overrated. After listening to the If Books Could Kill podcast episode about it, I realized it was a total piece of trash.

From promoting illegal investment and business activities, to selling MLM or Ponzi scheme products, people should already stop quoting passages from this book. Forget about assets and liabilities, or shaping people’s mindset about it, other than those taught in accounting classes.

Listen to Michael Hobbes & Peter Shamshiri as they break down the faults in this book:

Airtable Script to Convert Numbers into Words (Automation)

February 15, 2023 / / 0 Comments

When you’re filling out bank forms, the bank documents usually require their customers spell out the amount they put in into words. This is one way for banks to make sure customers really meant the number they put in their forms, and not made a typo. This poses a problem when you’re using Airtable’s Page Designer to auto-populate the bank forms from your Airtable records. Yes, you can type it out in a separate text field, but there must be a way to automate this, right?

Let’s say, you have a field called “Amount Sold” in your base. Go to Automations, and in one of your actions, select Run Script. Add an Input Variable and name it amount_sold , then for the Value select the “Amount Sold” field from your base.

Input Variable in Airtable

Input Variable in Airtable

Now paste the following in the Code area: Continue reading

Docker app for generating PDF from Airtable Records

January 11, 2023 / / 0 Comments

There are several ways to generate a PDF from Airtable records using Docker. One approach is to use a library or framework that can generate PDFs, such as wkhtmltopdf or PrinceXML, and run it within a Docker container.

Here is an example of how you might use wkhtmltopdf to generate a PDF from Airtable records:

  1. Create a new Docker image based on the official wkhtmltopdf image.
  2. In your Dockerfile, install any additional dependencies you need to access the Airtable API and retrieve records.
  3. Write a script that retrieves the records you want to include in the PDF from Airtable, and converts them to an HTML template.
  4. Use wkhtmltopdf to convert the HTML template to a PDF.
  5. Start the Docker container and run the script to generate the PDF.

You can store the pdf in the container and store it or a way to extract it outside of it, with the help of some specific command.

Another approach is to use a pre-built service such as Airtable2pdf that can be integrated with your Airtable bases and generate pdf’s of it.

Note that the above is a basic example and the actual implementation would depend on your specific requirements and use-case.

The above quote was taken directly from the answer of ChatGPT about my query which is the title of this article. Unfortunately, I don’t know how to build a docker image from source, so I didn’t really get the help I needed. Good luck to me and you who are looking for solutions like this.