# Get All & Get Selected Rows functions - where art thou? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [April 19, 2021, 4:26pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709 "2021-04-19T16:26:34Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![ukhollywood29l](https://avatars.discourse-cdn.com/v4/letter/u/ecd19e/32.png) [@ukhollywood29l](https://community.thunkable.com/u/ukhollywood29l)\ **Post date:** [April 19, 2021, 4:26pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/1 "2021-04-19T16:26:34Z")
Hi Thunkers, I’m attempting to retrieve data from a DB and came across the “Get All Rows” and " Get Selected Rows" in the documentation [https://docs.thunkable.com/spreadsheet#getting-uploading-updating-and-deleting-data](https://docs.thunkable.com/spreadsheet#getting-uploading-updating-and-deleting-data). Trouble is I can’t seem to find it anywhere in my project. Can anyone confirm if these functions have been depreciated? If so what is the new alternatives? Thanks all! ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [April 19, 2021, 6:55pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/2 "2021-04-19T18:55:41Z")
Which datasource are you using? And older interface, or the new drag-and-drop? ---
**Author:** ![ukhollywood29l](https://avatars.discourse-cdn.com/v4/letter/u/ecd19e/32.png) [@ukhollywood29l](https://community.thunkable.com/u/ukhollywood29l)\ **Post date:** [April 19, 2021, 6:59pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/3 "2021-04-19T18:59:13Z")
Using the older interface and pulling from Airtable ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [April 19, 2021, 7:08pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/4 "2021-04-19T19:08:59Z")
You’re right, I don’t see those options either! The code below gets a list of all the row IDs (ID is a special column) and then you could do something with it in a loop. (Don’t just set the same variable each time like I did, or you’ll just get the last row.) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/7/4724ce3aa9125deba9bf606db28fa9a2c8c2560f.png) @jane, I think we’ve got a gremlin in those docs? ---
**Author:** ![ukhollywood29l](https://avatars.discourse-cdn.com/v4/letter/u/ecd19e/32.png) [@ukhollywood29l](https://community.thunkable.com/u/ukhollywood29l)\ **Post date:** [April 19, 2021, 8:14pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/5 "2021-04-19T20:14:40Z")
Thanks! So i’m not losing the plot! I’ll try your workaround… Cheers! ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 20, 2021, 12:01am UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/6 "2021-04-20T00:01:10Z")
When you connect Airtable using the Data Source “+” option you would get a set of blocks different than those when you set the connection using Airtable component. GetAllRows is a block associated with using the Airtable invisible component only. ---
**Author:** ![jane](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jane/32/27575_2.png) [@jane](https://community.thunkable.com/u/jane)\ **Post date:** [April 20, 2021, 8:32am UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/7 "2021-04-20T08:32:03Z")
> [@ukhollywood29l](#): > > [Thunkable Docs](https://docs.thunkable.com/spreadsheet#getting-uploading-updating-and-deleting-data) Hi there, These docs are for the Airtable component, which can be found in the snap-to-place UI under Data: ![Screen Shot 2021-04-20 at 9.31.26 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/3/d3705b52e9512f563a5c3a78e2821f77784c0485.png) As you can see, these blocks are present in the Airtable component’s drawer of blocks: ![Screen Shot 2021-04-20 at 9.28.32 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/5/65a50d9029ecdc9c145d96bb76506b5841d766d2.png) The Airtable component predates the Data Sources integration and has a different set of docs. Hope that explains things @ukhollywood29l and @catsarisky! Thanks @muneer for explaining the difference as well. 🙂 ---
**Author:** ![ukhollywood29l](https://avatars.discourse-cdn.com/v4/letter/u/ecd19e/32.png) [@ukhollywood29l](https://community.thunkable.com/u/ukhollywood29l)\ **Post date:** [April 20, 2021, 12:42pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/8 "2021-04-20T12:42:35Z")
Thanks @muneer & @catsarisky for your explanation and loop example 🙂 , cheers Jane for the screenshot this helped massively. A top tip to my past self and Thunkers that come across this issue. Whilst I was already using the air table component in my custom data viewer list using an datasource, will work perfectly. But doing it like this is building with one hand tied behind your back, not specifically connecting the Airtable to my project as per examples above mean you are unable to call many of the functions referenced in examples, which help simplify the development process. @jane is there a specific reason **why** you get different options in each case? It would be good to understand the reason… e.g. bug or feature 😉 ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:25pm UTC](https://community.thunkable.com/t/get-all-get-selected-rows-functions-where-art-thou/1233709/9 "2024-11-08T13:25:08Z")