@Tatiang
Hi, Tatiang Thank you very much for your answer. I know that Muneer and you are helping voluntarily, and I really appreciate it, very much indeed. I was asking you this because I’ve been looking for an explanation to this question, and I saw you asked almost the very same thing. So I thought you had the answer, because when I tried to follow the explanations that someone gave to you on this topic, I couldn’t because I couldn’t access the examples… I arrived late.
Although my example was made with the D&D interface, trying to find there the blocks that I couldn’t find, I’m really using the old StP, but here now I can’t find where the GETALLROWS is either, I only find the Delete all rows. so where the … is my Gel All Rows block?
After you add the Airtable component to a StP project, it shows up in the list of blocks and will have the name that you gave to the component in the Design tab. In my case, it’s called Airtable Students:
@Tatiang
Hi, I have decided to move everything to airtable, so I have like 44 tables-files. The API Key is the same for all of them, but every table has got its own Base ID… Do I have to have 44 Airtables in the invisible components area, one for every table, so that everyone has its own BaseID, TableName and View Name?
Thanks
Probably but I strongly recommend you do not do that. Using a single Google Sheet with a loop that gets row objects or lists of column values is going to be so much easier in the long run.
Between 44 separate tables and a single sheet? I don’t know. I just can’t imagine coding blocks for 44 different tables. That’s honestly my nightmare. It’s not that hard to make a loop that gets the data from a Google Sheet. I’m still not clear on how much data you actually need. If it’s only a few columns, it will definitely be fast. If it’s the whole data set, less so.
Well, I have 44 files for Airtable, and 22 with 2 to 4 columns, less than 1200 rows, and another 22 (quizzes) with 7 columns,and in google sheets would be 30 files, 15 with 2 to 4 columns
I would probably put each separate .xlsx file in a sheet in a single Google Sheet. (It’s confusing that a tab in a Google Sheet is called a “sheet”). That way, you’re working with a single data source and you can use the drop-down menu to select each sheet when using Data Sources blocks:
So I could have 30, 40 … sheets in a single file… Never thought about ir. But I have to learn much more about List of values and its hook, see some examples…
Yes, up to 200 tabs/sheets in a single Google Sheet file.
Is it possible you’re over-thinking this? We all learn differently but… we’re on post 31 of this topic and it might just be easier/quicker to play around with the blocks. You probably have but just in case you’re still stuck…
Just assign the “list of values” block to a variable and then assign the variable to a List Viewer’s text items. That will give you an indication for how to use that block. It’s not your end result but it’s a good way to get familiar with the block. It really is just a function block that returns a list type. So you can do things like this:
Even when Airtable is chosen then I would have all the sheets in one Base. Airtable is much faster than Google sheet but the free plan is limited to 1200 rows which might not be the ideal choice for this project.
