Can anyone help me figure out what in the world is going on here? I’ve had a User sheet populating new users for months based on the App: Logins sheet. Since this app started from the Finstagram template, it’s the exact code from that. =UNIQUE is in the first row of data in column B and it’s drawing the array of unique values from App:Logins… so every time I get a new user, I get a new row of data in this User sheet. Except for the past day and a half, I’ve been getting two of the same values when a new email is added to App: Logins. One comes in next in line as you would expect from UNIQUE, the next one comes in on the last line of the sheet. Sometimes the second one appears first, but usually the first one appears then the next.
Is this a Sheets bug? Is there something perhaps messing with this column? Any ideas?
What’s interesting is that the email address that comes in at the bottom of the sheet arrived with a new added row. That’s why there’s a space between the two. And the reason that’s weird is that UNIQUE typically doesn’t just add in one new line at the bottom of your sheet if it doesn’t have room, it actually adds 500 new blank rows and adds the new email address to the first of those new rows. The behavior of just one row being added with a new piece of data is not anything I can duplicate. All array formulas expand past the last row in a sheet by adding tons of new blank rows. The only example I have where a new row of data is added to my spreadsheet and it only adds one row, even if there are no blank rows to write to, is form data from Glide or new Logins added to the App: Logins page… also data being written from Glide.
Is it possible that one of the screens in my app attached to the usersheet is sending the email of the newly signed-in user to the usersheet as form data, thus creating a new row of data at the bottom of that sheet? @Robert_Petitto? @Jeff_Hager? You guys ever see behavior like this?
Could this be Glide @Mark? This just started happening. I really hope this isn’t being discussed elsewhere.