Check if Emoji exist in a Text Field

I have an email tracking app where I receive HTML of email body and subject from different brands through a webhook which I store in a text field.

First, I want to check if emojis are present in the subject. If yes then I would like to mark “Yes” in my Yes/no field.

Secondly, I want to somehow show in UI what are the common emojis used by a specific brand in their email along with their count.

Not sure how would I extract all emojis, store them somewhere so that I can count the use of an emoji, and create a table listing emojis of a brand sorted by count of occurrence.

Can somebody please help me achieve this with Bubble?

If you can find (or write) a regular expression, use that in Bubble’s :extract with regex operator.

This topic was automatically closed after 70 days. New replies are no longer allowed.