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

[GreenFlux]

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

So I immediately searched for an emoji dataset and found this on Kaggle:
https://www.kaggle.com/eliasdabbas/emoji-data-descriptions-codepoints?select=emoji_df.csv

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

EMOJI SAMPLE APP

https://www.appsheet.com/samples/Emoji-Sample-App?appGuidString=c2b0389b-5341-484d-a8bb-e8f4f6ca034d

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

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

---

USE CASES

• 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.

[Koichi_Tsuji]

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

placehold.jp

Placehold.jp | 簡単！ダミー画像作成

簡単！ダミー画像生成、モックアップ用画像作成ツール。文字やサイズ、メモを入れた仮の画像を簡単に作成できます。

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

[Fabian_Weller]

tsuji_koichi:

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.

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.

[Koichi_Tsuji]

Good man @Fabian

Welcome.

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.

[Grant_Stead]

That’s fun!

[Lucinda_Mason]

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

[Fabian_Weller]

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

emojipedia.org

🏡 House with Garden Emoji

A suburban-looking house, with a tree, flower, or shrubs around it in the garden. …

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

[GreenFlux]

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.

[Koichi_Tsuji]

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.

Sample

[Lucinda_Mason]

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

[Koichi_Tsuji]

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.