Spreadsheets connected to FREE databases (airtable is not free)

[domhnallohanlon]

Hi @lff, welcome to the community.

Airtable has a “free forever” tier. When you signed up you may have opted into one of the paid plans inadvertently:

Airtable Pricing | Compare Plans, Features & Costs

Also, if you want offline access to your data, or don’t require and of the computing power that Airtable offers, then the LocalDB is a good choice too.

We’ve been publishing more and more tutorials about a this component recently:

Search & Filter LocalDB

Searching & Filtering This tutorial will focus on working with data that is stored in the LocalDB, specifically searching and filtering it. You can type in a search term to drill down into your data, or you can click on different buttons to filter by specific categories. [2019_02_14_15_17_30] Raw Data We have two columns and 10 rows of data. Note that there are two different types of fruit in this example that we will use for sorting later on. [58] …

Performing a VLOOKUP in LocalDB

One of the most powerful features in Thunkable is the new LocalDB component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP. What is VLOOKUP? A VLOOKUP, or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row Design Let’s start…