# Form submission does not show in google sheets **URL:** \ **Category:** Ask for Help\ **Created:** [May 6, 2021, 6:04pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498 "2021-05-06T18:04:55Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Karel\_van\_Biervliet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karel_van_biervliet/32/5501_2.png) [@Karel\_van\_Biervliet](https://community.glideapps.com/u/Karel_van_Biervliet)\ **Post date:** [May 6, 2021, 6:04pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/1 "2021-05-06T18:04:55Z")
Hey there, I am having an issue with a form submission. I can see the inputted values in the data view of glide, but strangly I cannot see it in the google sheet itself. What is even stranger is that apparantly zapier does see the new row since it triggers my requested result. Can anyone help. I looked on the forum. But do not see the exact issue. thanks ---
**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:** [May 6, 2021, 6:06pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/2 "2021-05-06T18:06:36Z")
Scroll down to the end of your Google Sheet ---
**Author:** ![Karel\_van\_Biervliet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karel_van_biervliet/32/5501_2.png) [@Karel\_van\_Biervliet](https://community.glideapps.com/u/Karel_van_Biervliet)\ **Post date:** [May 6, 2021, 6:14pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/3 "2021-05-06T18:14:20Z")
Damn, thanks, sorry David, rookie mistake. The formatting however is not taken as the rest of the rows. Which creates someting strange in the zapier generated document. I tried formatting in Glide but that does not work well the € are not taken and the % is not possible. Any pointers on how to solve that? ---
**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:** [May 6, 2021, 11:35pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/4 "2021-05-06T23:35:42Z")
This happens when you have empty rows in your Sheet, so I would advise temporarily turning off your Zap and delete all empty rows, then turn it back on. Can you clarify more on the formatting? If you are triggering based on new rows in Sheets, you should make sure the formatting in the Sheet is correct. ---
**Author:** ![Karel\_van\_Biervliet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karel_van_biervliet/32/5501_2.png) [@Karel\_van\_Biervliet](https://community.glideapps.com/u/Karel_van_Biervliet)\ **Post date:** [May 7, 2021, 8:39am UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/5 "2021-05-07T08:39:49Z")
Unfortunately that does not work. Just tried it. A new row takes new formatting. and not the one of all the previous rows. Picture shows all the rows and the last entry: 1. Montery values become just numbers 2. Percentages become just numbers (which is really annoying for a reader of the zapier generated document. ![glide issue formatting](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3affead30b5c09c228ecf279c2faf50a69d49c7d.png) ---
**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:** [May 7, 2021, 9:17am UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/6 "2021-05-07T09:17:51Z")
Oh, should have said the first paragraph refers to only the reason you were seeing rows at the bottom of the Sheet. Regarding the formatting, are you using a Sheet format to include those euros symbols? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 7, 2021, 9:21am UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/7 "2021-05-07T09:21:28Z")
do you have any arrayformula in that sheet? or you cut rows to the last entry? ---
**Author:** ![Karel\_van\_Biervliet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karel_van_biervliet/32/5501_2.png) [@Karel\_van\_Biervliet](https://community.glideapps.com/u/Karel_van_Biervliet)\ **Post date:** [May 7, 2021, 9:40am UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/8 "2021-05-07T09:40:01Z")
Thanks Thinh & Uzo for the help, I use arrayformula’s and I have formatted the google sheet **colums** to be: 1. numbers (if it is a number) 2. valuta (if it’s a euro amount) 3. percentage (if it is a percentage) The strange thing is that when a row is added on form submission it “forgets” the formatting in google sheets. I would really appreciate any help with the solution. Cheers, Karel ---
**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:** [May 7, 2021, 12:43pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/9 "2021-05-07T12:43:47Z")
When you apply the formatting, do you highlight the column by selecting each cell in that column, or do you click on the column header to select the whole column at once? I’ve had this happen to me a long time ago (and maybe still does), but I also stopped relying on the google sheet for formatting and only rely on it for data storage. Either way, I try to make sure the formatting is applied to the column as a whole instead of picking all cells in the column. Hope they makes sense. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 7, 2021, 12:55pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/10 "2021-05-07T12:55:05Z")
> [@Jeff\_Hager](#): > > Either way, I try to make sure the formatting is applied to the column as a whole instead of picking all cells in the column. I’ve found that even this doesn’t always work. Anytime I really need to enforce column formatting, I’ll usually just include a `setNumberFormat()` call somewhere in a trigger script. ---
**Author:** ![Karel\_van\_Biervliet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karel_van_biervliet/32/5501_2.png) [@Karel\_van\_Biervliet](https://community.glideapps.com/u/Karel_van_Biervliet)\ **Post date:** [May 7, 2021, 12:58pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/11 "2021-05-07T12:58:21Z")
Thanks for the tip, but to no avail. That is what I have done. It still does not keep the number formatting. It makes glide unfortunately complete useless for my desired use case. ---
**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:** [May 7, 2021, 1:25pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/12 "2021-05-07T13:25:24Z")
In a case like that, I would probably create additional columns with arrayformulas that create the formatting in the formula. It’s not ideal, but you would be guaranteed the the proper format would be applied to each new row, and hopefully your zap doesn’t need too many of those columns. ---
**Author:** ![Karel\_van\_Biervliet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karel_van_biervliet/32/5501_2.png) [@Karel\_van\_Biervliet](https://community.glideapps.com/u/Karel_van_Biervliet)\ **Post date:** [May 7, 2021, 1:56pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/13 "2021-05-07T13:56:59Z")
I think I found the solution: > This script seems to work. Thanks for the help everyone. Greetz, Karel ---
**Author:** ![Karel\_van\_Biervliet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karel_van_biervliet/32/5501_2.png) [@Karel\_van\_Biervliet](https://community.glideapps.com/u/Karel_van_Biervliet)\ **Post date:** [May 7, 2021, 5:25pm UTC](https://community.glideapps.com/t/form-submission-does-not-show-in-google-sheets/26498/14 "2021-05-07T17:25:35Z")
I spoke too early, it takes the formatting. Not the number formatting🥶