# Form data not showing in Google Sheet
**URL:** https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260
**Category:** Report a Bug
**Created:** [January 2, 2020, 1:33pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260 "2020-01-02T13:33:47Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@chrishoward](https://community.glideapps.com/u/chrishoward)
#### Post date: [January 2, 2020, 1:33pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/1 "2020-01-02T13:33:47Z")
I’ve set up a form and set it to save to the same sheet. However, it’s not showing there. But, it does show in the Glide Data view. See in attached images the Sheet one doesn’t have the 2 Jan entry which I added using a form.
 
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 2, 2020, 1:36pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/2 "2020-01-02T13:36:34Z")
Is it there is you scroll down to the bottom of the sheet?
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [January 2, 2020, 2:05pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/3 "2020-01-02T14:05:21Z")
By bottom @Jeff_Hager means all the way past all the empty rows, most likely at row 1001 or 1002… if you still started with the default 1000 rows.
---
### Author:  [@chrishoward](https://community.glideapps.com/u/chrishoward)
#### Post date: [January 3, 2020, 4:18am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/4 "2020-01-03T04:18:07Z")
Thanks, yes, it is right at the bottom of the sheet (row 22545)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 3, 2020, 12:44pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/5 "2020-01-03T12:44:47Z")
If you are using an arrayformula, you’ll need to delete all empty rows. Glide will append new rows as needed. Even though a row appears empty, a formula is still enough for it to be considered filled.
---
### Author:  [@boomage](https://community.glideapps.com/u/boomage)
#### Post date: [March 22, 2020, 4:12am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/6 "2020-03-22T04:12:07Z")
I had this same issue and this post solved it. Mahalo!
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [March 22, 2020, 1:16pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/7 "2020-03-22T13:16:55Z")
Please delete all your empty rows. Apart from causing this issue, they also make reloading your spreadsheet slower.
---
### Author:  [@boomage](https://community.glideapps.com/u/boomage)
#### Post date: [March 22, 2020, 6:28pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/8 "2020-03-22T18:28:23Z")
I sure did! Mahalo…
---
### Author:  [@RyanM](https://community.glideapps.com/u/RyanM)
#### Post date: [April 16, 2020, 7:15am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/9 "2020-04-16T07:15:52Z")
Hi All
Hoping to get some help on this same topic. I followed all the steps above and deleted all empty rows in Google Sheets. Only thing that exists are the column headers. A few notes:
1. I’ve been testing the form on my phone, and getting no results to show up in either the Google Sheet or within Glide Data.
2. When testing the form on Glide (on my computer), I get results to show up in Glide Data, but not Google Sheets.
Any advice here. Thanks so much in advance.
---
### Author:  [@RyanM](https://community.glideapps.com/u/RyanM)
#### Post date: [April 16, 2020, 7:16am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/10 "2020-04-16T07:16:24Z")
Follow up picture of the Glide Data showing it correctly arrives.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 16, 2020, 5:33pm UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/11 "2020-04-16T17:33:24Z")
Gonna ask some obvious questions. Are you looking at the correct Google sheet? Does your reload button in the builder have a yellow triangle?
---
### Author:  [@RyanM](https://community.glideapps.com/u/RyanM)
#### Post date: [April 21, 2020, 2:51am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/12 "2020-04-21T02:51:09Z")
1. I am looking at the correct Google Sheet
2. No, I do not have the yellow triangle.
A couple things I’m thinking it may be and making a complete guess:
1. My sheets are protected on the Google Sheet. Would this prevent Glide from ‘back-editing’ the Sheet on the ACTUAL Google Sheet?
2. Is there a ‘publish’ process to make the form live and working on my phone?
3. Do I need to edit the Data Type of the destination column so that it can save the data in the right format (i.e Date field, text, num, etc)
I am still getting the same errors at this point. Thanks for the help!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 21, 2020, 3:20am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/13 "2020-04-21T03:20:45Z")
It should just work without doing anything special. Keep in mind that you usually need to close and reopen the app on your phone if you are making any design changes to the app. Data should flow through, no problem.
I’ve protected certain columns in my app without issue, but I don’t think I’ve ever protected an entire sheet. Might be worth trying to unprotect it to see if that makes a difference.
Again, it sounds like you are doing everything correctly, but there’s not much more I can personally diagnose.
---
### Author:  [@RyanM](https://community.glideapps.com/u/RyanM)
#### Post date: [April 21, 2020, 3:29am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/14 "2020-04-21T03:29:53Z")
Thanks Jeff.
One question: what is this ‘Data’ option used for?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 21, 2020, 3:33am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/15 "2020-04-21T03:33:00Z")
The source section is where you pick the sheet and column that contains your list of choices.
The data section is the column you want to fill with the selected choice on your form sheet.
---
### Author:  [@RyanM](https://community.glideapps.com/u/RyanM)
#### Post date: [April 21, 2020, 3:46am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/16 "2020-04-21T03:46:56Z")
> The data section is the column you want to fill with the selected choice on your form sheet.
on the destination sheet?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 21, 2020, 3:58am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/17 "2020-04-21T03:58:56Z")
Yes.
[https://docs.glideapps.com/all/reference/components/pickers/choice](https://docs.glideapps.com/all/reference/components/pickers/choice)
---
### Author:  [@RyanM](https://community.glideapps.com/u/RyanM)
#### Post date: [April 21, 2020, 4:11am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/18 "2020-04-21T04:11:55Z")
Thanks Jeff. That is really helpful.
I am still struggling with the form writing back to the Google Sheet. Have you ever experienced this yourself? I created an entirely separate Source Sheet and Destination Sheet and made both unprotected, yet still not getting updates.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 21, 2020, 4:16am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/19 "2020-04-21T04:16:10Z")
I’ve never had an issue like that. If you place data on the sheet directly, does it sync into glide? Can you share your app and make it copyable?
---
### Author:  [@RyanM](https://community.glideapps.com/u/RyanM)
#### Post date: [April 21, 2020, 4:20am UTC](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260/20 "2020-04-21T04:20:13Z")
Yes, if I enter any data on the Sheet it updates Glide and insert as a new record.
[Next page](https://community.glideapps.com/t/form-data-not-showing-in-google-sheet/3260.md?page=2)