Icon from status field in calculation field

Inspired by @Tim and his in-depth post on calculation fields: Tape calculation field Cheat Sheet, I thought I would share one that I have found useful recently.

Using emoji in a status or single select field can help make things clear at a glance:
melotte.consulting 2023-11-30 at 17.41.16

Building a ‘Title’ using a calculation field can be very useful to show relevant information quickly, however, you don’t really need all of the status or a single select field to be in the ‘title’ field, the emoji does the job:
melotte.consulting 2023-11-30 at 17.44.42

So how do we build a ‘title’ and only use the emoji/icon part, we can use split on the space between the emoji and the rest of the information as shown here:

`${@Organisation Type.split(" ")[0]} ${@Name} -/- ${@Organisation #}` 

this can work for other things such as quickly being able to see if a Backup has errors or not:
melotte.consulting 2023-11-30 at 17.52.41


Amazing @Jason - thanks for sharing :sunglasses::raised_hands:

1 Like