Hello all. I’m trying to make my own set of in-app filters on a list, since Glide doesn’t seem to have the capability. (And NO in-app filters for an inline list component?)
Well, I’ve achieved quite easily in another test (seen here: https://docs.google.com/spreadsheets/d/1pO2ahAmfH-txbU5nohSme-hmZK-HdjvwigDgkmNO4LU/edit?usp=sharing ).
But now, I want to make it user-specific, so users aren’t affecting each others’ checkboxes. However, in my understanding, user-specific columns won’t show up in Google Sheets, and so my Sheets formulas won’t be able to do anything.
So my question: Using Glide, how do I make a single checkbox affect a column of cells? (See formula in column D of example sheet, which looks to the checkbox in column C.)
I’ve come across three problems, trying to figure this out:
Glide has IF statements, but no AND statements that I’ve found.
IF statements, relations, etc. are only capable of looking within the same row? You can’t “target” a cell/checkbox/etc for your logic expression’s condition, as you can in Sheets?
Checkboxes & Switches have no “Action” features associated with them, and have no way to affect more than a single cell, which feels very incompatible with the seemingly-limited logic functions of Glide, if my above problems are true.
One last thing: I’ve heard something about using another sheet with login e-mails in it in order to affect user-specific data within sheets. I’d like my app to not require a login for two reasons: simplicity of starting up the app, and so that checkboxes will reset to default on startup (it seems to work).