Creating checkbox in rich text field via scripting

[Grace_B]

Hello! I am trying to create an automation that conditionally checks to see if a user is tagged in a text field. 

Trigger: When a record is updated, watching field called "Internal Notes"
(Internal Notes is a Long text field with rich text formatting enabled)

Condition: If Internal Notes contains @Honey Bee
(Honey Bee is a real user in my base, created for testing. And also my dog's name.)

And the condition is simply not triggering! 

I have attached 3 screenshots:

• The Automation configuration
• The Automation test result output showing the contents of "Internal Notes" on my test record
• The same conditions applied to my table as a filter, working correctly and displaying the same record I'm using for testing.

Already testing a workaround solution, but still trying to crack why this isn't working as anticipated for me. Thanks!

[Zack_S · Accepted solution]

Hi @Grace_B - The following should work for you.

1. Create a new 'Formula' field (name it whatever you want)
2. The formula is just the name of the field you want to 'look in'. In your case it will be {Internal Notes}
3. Then do the condition based on that field and not Internal Notes

Condition:

Hopefully this works for you!

[Grace_B]

Thank you Zack! That's exactly what I did for my workaround!