SAMPLE APP: Emoji Table for Feeding Dropdowns and TEXT_ICONS()

I just realized the TEXT_ICON() expression works with emojis! :exploding_head:

So I immediately searched for an emoji dataset and found this on Kaggle: :face_with_monocle:

At this point, I knew what had to be done…

EMOJI SAMPLE APP :nerd_face:

As kind of an experiment, I have made the key-column the emoji itself.

Screen Shot 2020-08-26 at 8.41.07 PM

This means you can store a Ref to the emoji table, and the value stored to your child table will be the emoji!

Screen Shot 2020-08-26 at 8.44.45 PM


  • Dropdown image to select as label
  • Virtual Column that returns different emoji based on record status, date, user, etc
  • ??

I’m not sure what I’m going to use this for but I had fun building it!

Feel free to post other use cases below, and copy the sample data to use in your own app.


This is awesome findings, thanks for sharing.

Pushing emoji into text_icon expression directly does not return colored emoji, but using your trick i.e. refering to the physical column where emoji data sits with expression in VC, it works beautifully.

Out of curiosity, i tested what will happen if we use external free API, like

Then it returned result without error, but only the outline of original Emoji was shown.



That’s fun!


That’s fun. I’ll have to incorporate it into my personal packing app.

Very cool @GreenFlux :wink:
A known issue with emojis is that they don’t look the same over different platforms. Like in this example:

Have you tested, if your workaround would solve this problem?
I mean - does the image returned by TEXT_ICON(🏡) look the same all over the platforms?

Adding @Suvrutt_Gurjar

1 Like

Excellent question, @Fabian!

I have not tested, but I suspect that the TEXT_ICON() image, like other virtual columns, is only calculated on the device- and not the server. So it will likely have the same inconsistencies.

1 Like

Hi @GreenFlux

I get full list of Emoji and make it a table. This is kinda of boilerplate app or Emoji icon generator, leaving the users full selection for emoji to generate icon.

I placed sample app, feel free to copy.



That’s a great list of emojis. How would you get one out of the app to use in another app?

You go to my sample app and copy to your account. You will find your own spreadsheet where you see worksheet contains list of Emoji which can be used in your own app, by refereing to the same worksheet.


I just tested and it works: The Emoji does not have to be a value in a physical column. It also works with a VC.
App formula: Your_Emoji
Type: Text

Thank you @GreenFlux and @tsuji_koichi for bringing this to our attention.


Good man @Fabian


We love 絵文字 a lot. This how we spell it out. (Emoji = 絵文字)

Even my mom and dad with age 80+ using it on chat with us. haha.