So. I have an app live with a customer. They have been reporting issues with missing data. This is not something that I see very often with Glide as it’s pretty robust.
On investigation I see, in the data editor, that some of my relationships based on email address are not working correctly. I scratch my head and, after a LONG period of time, I see that some of the emails (which my users enter) have a space on the front or the end. They therefore do not match for the purpose of a Glide relationship. Hence Arghh.
Don’t worry, I hear you say, just add an array formula in the sheet that trims the email to remove any leading and trailing spaces. Well I used to do that in order to lowercase the email, but Glide made this a case-insensitive match, so I could remove that array formula. Hooray. Except now I need to put it back to remove the spaces. Arghh.
I have really focused to build a complex app with NO array formulas whatsoever, part in preparation for Glide native sheets, part to minimise lag (which they introduce) and part to keep as much logic as possible in Glide.
So. How can I strip the spaces? I need a trim function in the Data Editor. Or the email entry field to remove leading and trailing spaces, or the Glide relationship to ignore leading and trailing spaces when matching emails. Otherwise, I’m back in “array formula” land … Arghh.