Dec 23, 2022 06:40 AM
I'm pretty sure I've seen this covered before, so forgive the reposting.
I want to create a field that generates a flag icon/emoji if a checkbox field is checked.
I'll use this to add the icon to my field title (using Concatenate) so it draws attention. I've done the same thing using the SWITCH formula, but I can't figure out how to do it with a checkbox field.
TIA!
Solved! Go to Solution.
Dec 23, 2022 07:21 PM
(I'm on the freeplan so can't run a script based on a field change).
@John1 Note that .updateNameAsync() only works in scripting extension, not automations scripts, so this particular script won't work in an automation anyway.
@Joel_Andrews1
Since you refer to being able to do this with a SWITCH() formula, I'm guessing that you want a formula that will give you an emoji that you can use in the value of the primary field of the record, versus changing the actual field name.
Try something like this ...
IF( {checkbox field name}, "🤖")
Be sure to put the emoji in straight quotes.
Dec 23, 2022 01:26 PM
Hey Joel
Here's a start for you - I made this script run on a button field next to the checkbox field (I'm on the freeplan so can't run a script based on a field change).
Change the YOURFIELDID to the ID of the checkbox field an YOURFIELDNAME to the name of the checkbox.
You'll also want to change the "TRUE" and "FALSE" to the icon you want to use.
It's just a start as I believe when you remove the icon from the field name you'll have to check ALL records to see if any other checkbox is set to True and if it is then you want the icon to stay put.
----------------------
Dec 23, 2022 07:21 PM
(I'm on the freeplan so can't run a script based on a field change).
@John1 Note that .updateNameAsync() only works in scripting extension, not automations scripts, so this particular script won't work in an automation anyway.
@Joel_Andrews1
Since you refer to being able to do this with a SWITCH() formula, I'm guessing that you want a formula that will give you an emoji that you can use in the value of the primary field of the record, versus changing the actual field name.
Try something like this ...
IF( {checkbox field name}, "🤖")
Be sure to put the emoji in straight quotes.
Dec 23, 2022 08:06 PM
Looks like the forum software doesn't like emoji. It turned my emoji into text.
Dec 29, 2022 10:37 AM
That's exactly what I was looking for. Thanks!