NumToEmoji

Converts short number fields to Emoji. Useful for counters on tabs.

Average rating: 4.0 (1 vote) Log in to vote

Matt Navarre - Show more from this author
Navarre Training
https://navarre.training

Sample input:

NumToEmoji ( 7 )

Sample output:

7️⃣

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [
  incoming =  string ; 
  is_number = Case (GetAsNumber (incoming) = incoming ; 1 ) ; 
  sub = Substitute ( incoming ; 
    [ 0 ; "0️⃣"] ; 
    [ 1 ; "1️⃣"] ; 
    [ 2 ; "2️⃣"] ; 
    [ 3 ; "3️⃣"] ; 
    [ 4 ; "4️⃣"] ; 
    [ 5 ; "5️⃣"] ; 
    [ 6 ; "6️⃣"] ; 
    [ 7 ; "7️⃣"] ; 
    [ 8 ; "8️⃣"] ; 
    [ 9 ; "9️⃣"] ; 
    [ "." ; "⏺️"] ; 
    [ "," ; "⏺️"] 
  )  // end sub

] ;

Case ( 
  not is_number ; "🔤" ; 
  IsEmpty (incoming) ; "0️⃣" ;
  incoming = 10 ; "🔟" ; 
  incoming > 10 ; "📶" ;
  incoming < 0 ; "*️⃣" ; 
  sub

)
)

This is a simple substitute function that replaces numerals with their emoji equivalent. This is mainly useful for single digit numbers. I created it because I like to put the count of related records at the top of each tab, and wanted the number to stand out compared to just text.

If there were more than 10 related records, I don't care much about the count, so I just use a different emoji for that. Also, if the incoming number is negative or text, there are emoji for that. [emojis?]

Fun fact: Pretty much everything in FileMaker supports emoji, from labels to calculations to field names to script names... everything I've tried.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

NumToEmoji

Comments

Support this website.

Support this website.