 |
If you've been using formulas, you've probably noticed that in a gallery view, empty spaces or zeros can be a bit unsightly, right?
Well, I've been there too, and I didn't like it, especially when I had limited space in my view. Those empty spaces just made things look messy. But guess what? I discovered a neat trick to hide those spaces by adding a little magic to my formulas.
Here's the secret: End your formulas with "If" conditions and finish them with double quotation marks ("").
Boom! Just like that, those annoying empty spaces vanish, and your cards look sleek and clean, displaying only the data you have. The empty properties are still there, but if they don't have a value, they stay hidden.
Take a look at this image. Can you figure out the equations I've used? You can easily copy this line and adapt it to your own formulas.
if(empty(prop("Count")) or empty(prop("Total")), toNumber(""), prop("Count") / prop("Total"))
Have you tried it yet? It looks pretty awesome, right?
I've applied this trick to all my formulas, and it has made a world of difference.
That's it for this tip! If you have more questions or need help implementing it in your workspace, feel free to drop a comment or message me on your favorite social media platform. I'm available to assist you anytime.
Wishing you a fantastic day,
Fayed out
0 Comments