Hi, I’m trying to figure out which column type to choose for a column that has numbers in it. I have 4 different groups: well below benchmark, below benchmark, at benchmark, and above benchmark. Take a look at this screenshot…
I’m trying to configure the column type to where if a number in a column is in between the range, then it will give me a certain emoji. I tried using if_then column type, but then realized that it doesn’t really give me the ability to stop at a certain number. For example, I can choose greater than or equal to a certain number, but I can’t necessarily tell it which number to stop at so that it doesn’t go beyond the range I want it to focus on. Does that make sense?
Could use some help with this one. Thanks so much for your time.
Hey Spencer! Congrats on being a Glide Ambassador, BTW.
@Uzo’s way should work—I’ve use that method in the past, but now I do something different.
Recently, I did something sim similar when determining a user’s rank (between a minimum and maximum amount of XP). It’s not super simple, but it’s super flexible and prevents you from needing to use if-then-else columns.
Right, that’s what I was saying—it’s easy if you know those numbers will never change. However, If for some reason you need to edit the thresholds, you’ll need to go back in and edit ALL those ITE columns.
That’s what I love about Glide—more than one way to solve the problem
One for each column… and you can create a nice CSS table… your method is great for a big number of benchmarks… but it will not give you the option to create a 2D table…
Ok, I’m getting an error message now in a number of columns, which has rendered Bob’s solution useless now. It was working perfectly this weekend, so I’m thinking it has something to do with Glide, and not the way they’ve been set up. Here’s the screenshot below. When I click on Reload, nothing happens. When I click on Learn More, the page won’t open, but it points to this → https://www.glideapps.com/docs/experimental-code-column.
Well, it’s just a Sort Array column. Is that a plugin? I didn’t think it was. Let me try recreating it. It’s weird though. None of those column types that Bob showed in his video, and the ones I was able to use, are coming up for me. They’re completely gone. Only one still there is Make Array.
All the plugin columns will appear as “Experimental Code” type.
I don’t think it’s a Glide bug, because if the plugins had suddenly broken then we’d all be affected. More than likely it could be related to your network, or the state of your browser.
If re-creating the column doesn’t help, try reloading the builder. And if that doesn’t work, try removing all Glide related cookies and then login again.
Can you send me a screenshot of what your menu displays when you hover over Other. When I click on Experimental Code, the page is still not loading for me. Is it loading for you? My internet is otherwise working great. I’m getting a 404.
Yes, when hovering over Other, you have a bunch of options under the Experimental heading. I’m not seeing all of those options any more. The only option in there for me is Code, and then Experimental Code, and nothing else. Weird.