# Form button not adding row to sheet **URL:** \ **Category:** Report a Bug\ **Created:** [November 21, 2019, 7:07am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234 "2019-11-21T07:07:39Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Todd57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd57/32/600_2.png) [@Todd57](https://community.glideapps.com/u/Todd57)\ **Post date:** [November 21, 2019, 7:07am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/1 "2019-11-21T07:07:39Z")
My app’s URL: [https://lpnir.glideapp.io](https://lpnir.glideapp.io) I’ve been pulling my hair out trying to figure out what’s causing this. I’m building a scheduling/billing app for my son’s lawn care business. It has 4 main tabs: Customers, Yards, Jobs, and Billing. I use one tab as the home screen. All other tabs are accessible through the pullout menu. On the main page, upcoming jobs are listed in calendar view. To schedule a job, I have a button on the main page that takes you to a list of customers. You select the customer, then select one of their yards, then click a Form Button to schedule the job for that yard. The form pulls in attributes from the yard record, and you select a date/time before submitting. For some reason, when submitting the form, the new row never gets added to the sheet. I don’t have any formulas on that sheet. I do have an installable trigger for OnChange events, but I don’t think this is the culprit, as the problem exists when disabling that trigger. All other form buttons work within this app that write to other sheets. I can even edit existing records in the Jobs sheet using the edit function. Adding Jobs using the + symbol in the top right corner doesn’t work either. It should be noted that I have several Lookup and Template fields which were added in the Data editor within Glide. I came across a thread that mentioned a bug with lookup fields blocking new rows, so it may be related. I’ve attached a copy of my app, stripped down and user data removed to protect the innocent. Please take a look at it to see if it’s something in my design, so I can stop messing with this app and let my son start using it. Thanks, Todd ---
**Author:** ![Todd57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd57/32/600_2.png) [@Todd57](https://community.glideapps.com/u/Todd57)\ **Post date:** [November 21, 2019, 3:42pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/2 "2019-11-21T15:42:13Z")
Maybe this will help explain what I’m seeing. I get kind of long-winded when I try to explain things. 😉 ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [November 21, 2019, 4:56pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/3 "2019-11-21T16:56:12Z")
Sorry, I can’t help, but that’s a pretty cool app. I hope you get your solution soon. ---
**Author:** ![Todd57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd57/32/600_2.png) [@Todd57](https://community.glideapps.com/u/Todd57)\ **Post date:** [November 21, 2019, 5:15pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/4 "2019-11-21T17:15:18Z")
Thanks. I’ve been working on it for a while. I’m so ADD that every time Glide pushes out new updates, I think I have to incorporate them into my app. Most of the time I end up breaking things, and spend way too much time making things work again. I’m pretty sure that this Form Button issue has something to do with the amount of lookup columns I have in the Jobs sheet in Data Editor. I may try to dumb it down a little to see if that gives me back the New Row feature. ---
**Author:** ![Todd57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd57/32/600_2.png) [@Todd57](https://community.glideapps.com/u/Todd57)\ **Post date:** [November 22, 2019, 10:10pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/5 "2019-11-22T22:10:59Z")
Anyone? @david Has this been reported before? Can someone take a look at the data editor in my app to see if there’s some kind of conflict on the Jobs sheet? Thanks for any feedback. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 22, 2019, 10:38pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/6 "2019-11-22T22:38:35Z")
I’m looking at it. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 22, 2019, 11:11pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/7 "2019-11-22T23:11:58Z")
This is a Glide bug. We’ll fix it soon. Sorry. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 23, 2019, 12:06am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/8 "2019-11-23T00:06:31Z")
Should be fixed. Thank you for reporting! ---
**Author:** ![Todd57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd57/32/600_2.png) [@Todd57](https://community.glideapps.com/u/Todd57)\ **Post date:** [November 23, 2019, 1:40am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/9 "2019-11-23T01:40:58Z")
Thank you!!! I was about to rebuild that whole sheet, because I thought I had too much going on in it. Sorry you had to see that mess. lol. I can probably make it cleaner, I just keep thinking of new ways to do things as I learn more about this awesome platform. And you guys keep adding cool new features that I want to incorporate. Thanks again!! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 23, 2019, 2:33am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/10 "2019-11-23T02:33:15Z")
It’s exciting to see you push the limits of Glide. 🙂 ---
**Author:** ![Lighted\_Candle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lighted_candle/32/29544_2.png) [@Lighted\_Candle](https://community.glideapps.com/u/Lighted_Candle)\ **Post date:** [November 24, 2019, 12:58am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/11 "2019-11-24T00:58:45Z")
I looked under the hood of your app and it seems to be missing a few References and formulas to make it function smoothly. I couldn’t understand the formulas and the flow, but it was easier for me to rebuild the app myself using my own formulas and links and it seems to be working fine. You can check it out here [https://lawnpro.glideapp.io](https://lawnpro.glideapp.io) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 24, 2019, 1:12am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/12 "2019-11-24T01:12:13Z")
You didn’t make it copyable so the OP can take his look under the covers of what you did. ---
**Author:** ![Lighted\_Candle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lighted_candle/32/29544_2.png) [@Lighted\_Candle](https://community.glideapps.com/u/Lighted_Candle)\ **Post date:** [November 24, 2019, 1:24am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/13 "2019-11-24T01:24:00Z")
Thanks ---
**Author:** ![Todd57](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd57/32/600_2.png) [@Todd57](https://community.glideapps.com/u/Todd57)\ **Post date:** [November 24, 2019, 8:02pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/14 "2019-11-24T20:02:03Z")
I guess there is more than one way to skin a cat. I don’t do any of the old column relation syntax in sheets. All of my relations and lookup info is in the Glide Data Editor. I like to assign unique IDs, now that they are available, for each record and reference them for relations. Then I create lookup columns to pull in data from the related sheets that I need to see in the detail views. I guess I try to keep it as much like a relational database as I can. I know it’s messy looking, but I didn’t start from scratch with all the tools that are currently available in Glide. This has sort of been my learning app. When I learn how to do something new, I use this app to try it out. I did like your take on the app. My son doesn’t charge set prices for each service. He just bids the job with one price. I can see where that would be useful, though. ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [December 24, 2019, 3:13pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/15 "2019-12-24T15:13:46Z")
Hello, sorry to bring back an (old) bug, but my sheet does not update when submitting a form. I cannot share the app due to names, addresses, and phone numbers in the sheet. However, the sheet does contain some ArrayFormulas for computing date and time. The submission shows up in the Glide Data screen but not on the actual spreadsheet. And yet, the ArrayFormulas work just fine in the app builder, displaying as intended. Did I miss something? I have a strong feeling that the ArrayFormulas are getting in the way of a proper form submit. ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [December 24, 2019, 5:51pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/16 "2019-12-24T17:51:53Z")
look your new row is not at the very bottom of the sheet ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [December 24, 2019, 7:32pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/17 "2019-12-24T19:32:27Z")
As @Gerard_Fernandez says look at the very bottom of all your empty rows. When you use an array formula in a column and Google appends a row of data, it sees something in all the rows of the sheet because of the arrayformulas. So in order to add it appends an additional row to the very end. All sheets that have arrayformulas should be set up with no empty rows. As rows are added via Glide they will just be appended to the end and no gaps of empty rows will be seen. ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [December 24, 2019, 8:51pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/18 "2019-12-24T20:51:00Z")
@Gerard_Fernandez, @George_B, what you guys say is correct and is clearly understood. However, the sheet only has 2 rows with data. I’ve gone through the steps of erasing any ghost rows and columns. So it would be hard to array additional rows when the rest of the sheet is completely empty. As a matter of fact, when a new row with data is entered where an arrayformula intersects, an error is raised, saying that it cannot overwrite data in an already populated cell for that column/row. I really do believe that Glide thinks there is data and is indeed appending the row to the bottom of sheet, wherever that may be. EDIT: After deleting all of the contents up to the new row entry, it seems as though my problem fixed itself. Thanks George and Gerard. 👍 ---
**Author:** ![George\_Lewis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_lewis/32/81_2.png) [@George\_Lewis](https://community.glideapps.com/u/George_Lewis)\ **Post date:** [January 11, 2020, 5:08am UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/19 "2020-01-11T05:08:49Z")
Hello, this looks great. Could you make it copyable? Does your app change availability depending on what bookings are scheduled in? ---
**Author:** ![DanSan31](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dansan31/32/58399_2.png) [@DanSan31](https://community.glideapps.com/u/DanSan31)\ **Post date:** [June 26, 2023, 4:47pm UTC](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234/20 "2023-06-26T16:47:06Z")
Hi! I am having a problem with the add row action. It doesn’t even allow me to run the action. ![Screenshot 2023-06-26 at 11.34.46 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b1cb47db768f38614f082839e6f737dfa09550a.png) Restrictions: I checked the restrictions and it shouldn’t be a problem. Row ID: The tab has Row IDs, so I added some manually to see if this was a problem, but it still did not work. Note: I can’t share the APP because of privacy issues with some of the info there. I don’t know what else to look for, but I’ve seen this issue come up in other posts, so I thought it could be a bug. [Next page](https://community.glideapps.com/t/form-button-not-adding-row-to-sheet/2234.md?page=2)