Sorry if this sounds rather simple, but I just can’t seem to figure out how this is not working… I’m trying to access a list of values from my Airtable database, I thought something like this would do the trick, but just can’t seem to get it to work… Is the below the correct way to use “list of va…

You’ll want to use the Get Row or Get All Rows blocks. @darren has a good tutorial video here: https://www.youtube.com/watch?v=V61Oo6TCwnw .

Hi @tatiang ! That was actually very helpful! I was using Airtable as a DataSource, and that didn’t come with any of the options (Get Row, Get All Rows)… Do you have time for another question? I went through the tutorial to add Airtable. However, I’m still having issues with accessing values by …

https://x.thunkable.com/copy/5d0985de18ddb9446d7413544e5e0bd6 This may help

@jared Unfortunately I looked at all the connection settings to AirTable, and everything matches what the example is doing… The one thing I saw different from the example was that the example assigned a list variable to the current row in AirTable, and then access the element based on that list vari…

@drted Thanks! Though I don’t even think I’m that far yet to worry about performance issues… I can’t seem to get passed the GetAllRows API call to return data…

do you get any result from 'getallrows"?

@jared Nope, not at all… I created a list variable called addrList and assigned basic values of “1, 2, 3”. I then called GetAllRows to get Address_Street values and add each value to the list. So I would expect “1, 2, 3, xxxx, xxxx, xxxx”. As you can see in the screenshot, the variable still jus…

Put the “from mqDistance set Text” block inside the GetAllRows block. Otherwise, it’s going to run before your loop finishes. If you move it inside (below the loop block), I would expect to see the value of the last address_street in your AirTable sheet.

yes! the label should be set after the loop, not after the purple airtable block. connect the label set block to the bottom of the loop block, (not inside the loop). make sure all of those are in the ‘then do’ section of the airtable block.

Airtable and List

Questions about Thunkable X

drted October 21, 2020, 5:49pm 5

I found this solution much faster for Google Sheet, but I haven’t tried it on AirTable. For AirTable, substitute the Get Column block for the List of Values block in the example.

Topic		Replies	Views
Help with accessing airtable spreadsheet in thunkable app Questions about Thunkable X	9	1269	June 7, 2019
Accessing two rows from Airtable at the same time Questions about Thunkable X	3	411	April 20, 2022
[Solved] Get cell value from other column Questions about Thunkable X solved , airtable	52	3688	April 27, 2021
[Solved] Can't find "get all rows" block Questions about Thunkable X	8	1487	January 8, 2022
Where is the blocks of airtable in drag and drop version? Questions about Thunkable X solved	9	597	November 14, 2021

Airtable and List

Related topics