# Need help with my app data sorting

**URL:** <https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317>\
**Category:** Questions about Thunkable X\
**Created:** [November 12, 2024, 5:11pm UTC](https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317 "2024-11-12T17:11:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![zshaalan14b7gfm7](https://avatars.discourse-cdn.com/v4/letter/z/8baadc/32.png) [@zshaalan14b7gfm7](https://community.thunkable.com/u/zshaalan14b7gfm7)\
**Post date:** [November 12, 2024, 5:11pm UTC](https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317/1 "2024-11-12T17:11:39Z")

</div>

I am building a Quran app in Thunkable that allows users to select a Surah from a list and dynamically display its content (e.g., verses, images) on the same screen. Each Surah’s data is stored in a separate tab of a single Google Sheet. When a user clicks on a Surah from the list, the app should know which tab to reference to pull and display the correct data.

## Key Requirements:

**Main Screen (List of Surahs):**

- You have a List Viewer or Data Viewer List on the main screen that displays a list of Surahs fetched from a Quran List tab in your Google Sheet.
- Each Surah in this list is linked to a specific tab in the Google Sheet that contains its content (e.g., verses, images, translations).

**Dynamic Data Fetching:**

- When a user clicks on a Surah, the app should recognize which tab in the Google Sheet to use for data retrieval.
- Each tab in the Google Sheet contains data specific to one Surah (e.g., all the verses and related images for that Surah).
- The name or identifier of the tab for each Surah is stored in the Quran List tab in a column alongside the Surah names.

**Displaying Data on the Same Screen:**

- Once the user selects a Surah, the app should open a display screen where it fetches and displays the data (e.g., verses and images) from the corresponding tab.
- The user should be able to navigate through the data (e.g., using “Next” and “Previous” buttons) to view all content related to that Surah.

## How This Should Work:

**User Interaction:**

- A user sees a list of Surahs on the main screen.
- When a user clicks on a Surah, the app retrieves the tab name associated with that Surah.

**Data Retrieval:**

- The app uses this tab name to access the correct tab in the Google Sheet and fetches the Surah’s data (e.g., images, verses).
- This data is then stored in a variable to be displayed on the screen.

**Displaying Content:**

- The app shows the first item (e.g., verse or image) from the retrieved data.
- Users can click “Next” or “Previous” buttons to navigate through the Surah’s content without leaving the screen.

## What to Ask Thunkable Experts:

**Dynamic Data Source Switching:**

- How can Thunkable handle dynamic switching between different tabs of a Google Sheet based on user input?

**Data Viewer List Integration:**

- How to set up the List Viewer so that it can pass data (e.g., a tab identifier) to another screen and use it as a reference to fetch data from a specific tab.

**Optimization Tips:**

- Best practices for ensuring the app remains responsive and loads data efficiently, especially when dealing with multiple Google Sheet tabs.

**Example Workflow:**

- User clicks on “Surat Al-Fatiha”.
- The app sets selectedSurah to “Surat\_Al-Fatiha” (matching the tab name in the Google Sheet).
- The app navigates to a new screen and fetches data from the “Surat\_Al-Fatiha” tab.
- The app displays the first verse or image, with navigation buttons to move forward or backward through the content.  
​

## Original Post

> **Expand to see original post**
>
> i am building a Quran app in Thunkable that allows users to select a Surah from a list and dynamically display its content (e.g., verses, images) on the same screen. Each Surah’s data is stored in a separate tab of a single Google Sheet. When a user clicks on a Surah from the list, the app should know which tab to reference to pull and display the correct data.
> 
> Key Requirements:  
> Main Screen (List of Surahs):  
> You have a List Viewer or Data Viewer List on the main screen that displays a list of Surahs fetched from a Quran List tab in your Google Sheet.  
> Each Surah in this list is linked to a specific tab in the Google Sheet that contains its content (e.g., verses, images, translations).
> 
> Dynamic Data Fetching:
> 
> When a user clicks on a Surah, the app should recognize which tab in the Google Sheet to use for data retrieval.  
> Each tab in the Google Sheet contains data specific to one Surah (e.g., all the verses and related images for that Surah).  
> The name or identifier of the tab for each Surah is stored in the Quran List tab in a column alongside the Surah names.  
> Displaying Data on the Same Screen:  
> Once the user selects a Surah, the app should open a display screen where it fetches and displays the data (e.g., verses and images) from the corresponding tab.  
> The user should be able to navigate through the data (e.g., using “Next” and “Previous” buttons) to view all content related to that Surah.  
> How This Should Work:  
> User Interaction:  
> A user sees a list of Surahs on the main screen.  
> When a user clicks on a Surah, the app retrieves the tab name associated with that Surah.  
> Data Retrieval:  
> The app uses this tab name to access the correct tab in the Google Sheet and fetches the Surah’s data (e.g., images, verses).  
> This data is then stored in a variable to be displayed on the screen.  
> Displaying Content:  
> The app shows the first item (e.g., verse or image) from the retrieved data.  
> Users can click “Next” or “Previous” buttons to navigate through the Surah’s content without leaving the screen.
> 
> What to Ask Thunkable Experts:  
> Dynamic Data Source Switching:  
> How can Thunkable handle dynamic switching between different tabs of a Google Sheet based on user input?
> 
> Data Viewer List Integration:  
> How to set up the List Viewer so that it can pass data (e.g., a tab identifier) to another screen and use it as a reference to fetch data from a specific tab.
> 
> Optimization Tips:  
> Best practices for ensuring the app remains responsive and loads data efficiently, especially when dealing with multiple Google Sheet tabs.  
> Example Workflow:  
> User clicks on “Surat Al-Fatiha”.  
> The app sets selectedSurah to “Surat\_Al-Fatiha” (matching the tab name in the Google Sheet).  
> The app navigates to a new screen and fetches data from the “Surat\_Al-Fatiha” tab.  
> The app displays the first verse or image, with navigation buttons to move forward or backward through the content.

---

<div class="post-metadata">

**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:** [November 12, 2024, 5:39pm UTC](https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317/2 "2024-11-12T17:39:55Z")

</div>

Hi and welcome to Thunkable!

It’s a lot to expect other users here to read 500 words. It’s helpful if you bold sections and simplify the description a bit to start with. And add line spacing. Otherwise, it’s an uninviting wall of text. I’ve edited it to improve the format of your post.

I would recommend asking ChatGPT or another LLM “Format this for Discourse:” and then having it format your text before posting on the forums.

Are you looking for help or to hire someone to build this for you?

---

<div class="post-metadata">

**Author:** ![zshaalan14b7gfm7](https://avatars.discourse-cdn.com/v4/letter/z/8baadc/32.png) [@zshaalan14b7gfm7](https://community.thunkable.com/u/zshaalan14b7gfm7)\
**Post date:** [November 12, 2024, 5:55pm UTC](https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317/3 "2024-11-12T17:55:17Z")

</div>

no kust explain how to do this step

---

<div class="post-metadata">

**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:** [November 12, 2024, 5:58pm UTC](https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317/4 "2024-11-12T17:58:34Z")

</div>

Dynamic data sources are not really supported in Thunkable. There are workarounds that typically involve using a single data source (sheet) or something like Airtable’s _filterByFormula_ API function.

For help with a List Viewer (now called a Simple List), Google _simple list Thunkable_ and click on the first link for the official tutorial video and documentation.

---

<div class="post-metadata">

**Author:** ![zshaalan14b7gfm7](https://avatars.discourse-cdn.com/v4/letter/z/8baadc/32.png) [@zshaalan14b7gfm7](https://community.thunkable.com/u/zshaalan14b7gfm7)\
**Post date:** [November 12, 2024, 6:00pm UTC](https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317/5 "2024-11-12T18:00:07Z")

</div>

i see thank you so i cant get a sheet and sub sheets

---

<div class="post-metadata">

**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:** [February 10, 2025, 6:00pm UTC](https://community.thunkable.com/t/need-help-with-my-app-data-sorting/3338317/6 "2025-02-10T18:00:39Z")

</div>

Closed on February 10, 2025, 6:00pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
