Forum Discussion

GunshamLakhiani's avatar
GunshamLakhiani
Qrew Cadet
5 years ago

Display ₹ (INR currency) symbol

My dB has two field containing Currency & Price. Using a simple Case formula I'm able to see all currency except ₹ symbol. QB itself modified my original formula to below

AS ENTERED

Case([Cur],
"USD","$  "&[avgrateperpc],
"Rs.","₹ "&[avgrateperpc]
)

AS SAVED
Case([Cur],
"USD","$ "&[avgrateperpc],
"Rs.","₹ "&[avgrateperpc]
)



IN SECOND FIELD I've simply added ₹ as a rich field & it's properly displayed so my browser is properly encoding the symbol

------------------------------
Gunsham Lakhiani
------------------------------
Ask about Quickbase functionality

2 Replies

Sort By
  • EverettPatterso's avatar
    EverettPatterso
    Qrew Captain
    5 years ago
    Change the field to Formula Rich Text and the HTML code "&$8377" will display the Indian rupee sign correctly. 


    ------------------------------
    Everett Patterson
    ------------------------------
    • GunshamLakhiani's avatar
      GunshamLakhiani
      Qrew Cadet
      5 years ago
      Thank you Evan, that worked absolutely fine.

      ------------------------------
      Gunsham Lakhiani
      ------------------------------