Spreadsheets connected to FREE databases (airtable is not free)

[lff]

Hi,
I’m helping a group of girls that are coding an app for the Technovation challenge competition. We need a database to store not more than 100 entries with 8 columns (each database record may have 8 fields or more). We need to make queries to the database by one, two or three fields and retrieve the results to show in our app. It seems that the best options is Airtable spreadsheets, but I was upset when I check that is only free for a couple of weeks.
My questions are:

1. Do you know if I can free get access to Airtable for six months, during the Technovation challenge competition?
2. Do you know if I can connect the spreadsheet component of thunkable to a spreadsheet stored for example in google drive?
3. Do you know a FREE alternative to add a database to thunkable x?
   The girls that are coding the app are 12-14 years old, so they are not experts in databases.
4. What do you recommend?
   Thank you so much!

[cttricks]

@lff

1. Do you know if I can connect the spreadsheet component of thunkable to a spreadsheet stored for example in google drive?
2. Do you know a FREE alternative to add a database to thunkable x?

http://community.thunkable.com/t/send-upload-data-to-google-sheets-using-script/68466?u=cttricks

http://community.thunkable.com/t/solved-store-users-data-to-spreadsheet-without-using-cloudstitch-airteble-or-any-other-api/45276?u=cttricks

◎ Ct_tricks

[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…

[domhnallohanlon]

@cttricks, please note this is a question about Thunkable X.

[lff]

Yes, it seems I had chosen the pro plan trial. I hope that after 13 days my plan will change to free plan.
Other question, is it possible to store an image in the spreadsheet of airtable? I want to store information about movies, including an image (.gif, .jpg, …). If not, is it possible to connect the airtable database with the media db?
Thank you !!

[jacob1]

Hi Iff,

It is possible to upload your image to cloudinary through the media db and then take the mediaURL output of that component and store it in Airtable - that way when you want to retrieve it, you can see it in your app

[Lanre_Josh]

Hi, I just made a break through in storing my data on my SD card and i can access it easily on my device using my pdf reader, but i just have a challenge on how to make them fall on different columns.If you see the screen shot sent, you would notice were my file is saved(/classfile,xls).