<center>https://cryptocoach.cc/wp-content/uploads/2019/01/image-18.png</center> <br/><p>While AppSheet features a robust icon set, sometimes you may not be able to find the right icon for specific formatting options. A workaround to this is to expand your icon set to include all Unicode characters! </p>
<img src="https://cryptocoach.cc/wp-content/uploads/2019/01/image-18.png" alt="" class="wp-image-374"/>
<p><em>This example uses a simple property management app that features listings of property with an address, description and <g class="gr_ gr_10 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" id="10" data-gr-id="10">number</g> of bedrooms. </em></p>
<img src="https://cryptocoach.cc/wp-content/uploads/2019/01/image-16.png" alt="" class="wp-image-371"/>
<p></p>
<p>Unicode is a computing industry standard for the consistent encoding, representation, and handling of text expressed in most of the world's writing systems. These codes tell the computer what to display on the screen; when you type characters on your keyboard the computer sees a code that it interprets and logs. However there is much more available than just the characters on your keyboard, in addition to all of the different character systems for each language, there are also many symbols and glyphs available in the <g class="gr_ gr_6 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="6" data-gr-id="6">unicode</g> standard, the same emojis that show on <g class="gr_ gr_145 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" id="145" data-gr-id="145">your</g> phone. You can search for all of these here: <a href="https://unicode-table.com/">https://unicode-table.com/</a>.</p>
<p>Using a <g class="gr_ gr_4 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" id="4" data-gr-id="4">work around</g>, <g class="gr_ gr_5 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="5" data-gr-id="5">albiet</g> tedious, you can add <g class="gr_ gr_3 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" id="3" data-gr-id="3">any</g> icon available in the <g class="gr_ gr_33 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="33" data-gr-id="33">unicode</g> format into your app when using the Highlight Color Function. </p>
<img src="https://i2.wp.com/cryptocoach.cc/wp-content/uploads/2019/01/image-8.png?fit=723%2C396&ssl=1" alt="" class="wp-image-363"/>
<p><strong>Step 1</strong></p>
<p>Go to <a href="https://unicode-table.com/">https://unicode-table.com/</a> and find the icon or icons you want to use and click copy. In this case a tractor icon was selected.</p>
<img src="https://i1.wp.com/cryptocoach.cc/wp-content/uploads/2019/01/image-10.png?fit=723%2C418&ssl=1" alt="" class="wp-image-365"/>
<p><strong>Step 2</strong></p>
<p>Create a Virtual Column and call it "Symbol". Then paste the symbol into the "App Formula" field and click "ok". <em>Note depending on how your internet browser or phone adapts the </em><g class="gr_ gr_5 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="5" data-gr-id="5"><em>unicode</em></g><em> icon it will look different. </em></p>
<img src="https://cryptocoach.cc/wp-content/uploads/2019/01/image-11.png" alt="" class="wp-image-366"/>
<p><strong>Step 3</strong></p>
<p>Next, create another virtual column and call it "Symbol-Field" where "Field" is the column that you are adding the new icon <g class="gr_ gr_12 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="12" data-gr-id="12">to</g>. In this example, the symbol is being added to the Address column. For the App Formula use the following formula; it concatenates the 2 columns and adds a space in between.</p>
<blockquote class="wp-block-quote"><p> [Symbol]&" "&[Address] </p>
</blockquote>
<img src="https://cryptocoach.cc/wp-content/uploads/2019/01/image-13.png" alt="" class="wp-image-368"/>
<p><strong>Step 4</strong></p>
<p>In your display view, replace your original column with the new "Symbol-Field" column. As you can see the icon shows up in front of the original text now! </p>
<img src="https://cryptocoach.cc/wp-content/uploads/2019/01/image-14.png" alt="" class="wp-image-369"/>
<p><strong>BUT... What if you need the icon to dynamically change based on another column value? </strong></p>
<p>If you need these Unicode icons to change dynamically, you can use the switch command in the "Symbol" column's App formula! In this example, we have a different column called "Number of bedrooms" that we want to change the icons based on whether there is a value 1, 2 or 3. So we replace the Symbol's App formula with the following.</p>
<blockquote class="wp-block-quote"><p>=SWITCH([Number of Bedrooms], "1", "π", "2", "π£", "3","π ","π₯")</p>
</blockquote>
<p>Where the first entry is the column that will be referenced, and each subsequent pair of entries is the value of the referenced column followed by the icon. ie. 1 Bedroom uses the tractor icon, 2 bedrooms gets the fish icon, etc. The last entry will be the catch all icon if none of the other values are found ie. 4 bedrooms or 5 bedrooms will get the Boxing glove icon. You can have as many pairs that you would like, 3 were just used for this example. </p>
<p>Now when you load your app you see that your icon will change based on the numbers of bedrooms in the app. </p>
<img src="https://cryptocoach.cc/wp-content/uploads/2019/01/image-17.png" alt="" class="wp-image-372"/>
<p>That is all there is to it. While you wouldn't want to use this technique frequently because it is more complicated than the built-in functionality, it can come in handy for those situations that you really need the correct icon to show for the end user to make your app more intuitive. </p>
<p><strong>You have 137,439 characters to choose from!</strong></p>
[](https://steemit.com/@richellis)
Web: http://www.cryptocoach.cc
Memo.Cash: https://memo.cash/profile/16A3J6ZCj3udFABRVc2zRK9fkWMZD5czJ7
Minds: https://www.minds.com/richellis
Yours: https://www.yours.org/@richfromcryptocoach
hiveblocks