# Data List and Spreadsheet Recall **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [April 15, 2024, 7:28pm UTC](https://community.thunkable.com/t/data-list-and-spreadsheet-recall/2948113 "2024-04-15T19:28:20Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![christian.noblem](https://avatars.discourse-cdn.com/v4/letter/c/9f8e36/32.png) [@christian.noblem](https://community.thunkable.com/u/christian.noblem)\ **Post date:** [April 15, 2024, 7:28pm UTC](https://community.thunkable.com/t/data-list-and-spreadsheet-recall/2948113/1 "2024-04-15T19:28:20Z")
I’m trying to update a simile list based on a user clicking a button on another page. The app will navigate the person to the new page and update the list simultaneously. So far, I can update the video element at the top of the **VideoContent** page, but the other variables refuse to set. So the logic regarding the spreadsheet search works, but the other columns aren’t reflected. Is there an issue with how I set and show the other variables? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/2/5290a747fba55cde64762fca158c05aba03f6aa6.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [April 15, 2024, 9:58pm UTC](https://community.thunkable.com/t/data-list-and-spreadsheet-recall/2948113/2 "2024-04-15T21:58:28Z")
For this part of your blocks, you’re getting the length of a list from the `app variable SelectedPage` which is not a list. I’d have to test that to know for sure but I think the length of a text string as a list is one (1). So your loop might only be iterating once. What are you trying to loop through the length of? The number of rows? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/15d4c5551a53b417efd3a6c39773d1e9937a597f.png) ---
**Author:** ![christian.noblem](https://avatars.discourse-cdn.com/v4/letter/c/9f8e36/32.png) [@christian.noblem](https://community.thunkable.com/u/christian.noblem)\ **Post date:** [April 18, 2024, 8:04pm UTC](https://community.thunkable.com/t/data-list-and-spreadsheet-recall/2948113/3 "2024-04-18T20:04:04Z")
app variable SelectedPage is set on page “LegalHelpVideoBasics” and initiates as a list of topics. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/e/1e52109451edc46f1f1fd18a49d2fe9f75e542a8.png) In the above example, the matching list item would be “BeforeCourt” stored in the app variableVideoContent. My ultimate goal would be to have the function check the list, grab the row ID of the matching variable in the datasheet, and set variables across the row per column for use in the simple list. The function works for setting the web URL in column 2 in my datasheet. The subsequent set variable functions don’t seem to. ---
**Author:** ![christian.noblem](https://avatars.discourse-cdn.com/v4/letter/c/9f8e36/32.png) [@christian.noblem](https://community.thunkable.com/u/christian.noblem)\ **Post date:** [April 23, 2024, 7:04pm UTC](https://community.thunkable.com/t/data-list-and-spreadsheet-recall/2948113/4 "2024-04-23T19:04:53Z")
Maybe it was looking at the wrong variable, or there’s an issue with setting the variables and then immediately using them to display in a label component, but I reconfigured the block, and this works as advertised: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/3/43a95a51912c11abe042bd826a9dd7c812f08b56.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [July 22, 2024, 7:05pm UTC](https://community.thunkable.com/t/data-list-and-spreadsheet-recall/2948113/5 "2024-07-22T19:05:50Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.