Hello, I’m not sure if this counts as a bug or a feature request, but it may be causing my app to crash. I have an if then else statement set up as follows: [image] My hypothesis is that because the Else statement default is to Enter Value, even if nothing is inputted, Glide is autonomously creating new rows to the maximum allowed (500) and filling in these newly created cells with the rule. Glide choosing to create these rows results in a vicious loop, where a trigger of the If Then Else statement creates a new row upon which the statement is run, which creates yet a new row, until all the available rows are used up, since Glide is recognising the rows that it created as being filled. Since this is in an if-then-else statement built in Glide, it does not appear on the Google Sheet. The result is that the Google Sheet suddenly has 500 new rows - and only on the sheet where the If-then-else statement is run from. [image] I believe, therefore, that the lack of a “Do Nothing” option for the if-then-else statement may be behind this vicious recursion. If my hypothesis is correct, I’d like to check if I can set the Else to Do Nothing rather than to enter an Empty Value. I believe because Glide is entering an Empty Value, the adjacent arrayformulae are populating “blank” content which Glide is counting, triggering a response from the If-then-else statement, which creates yet another row, until the storage is filled. For reference, I’ve quadruple checked all arrayformulae across all sheets, only the sheet with this if-then-else statement is independently adding 500 rows upon a form submission, all others add only the single new row. Further testing reveals that it only adds 500 rows if the number of rows available in Google Sheets has been maxed out with form submissions. So if a sheet has 50 rows (reduced because Glide counts arrayformula rows as filled), and the 50th row is filled, instead of creating a 51st row in the Google Sheet, it creates 500 rows once a form is filled. The 500 new rows are only added on the sheet with the If Then Else statement, and on other sheets, only 1 new row is made. But if the sheet with 50 rows has 40 rows filled, then filling the form only fills the 41st row, and no new rows are formed, on any sheet. In both cases, prior to form submission, Glide counts all 50 rows whether they have data or not. As a result, if I reduce the number of rows in Google Sheet to the minimum, a single form submission will lead to all 500 rows being used and the storage being filled with empty data. The app is as follows for reference: https://porknado.glideapp.io/

Are you sure you don’t have any other array formulas in your sheet?

Hi Naos, Thanks for your response. I do have numerous array formulas on the relevant sheet, as well as on all other sheets. Only this sheet has an If Then Else statement, and it is the only one resulting in this problem where 500 new rows are created, whereas other sheets with array formulae only add a single row upon the completion of a form, hence my hypothesis that it may be at issue. None of the array formulae on this sheet are fundamentally different from those on other sheets.

Hi Ran, Here’s a duplicate of the app and sheet: https://papaglidecomm.glideapp.io/ The affected sheet is called Order Summary. Still not sure though - is there a “Do Nothing” option for Else?

Thanks I could not find the problem May be I didnt understand you well Please tell me again what to do In that cases I usualy use: =ARRAYFORMULA(IF(ISBLANK (A2:A), “”, “Something…”))

[500 lines GIF] Thanks Ran - I’ve made the gif above to demonstrate the problem in action.

Hi Kefa In my side everything goes well and I dont see any sper rows adjusments

Hi, It happens specifically when there are no more extra rows in the “Order Summary” sheet, and glide is forced to make a new row to fill in the new data, but instead makes 500 new ones. If you check the relevant sheet to see that there are no available rows to be filled, and then try it again, you should be able to replicate the results. The reason I can’t just add extra rows to circumvent this is because of the arrayformulas, which will result in the app counting these unfilled rows, and will further slow down the app (as arrayformulas seem to have a very significant but seemingly unavoidable impact on the speed of the app).

[image] Arrayformula storage issue Report a Bug OK, I think I understand this a little better now. I don’t think I realized that your sheet was built from a unique formula. I think the rows are being created by google when the UNIQUE formula hits the end of the sheet and automatically adds the 500 rows as a buffer. I think what we have here is a non-issue. Since your are only building the sheet from a unique formula instead of a from a form button (this is what I thought was happening), you really don’t have to worry about the extra rows …

Hi No,it is not the case in my side I realized that the sheet is very “heavy” and it takes some time to calculate I have no ideas

If x Then y Else Do Nothing

Report a Bug

Jeff_Hager May 18, 2020, 7:03pm 10

Topic		Replies	Views
Arrayformula storage issue Report a Bug	22	2064	June 4, 2020
500 rows Ask for Help	4	558	April 19, 2021
FORM data writing to Glide but NOT to Google Sheet Report a Bug	20	1499	July 7, 2020
IFS conditions Ask for Help	18	1476	October 12, 2020
User input data goes in row 455 rather than next empty row Feature Requests	5	967	September 12, 2020

If x Then y Else Do Nothing

Related topics