# \#spreadsheets **URL:** https://community.thunkable.com/tag/spreadsheets/53.md [Latest](https://community.thunkable.com/latest.md) · [Categories](https://community.thunkable.com/categories.md) · [Tags](https://community.thunkable.com/tags.md) --- ## [How to search student details by name from Google Sheet in Thunkable?](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460)
**Author:** [@indilipi.info62syhc](https://community.thunkable.com/u/indilipi.info62syhc)\ **Replies:** 2\ **Last updated:** [May 16, 2025, 9:48pm UTC](https://community.thunkable.com/t/how-to-search-student-details-by-name-from-google-sheet-in-thunkable/3822460 "2025-05-16T21:48:58Z")
Hi everyone, I’m creating an app in Thunkable that is connected to a Google Sheet containing student details. I want to implement a search function as follows: The user enters a student’s name in a Text Input (TextInp… --- ## [Make visible only the user's data in a viewer grid/list](https://community.thunkable.com/t/make-visible-only-the-users-data-in-a-viewer-grid-list/3615957)
**Author:** [@mc3.trabalho3q7lff](https://community.thunkable.com/u/mc3.trabalho3q7lff)\ **Replies:** 0\ **Last updated:** [February 28, 2025, 7:26pm UTC](https://community.thunkable.com/t/make-visible-only-the-users-data-in-a-viewer-grid-list/3615957 "2025-02-28T19:26:52Z")
I have a project that some users need to send their data (picture, text, etc.) but i want to make the data viewer show only the stuff that the user sent. For example: 2 Users sent pictures, but the data viewer is showi… --- ## [How can I collect information from my spreadsheet data source when I select a particular date](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835)
**Author:** [@youngboyzrecord9sr2n](https://community.thunkable.com/u/youngboyzrecord9sr2n)\ **Replies:** 7\ **Last updated:** [December 18, 2024, 4:55pm UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835 "2024-12-18T16:55:39Z")
Please I need help. I have a spreadsheet which is connected to my project where I have DATE, FIRST READING, PSALM, SECOND READIND and so others. see image below Then I created a two screens, one for for the date pic… --- ## ["current minute" and "current date" blocks appears broken?](https://community.thunkable.com/t/current-minute-and-current-date-blocks-appears-broken/2850503)
**Author:** [@wulfy\_starr](https://community.thunkable.com/u/wulfy_starr)\ **Replies:** 7\ **Last updated:** [February 23, 2024, 8:34pm UTC](https://community.thunkable.com/t/current-minute-and-current-date-blocks-appears-broken/2850503 "2024-02-23T20:34:09Z")
i currently have a column to display the current time and date when a new row is created in a google sheet these blocks have worked before, but a problem has started occurring where the time and date blocks display co… --- ## [How to make spreadsheet data for Offline use](https://community.thunkable.com/t/how-to-make-spreadsheet-data-for-offline-use/2754685)
**Author:** [@salmannawaz1724xjqj0](https://community.thunkable.com/u/salmannawaz1724xjqj0)\ **Replies:** 2\ **Last updated:** [December 19, 2023, 1:19pm UTC](https://community.thunkable.com/t/how-to-make-spreadsheet-data-for-offline-use/2754685 "2023-12-19T13:19:08Z")
I have made an app called life hacks where i provided hacks using spreadsheet method and this idea was given by someone on thunkable community so i use it , but now after completion of my app i downloaded apk file and … --- ## [How to change spreadsheet data using an buttion from diffrrent screen](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878)
**Author:** [@salmannawaz1724xjqj0](https://community.thunkable.com/u/salmannawaz1724xjqj0)\ **Replies:** 9\ **Last updated:** [December 15, 2023, 7:51am UTC](https://community.thunkable.com/t/how-to-change-spreadsheet-data-using-an-buttion-from-diffrrent-screen/2741878 "2023-12-15T07:51:33Z")
i have added an language feautures which contain four languages urdu ,spanish, and arabic , filipino , and i make spreedsheets for all of them like life hacks(urdu) life hacks (spanish ) but now i want your help on the w… --- ## [Is this block gonna work?😭](https://community.thunkable.com/t/is-this-block-gonna-work/2739649)
**Author:** [@sommaikaipakkad4nitr](https://community.thunkable.com/u/sommaikaipakkad4nitr)\ **Replies:** 7\ **Last updated:** [December 6, 2023, 2:34am UTC](https://community.thunkable.com/t/is-this-block-gonna-work/2739649 "2023-12-06T02:34:35Z")
Hi. I do this app for school project and i get this problem. I use data from sheet4 that is sorted from sheet1 but if i delete by left swipe for row id “row id” it will take the row id from sheet4 to delete in sheet1. So… --- ## [Data viewer list with multiple sheets - moving from sheet to sheet for data source](https://community.thunkable.com/t/data-viewer-list-with-multiple-sheets-moving-from-sheet-to-sheet-for-data-source/1209728)
**Author:** [@jim.malmberg38](https://community.thunkable.com/u/jim.malmberg38)\ **Replies:** 5\ **Last updated:** [November 5, 2023, 5:17pm UTC](https://community.thunkable.com/t/data-viewer-list-with-multiple-sheets-moving-from-sheet-to-sheet-for-data-source/1209728 "2023-11-05T17:17:10Z")
I’m trying to setup a data viewer list with multiple sheets. What I want to be able to do is drill down through data. I’m using Google sheets for the list. Specifically, I want to have a top sheet that provides a list o… --- ## [If the cell is empty, this command stops. How do I solve this problem?](https://community.thunkable.com/t/if-the-cell-is-empty-this-command-stops-how-do-i-solve-this-problem/2367020)
**Author:** [@mostafa00hammadcomu9](https://community.thunkable.com/u/mostafa00hammadcomu9)\ **Replies:** 1\ **Last updated:** [April 11, 2023, 6:24pm UTC](https://community.thunkable.com/t/if-the-cell-is-empty-this-command-stops-how-do-i-solve-this-problem/2367020 "2023-04-11T18:24:05Z")
--- ## [Problem with insert in a spreedsheet](https://community.thunkable.com/t/problem-with-insert-in-a-spreedsheet/2145982)
**Author:** [@anastasi.fr6w](https://community.thunkable.com/u/anastasi.fr6w)\ **Replies:** 14\ **Last updated:** [November 26, 2022, 9:01am UTC](https://community.thunkable.com/t/problem-with-insert-in-a-spreedsheet/2145982 "2022-11-26T09:01:48Z")
Hello, i have a google spreedsheet (Docenti) with one sheet (inAttesa). inAttesa has this columns: Email,Password,Nome,Cognome,OTP. I need to verify if an email is already inside inAttesa, if there is i only write a m… --- ## [Why does my variable say null when I add values together?](https://community.thunkable.com/t/why-does-my-variable-say-null-when-i-add-values-together/2000597)
**Author:** [@versatile](https://community.thunkable.com/u/versatile)\ **Replies:** 8\ **Last updated:** [September 2, 2022, 1:05pm UTC](https://community.thunkable.com/t/why-does-my-variable-say-null-when-i-add-values-together/2000597 "2022-09-02T13:05:04Z")
My quiz app compares answer entered by users to what I have saved as the Correct answer on the Airtable Spreadsheet,so if it matches,each of the answers Variables will be set to (5),else to (0),so it’s a 3 questions week… --- ## [\[Solved\] Retrieving an old record in spreadsheet](https://community.thunkable.com/t/solved-retrieving-an-old-record-in-spreadsheet/1975384)
**Author:** [@versatile](https://community.thunkable.com/u/versatile)\ **Replies:** 10\ **Last updated:** [August 3, 2022, 7:28am UTC](https://community.thunkable.com/t/solved-retrieving-an-old-record-in-spreadsheet/1975384 "2022-08-03T07:28:46Z")
How can an existing user retrieve his/her username stored in the spreadsheet for the app…this is what I’ve tried so far … The app will loop through the spreadsheet if current userid from Google firebase matches the one … --- ## [How to get total items in a column](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853)
**Author:** [@versatile](https://community.thunkable.com/u/versatile)\ **Replies:** 25\ **Last updated:** [July 28, 2022, 4:02am UTC](https://community.thunkable.com/t/how-to-get-total-items-in-a-column/1969853 "2022-07-28T04:02:57Z")
Am wandering if there is a way to calculate and get the total number of items entered in a column in Airtable Spreadsheet? Just like getting a total number of object created in a column. Thanks for your support --- ## [\[Solved\] how can I create a journal App for multiple users](https://community.thunkable.com/t/solved-how-can-i-create-a-journal-app-for-multiple-users/1964153)
**Author:** [@versatile](https://community.thunkable.com/u/versatile)\ **Replies:** 11\ **Last updated:** [July 19, 2022, 2:43am UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-journal-app-for-multiple-users/1964153 "2022-07-19T02:43:47Z")
Am Working on a Journal app for multiple users,saving items for different categories, such as New note,\*Music composition,\*Sermons of which I will be using a Stored Variable to identify users in the app,but the situation… --- ## [Video preview in app from Spreadsheet](https://community.thunkable.com/t/video-preview-in-app-from-spreadsheet/1963494)
**Author:** [@versatile](https://community.thunkable.com/u/versatile)\ **Replies:** 4\ **Last updated:** [July 15, 2022, 6:10am UTC](https://community.thunkable.com/t/video-preview-in-app-from-spreadsheet/1963494 "2022-07-15T06:10:46Z")
How do i show a video with link from airtable spreadsheet through webviewer in my app,it seems am not getting it,and can’t find an existing post on this either. --- ## [\[Solved\] Displaying images like ads in app from spreadsheet](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124)
**Author:** [@versatile](https://community.thunkable.com/u/versatile)\ **Replies:** 16\ **Last updated:** [July 8, 2022, 11:54am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124 "2022-07-08T11:54:28Z")
How can I retrieve images from spreadsheet and display them one after the other in my app?. currently it displays properly,using the when screen open component,and blocking it to get specific images uploaded to the app … --- ## [Create local datasource or DB from Google sheet](https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733)
**Author:** [@samharradine1994dvlm](https://community.thunkable.com/u/samharradine1994dvlm)\ **Replies:** 2\ **Last updated:** [July 6, 2022, 9:33am UTC](https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733 "2022-07-06T09:33:55Z")
I have searched through a lot of posts but couldn’t find, or didn’t know if I’d found something that would help me. I have my app connected to google sheets which is working, however it is slow when creating and display… --- ## [\[Resolved\] Thunkable graphql error when trying to get data from tab in google sheets](https://community.thunkable.com/t/resolved-thunkable-graphql-error-when-trying-to-get-data-from-tab-in-google-sheets/1893876)
**Author:** [@939sbroadway1a9rm2](https://community.thunkable.com/u/939sbroadway1a9rm2)\ **Replies:** 2\ **Last updated:** [May 28, 2022, 9:45pm UTC](https://community.thunkable.com/t/resolved-thunkable-graphql-error-when-trying-to-get-data-from-tab-in-google-sheets/1893876 "2022-05-28T21:45:43Z")
I have a google sheets as a data source with several tabs ~6. All tabs except one are able to sync. The one tab that has issues keeps giving me an “unable to sync” This is wierd because it’s only one tab of the goo… --- ## [How to save data from Realtime Database to Google Spreadsheet (or other place)](https://community.thunkable.com/t/how-to-save-data-from-realtime-database-to-google-spreadsheet-or-other-place/1397988)
**Author:** [@laura.quraishk5](https://community.thunkable.com/u/laura.quraishk5)\ **Replies:** 11\ **Last updated:** [December 11, 2021, 12:27pm UTC](https://community.thunkable.com/t/how-to-save-data-from-realtime-database-to-google-spreadsheet-or-other-place/1397988 "2021-12-11T12:27:31Z")
Hi Thunkable community, I am working on a stress-reducing app for a graduate research project. I want my users to track their stress levels from 0-10, stress triggers, and stress reactions daily. I am a tech newbie, bu… --- ## [Google sheets - get row ID where value is](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849)
**Author:** [@ondracehak1](https://community.thunkable.com/u/ondracehak1)\ **Replies:** 3\ **Last updated:** [September 12, 2021, 7:00am UTC](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849 "2021-09-12T07:00:36Z")
Hi! I really need your help :slight\_smile: i dont know how get id of row, where is specific value. I am using google spreadaheet Example: My\_id | Value 6283 | yes 2891 | Yes 3728 | Yes And now, i want to change r… --- ## [Number of columns in Google Sheets](https://community.thunkable.com/t/number-of-columns-in-google-sheets/1442400)
**Author:** [@lavrynenko](https://community.thunkable.com/u/lavrynenko)\ **Replies:** 5\ **Last updated:** [August 10, 2021, 6:28pm UTC](https://community.thunkable.com/t/number-of-columns-in-google-sheets/1442400 "2021-08-10T18:28:34Z")
Friends, please tell me, is there any way to calculate the Number of columns with information in Google Sheets? Thank you! --- ## [Creating a row in Google Sheets with an empty cell](https://community.thunkable.com/t/creating-a-row-in-google-sheets-with-an-empty-cell/1436945)
**Author:** [@lavrynenko](https://community.thunkable.com/u/lavrynenko)\ **Replies:** 2\ **Last updated:** [August 8, 2021, 11:17am UTC](https://community.thunkable.com/t/creating-a-row-in-google-sheets-with-an-empty-cell/1436945 "2021-08-08T11:17:23Z")
Friends, is there any method for creating a row in GoogleTables, in which one of the cells will not receive any values? Those - we create a row, fill in cell A, and cell B remains empty. Is it possible? --- ## [Connecting to Google sheets](https://community.thunkable.com/t/connecting-to-google-sheets/1417425)
**Author:** [@baquang2910l0mkv](https://community.thunkable.com/u/baquang2910l0mkv)\ **Replies:** 4\ **Last updated:** [July 30, 2021, 7:32am UTC](https://community.thunkable.com/t/connecting-to-google-sheets/1417425 "2021-07-30T07:32:07Z")
Hi Everyone, Seem google sheet function getting problem, it is not responding even though I tried to use it at Firefox, Chrome and also refresh browser, clear cache… but it doesn’t work. Is there anyone who has the same… --- ## [How can I filter a Google Sheets data source by certain factors?](https://community.thunkable.com/t/how-can-i-filter-a-google-sheets-data-source-by-certain-factors/1292821)
**Author:** [@kartik14](https://community.thunkable.com/u/kartik14)\ **Replies:** 5\ **Last updated:** [May 19, 2021, 8:42am UTC](https://community.thunkable.com/t/how-can-i-filter-a-google-sheets-data-source-by-certain-factors/1292821 "2021-05-19T08:42:39Z")
Hi, there :wave: I hope you are doing well! First off, let me explain the structure of my spreadsheet/database : There are 10 columns, and I want to filter the rows by 3 values - Provisions, District & Tehsil. What… --- ## [\[Solved\] How do I use Google Sheets on a device?](https://community.thunkable.com/t/solved-how-do-i-use-google-sheets-on-a-device/1273924)
**Author:** [@sketch](https://community.thunkable.com/u/sketch)\ **Replies:** 24\ **Last updated:** [May 11, 2021, 8:36am UTC](https://community.thunkable.com/t/solved-how-do-i-use-google-sheets-on-a-device/1273924 "2021-05-11T08:36:12Z")
Hello everyone! Hope evryone is doing wel. I have a bit of a problem. I’ve created a random qoute system that uses google sheet to get the qoutes and then displays a random qoute in the button. It works as supposed … --- ## [\[Solved\] Connect to google sheets "metaDataFromDataSource.forEach is not a function"](https://community.thunkable.com/t/solved-connect-to-google-sheets-metadatafromdatasource-foreach-is-not-a-function/1255234)
**Author:** [@nmtabooks](https://community.thunkable.com/u/nmtabooks)\ **Replies:** 2\ **Last updated:** [April 30, 2021, 2:42pm UTC](https://community.thunkable.com/t/solved-connect-to-google-sheets-metadatafromdatasource-foreach-is-not-a-function/1255234 "2021-04-30T14:42:08Z")
I couldn’t connect to my google sheets, I did almost every trick I found it the community forum. lastly I went to chat with support team… till now there no solution, am I have been waiting for hours on the chat box…waiti… --- ## [Data viewer grid not working](https://community.thunkable.com/t/data-viewer-grid-not-working/1112360)
**Author:** [@dezynationindia](https://community.thunkable.com/u/dezynationindia)\ **Replies:** 1\ **Last updated:** [February 20, 2021, 7:39pm UTC](https://community.thunkable.com/t/data-viewer-grid-not-working/1112360 "2021-02-20T19:39:16Z")
I made an app using the data viewer grid that fetches some images of games and their respective links from the Google Sheets document saved on the drive. After publishing the app on Play Store, I’ve removed Thunkable’s a… --- ## [Showing/hiding records in Data Viewer based on keyword in a specified column](https://community.thunkable.com/t/showing-hiding-records-in-data-viewer-based-on-keyword-in-a-specified-column/1070060)
**Author:** [@hazhalim](https://community.thunkable.com/u/hazhalim)\ **Replies:** 5\ **Last updated:** [January 27, 2021, 10:50am UTC](https://community.thunkable.com/t/showing-hiding-records-in-data-viewer-based-on-keyword-in-a-specified-column/1070060 "2021-01-27T10:50:26Z")
Hey y’all, Recently, I tried to make a Data Viewer List (with Google Sheets) for my project with filters (using switches)… I’ve never done this before so I was kind of just trying to butcher it and see if it could work.… --- ## [Is there a component to copy an existing Google Sheet?](https://community.thunkable.com/t/is-there-a-component-to-copy-an-existing-google-sheet/1041779)
**Author:** [@overshield](https://community.thunkable.com/u/overshield)\ **Replies:** 9\ **Last updated:** [December 26, 2020, 11:35pm UTC](https://community.thunkable.com/t/is-there-a-component-to-copy-an-existing-google-sheet/1041779 "2020-12-26T23:35:19Z")
I’m trying to allow users to have their own database. I’m using Google Sheets because there are a lot of complicated formulas that I don’t think Airtable has, I don’t know how to write Airtable’s formulas regardless. I… --- ## [List viewer from google sheets](https://community.thunkable.com/t/list-viewer-from-google-sheets/988426)
**Author:** [@marketandsellbuy8jcb](https://community.thunkable.com/u/marketandsellbuy8jcb)\ **Replies:** 5\ **Last updated:** [November 28, 2020, 8:40pm UTC](https://community.thunkable.com/t/list-viewer-from-google-sheets/988426 "2020-11-28T20:40:52Z")
In google sheets I have 3 country Each country have 6 column’s Users will choose the list from 6 column’s in countries . How I give in list or data viewer what the user choose … [Next page](https://community.thunkable.com/tag/spreadsheets/53.md?match_all_tags=true&page=1&tags%5B%5D=spreadsheets)