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:
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.
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/