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.

Laptop trends as per CES 2023

January 6, 2023 / / 0 Comments

From CNET on Youtube:

From a giant two-in-one tablet to a pen-enabled e-reader to two dual-screen laptops, Lenovo brought its innovative A game to the giant tech show in Las Vegas.

Do consumers really need dual-screen laptops like this? Is this really where the trend is moving towards for laptops?

For me, just give me a laptop with upgradable RAM and expandable storage, that’s all I need. Unfortonately those are rare features, and if ever, are only available for ultra high end, expensive devices.

Cryptocurrencies are not investment products

December 18, 2022 / / 0 Comments

Bitcoin isn’t really used much as a currency at all.

When people buy bitcoin, they rarely use it to buy goods and services. They’re really buying access to a Ponzi scheme.

Even before the fall of FTX, I share the same sentiment. Bitcoin could probably actually work as a form of currency. Problem is, people don’t use it as such. They don’t exchange their dollars for these coins to buy goods and services. Instead, they buy them in the hopes that some other people will hop on the bandwagon, and they cash-in on its price appreciation.

And scammers flock to this opportunity to take advantage of people who don’t really know how things like these work but gullible enough to fall for their traps.

December 7, 2022

Unfortunately, I can’t seem to make NextCloud work on this Racknered cPanel Shared Hosting. I guess I’ll just stick to a NextCloud VPS install via Docker.

Black Friday 2022 Shopping Haul

November 27, 2022 / / 0 Comments

I know there’s no Black Friday in the Philippines, but that doesn’t mean we can’t participate in the Black Friday sale, especially when they’re about online services like web hosting and VPS.

So here’s what I checked out during the Black Friday of 2022:

Racknerd cPanel 100GB hosting

Shared – 100 GB – $15.89 per YEAR!
Great for businesses and busier websites.
100 GB SSD Disk Space
5 TB Monthly Transfer (FREE Double the bandwidth, just comment your order#)
Unlimited Databases
Host 5 Domains
Free SSL Certificates
cPanel Control Panel
Softaculous Script Installer
LiteSpeed Web Server
Free Offsite Daily Backups (JetBackup)
MailChannels Hybrid – Premium Email Delivery
FREE Clientexec License
Available in Multiple Locations (US, EU, Asia)
Only $15.89 per year!

RamNode 2GB OpenVZ VPS

Use code: 2LET22
2GB OpenVZ SVZS – Any region – $18/yr (includes 1 IPv4, /64 IPv6)
2GB RAM
2 vCores (fair usage)
60GB Disk
2TB BW

The problem with the RamNode OpenVZ VPS is I can’t run Docker on it. So I guess it’ll serve as my test box for all bare metal Linux server related apps. Now, I just hope I still have enough money for Cyber Monday.
Continue reading