# FORM data writing to Glide but NOT to Google Sheet **URL:** \ **Category:** Report a Bug\ **Created:** [July 6, 2020, 10:17pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076 "2020-07-06T22:17:01Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 6, 2020, 10:17pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/1 "2020-07-06T22:17:01Z")
Very strange. 43s video here [https://share.vidyard.com/watch/XxDZxRL3foQ6z88A3FPHDn](https://share.vidyard.com/watch/XxDZxRL3foQ6z88A3FPHDn)? ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 6, 2020, 10:26pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/2 "2020-07-06T22:26:52Z")
Have You Tried reloading both glide and google sheets ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 6, 2020, 10:28pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/3 "2020-07-06T22:28:47Z")
Yup! and rebooted my computer, and deleted the tab that isn’t being written to and recreated it. ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 6, 2020, 10:30pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/4 "2020-07-06T22:30:04Z")
@Jeff_Hager Have any ideas ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [July 6, 2020, 10:31pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/5 "2020-07-06T22:31:26Z")
Can you please share a link to your app and add [david@glideapps.com](mailto:david@glideapps.com) to your sheet so I can take a look? ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 6, 2020, 10:31pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/6 "2020-07-06T22:31:49Z")
Done! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 6, 2020, 10:32pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/7 "2020-07-06T22:32:26Z")
My only idea would be to check the bottom of the sheet, but you’ve obviously done that already. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [July 6, 2020, 10:33pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/8 "2020-07-06T22:33:57Z")
I scrolled down to the bottom of your sheet and saw all of the data. ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 6, 2020, 10:34pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/9 "2020-07-06T22:34:31Z")
Haha ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 6, 2020, 10:34pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/10 "2020-07-06T22:34:57Z")
you can actually scroll that long ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 6, 2020, 10:35pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/11 "2020-07-06T22:35:25Z")
Welll, I am really bad at excel and I scrolled down to row 1000 (obviously not far enough). nevertheless, why is it writing way down on the sheet? Did I do something wrong? ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [July 6, 2020, 10:36pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/12 "2020-07-06T22:36:18Z")
The reason is that `=ARRAYFORMULA(if(B:B<>"",randbetween(1,10),""))` makes all of the rows that look empty to our eyes, look not-empty to Google Sheet. Try `=ARRAYFORMULA(if(B:B<>"",randbetween(1,10), ))` with just empty space instead of `""`. More info in our docs: [https://docs.glideapps.com/all/guides/quick-starts/getting-started/adding-items#prepare-your-sheet-for-adding-by-deleting-empty-rows](https://docs.glideapps.com/all/guides/quick-starts/getting-started/adding-items#prepare-your-sheet-for-adding-by-deleting-empty-rows) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [July 6, 2020, 10:37pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/13 "2020-07-06T22:37:15Z")
The way I would write your arrayformula: `=ARRAYFORMULA(if(LEN(B2:B) = 0, ,randbetween(1,10)))` Regardless, we suggest deleting all the empty rows Google puts in your sheet by default. ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 6, 2020, 10:37pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/14 "2020-07-06T22:37:41Z")
Got it. Thank you so much! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 6, 2020, 10:38pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/15 "2020-07-06T22:38:36Z")
So not filling the value for Len 0 takes care of the need to delete empty rows? Never thought of that. ---
**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\ **Post date:** [July 6, 2020, 10:53pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/16 "2020-07-06T22:53:22Z")
Thanks for clarifying @david . I had the same issue with blank rows yesterday and I just deleted the rows. But this explains the reason for blank rows. ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 6, 2020, 10:54pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/17 "2020-07-06T22:54:31Z")
I’m going to take a basic course in Excel so I can have an easier time learning Glide. Thanks and sorry for the false bug report! :-))) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [July 6, 2020, 10:55pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/18 "2020-07-06T22:55:17Z")
The technical explanation is, Glide asks Google Sheets “please add this new row to sheet X” and Google Sheets thinks “I see this sheet has 1000 rows! let me add a new row, #1001” — it’s weird. Google Sheets considers empty rows to be perfectly valid rows. ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [July 6, 2020, 11:33pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/19 "2020-07-06T23:33:09Z")
So that means it counts towards the row limitation by glide ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 6, 2020, 11:52pm UTC](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/20 "2020-07-06T23:52:47Z")
No I don’t think it’s that way. Glide still doesn’t count the empty rows, but as David said Google sees them as valid rows and just skips them. [Next page](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076.md?page=2)