SmartSuite came to challenge Airtable

Airtable has been my favorite No Code/Low Code tool for some time now. In a few years I’ve been using it so far, I haven’t really found a good alternative. Even then, Airtable cannot rest on its laurels. Especially now, a new kid in town, SmartSuite, came to challenge its position. Airtable has already been introducing substantial improvements recently, but it needs to up its game even further to hold on to its lead.

One of my favorite Youtuber, Gareth Pronovost, details down the 3 gamechanging features about SmartSuite that Airtable has to catch up on:

How to export your data from the Eufy Smart Scale C1

For some time, exporting your data from your Eufy smart scale has been a pain, with hacks developed for this supposedly simple process like this and this. So I posted a follow up query on Anker forum.

Thankfully, I received a response, and it states that starting with the update in the EufyLife app that was released August 5, 2022, you may now export your data from the app in CSV format, under Settings>>Privacy and Data>>Export All Data.

The option may have been buried deep into the settings, but at the least it’s there for data freaks like us. Just enter your password and your email address to where you want the CSV file will be sent to.

All the other available (so far) smart scale of Eufy use the same app, the EufyLife app, so I guess this is applicable to those as well, like the Eufy Smart Scale P2 and the P2 Pro.

Plex New Feature: Sync Watch State and Ratings

From Plex Support Article:

Plex allows you to optionally sync your watched/played state and personal ratings of movies and episodes with your Plex account online. That means that if you watch a movie on a friend’s server, it can update your account so that the movie will also be marked as watched on Plex’s Discover feature, our free Movies & Shows streaming service, and any Plex Media Server you have access to.

Does this mean I can do away with PlexTraktSync already?

From what I gather, if you have multiple Plex server, you can sync your watch state across all of them. Also, if you decide to migrate an existing Plex server or re-start a new server from scratch, it won’t be much of a pain carrying over your watch states, for you, the server owner, and your users. That’s neat. No more plugin, no more Trakt, and your users whom you’ve shared your library with can enable the same to their account (this settings is account-specific).

I’ve enabled this feature in my Account Settings. Now, let’s wait for it to do its magic.

How to upgrade your Globe Fiber speed to the updated plan

Recently, Globe updated its Globe at Home Fiber Plans to support faster speeds.

I was on Plan 1699 that used to have 60Mbps speed only. I opened the Globe at Home app (I know, it’s very buggy app, you need to bring a lot of patience), hit the Upgrade button under my Plan Details, and my speed was upgraded after 3 days:

And the upgrade even came with a free 3-month Amazon Prime Video subscription, which I barely use (I use Plex).

My OnePlus 8 Pro has the Dreaded Green Screen Issue

In late 2020, I chose the OnePlus 8 Pro over the Samsung Galaxy Note 20 primarily because of avoiding Samsung’s Exynos chip. The price also played a role, and I was happy with that decision, until just this Monday, April 18, 2022, when I found my device’s display was giving out this green hue throughout the whole screen, even while in the lock screen. Didn’t drop the phone nor submerged it in water recently. My OnePlus 8 Pro is currently running Oxygen OS 12 (Android 12).

I searched around, and apparently several OnePlus phones may have been suffering from this issue for some time already. Many label the issue as green screen or green tint, although my case was unlike some’s who only encounter the problem when they are on some specific apps. Mine’s green tint is everywhere.

I reached out to Digital Walker, the supplier of this specific device and the official distributor of OnePlus in the Philippines, and reported this issue. I got a not so good news response »

How to: Use Excel Power Query to Retrieve Data from Airtable

When you have your data neatly set up on Airtable, especially when they are particularly financial data and numbers, you would want to connect to them on Excel (or Power BI), and do the analysis (or charts) from the latter.

Excel’s Power Query can ETL (Extract, Transform, and Load) data from your Airtable database, and here’s how to even work around the 100 Rows Limit or Pagination.

What you need are:

  1. Base ID
  2. Table  ID
  3. API Key

So I created a throwaway Airtable account for the API key, a throwaway workspace from that account, and and loaded the Simple Project Tracker base template, just for this demonstration.

You can get your API key from your account page (https://airtable.com/account):

You can get your Base ID and Table ID by going to the base and table you want to connect to and copy them from the URL: Continue reading How to: Use Excel Power Query to Retrieve Data from Airtable