# Form Not Recording New Entry **URL:** \ **Category:** Ask for Help\ **Created:** [July 6, 2020, 11:50pm UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081 "2020-07-06T23:50:36Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 6, 2020, 11:50pm UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/1 "2020-07-06T23:50:36Z")
Hi everyone! Looking for some help on a form that seems to have stopped recording or saving info of a assessment / questionnaire that I have created. The first couple of tests worked with no issues but now it has just stopped entering any data. I have refreshed, tried it in a different browser, computer, reset the special values columns (email, unique ID, calendar) and still nothing. There are over 200 questions all of which are check boxes… so I am not sure if the number of checkboxes may have something to do with it? Any help would be greatly appreciated. @eltintero ---
**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:51pm UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/2 "2020-07-06T23:51:17Z")
Can you try scrolling down the sheet to see if the new rows are being recorded down there? ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 6, 2020, 11:53pm UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/3 "2020-07-06T23:53:10Z")
Bingo!!! Thank you so much! How do I get them to stop going all the way down at the bottom? ---
**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:55pm UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/4 "2020-07-06T23:55:40Z")
You can remove all the empty rows. The problem with Google is that they see empty rows as valid rows and skips them when writing new ones to the Sheet. > [@FORM data writing to Glide but NOT to Google Sheet](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076/18): > > 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:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 6, 2020, 11:59pm UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/5 "2020-07-06T23:59:31Z")
Thank you so much for this! I think I know when it started to happen now. I need to calculate the total of checkboxes for each new row and I did that in Google Sheets for future entries. Any suggestions on how to do calculations for future entries? Should I use Glide’s Data instead of Google Sheets? ---
**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 7, 2020, 12:01am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/6 "2020-07-07T00:01:07Z")
When you say total checkboxes do you mean the number of TRUE values? ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 7, 2020, 12:04am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/7 "2020-07-07T00:04:30Z")
Yes. I have different sections that I need to get a count of the number of TRUE boxes checked. ---
**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 7, 2020, 12:05am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/8 "2020-07-07T00:05:26Z")
How are you counting that for now? Do you have an Arrayformula? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [July 7, 2020, 12:06am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/9 "2020-07-07T00:06:00Z")
You can do this with the Rollup function in Glide, but this won’t write to the sheet. If you want to do it in the sheet, use an Arrayformula so it captures the whole column, even when new entries are added. ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 7, 2020, 12:12am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/10 "2020-07-07T00:12:33Z")
Right now it is just counting the cells for the TRUE value into different columns for each section ---
**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 7, 2020, 12:15am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/11 "2020-07-07T00:15:09Z")
And now you want to count all TRUE values, let’s say from the 4th column to the 100th column, or is there a different use case here? ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 7, 2020, 12:17am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/12 "2020-07-07T00:17:55Z")
There are about 250 questions and for each section there are 7-13 questions for each one. At the end of the spreadsheet there are columns that are totaling up the TRUE count for those sections. Hope that makes sense? ---
**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 7, 2020, 12:19am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/13 "2020-07-07T00:19:59Z")
How many sections do you have, and in each section in average how many questions are there? I am having some options in my mind and will let you know. ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 7, 2020, 12:33am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/14 "2020-07-07T00:33:53Z")
22 sections or columns to determine the TRUE value count As an example - Section A has 12 questions which are checkboxes (TRUE). At the end of the really long spreadsheet there is a column for Section A that displays the number of TRUE ---
**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 7, 2020, 12:36am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/15 "2020-07-07T00:36:21Z")
Let’s say in section 1 you count the TRUE values for columns C to F. The formula to put in the 1st cell of the column would be. ``` ={"Section A count";ARRAYFORMULA(IF(A2:A<>"",(C2:C=TRUE)+(D2:D=TRUE)+(E2:E=TRUE)+(F2:F=TRUE),""))} ``` ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 7, 2020, 12:40am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/16 "2020-07-07T00:40:27Z")
I have never done an ARRAYFORMULA before, what do you use them for? Also, can’t you tell the formula to do C through F or do you have to type each column? ---
**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 7, 2020, 12:42am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/17 "2020-07-07T00:42:05Z")
Here’s a post I wrote about it. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … There might be a better solution, that’s why I asked how many columns do you have for each section because it might get ugly when you have too many. However you only do that once and from then it’s automatic. ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 7, 2020, 12:43am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/18 "2020-07-07T00:43:28Z")
Thank you I will look into it. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [July 7, 2020, 12:44am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/19 "2020-07-07T00:44:17Z")
Derek, please share the link to you app and mention or screenshot the form not working. Jesus A. ---
**Author:** ![Derek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/derek/32/9476_2.png) [@Derek](https://community.glideapps.com/u/Derek)\ **Post date:** [July 7, 2020, 12:53am UTC](https://community.glideapps.com/t/form-not-recording-new-entry/12081/20 "2020-07-07T00:53:31Z")
@eltintero, I found the issue with the “not saving new entries” thanks to @ThinhDinh but now I need to tell glide to count the number of TRUE for each vitamin in the column for that vitamin total. I previously had Google Sheets with an infinite rows with the formula to count the number of TRUE values but Glide kept adding all the new entries at the bottom. So what I need help on now is to tell Glide to count various columns to get a total for - every time a person enters a new questionnaire. Any ideas @eltintero [Next page](https://community.glideapps.com/t/form-not-recording-new-entry/12081.md?page=2)