Converting numbers to Currency format?

  • Chester this is one of the best plugins i have installed yet. I have been working with airtable for almost 2 years now and it really is an amazing platform. This plugin making it possible to pull that data directly into the site is amazing so thank you for that.

    I am creating a catalog page on my site for products that i have built in Airtable. One problem i have is that i am trying to pull 2 different prices (retail and sale) from airtable but even though they are formatted as currency in airtable, they do not retain that formatting once getting to the site. Is there a way that i can display these numbers as currency on the item pages?

    Thanks in advance!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Shaun –

    Keep in mind the Airtable formatting controls affect only the *display* of information in the Airtable view; internally currency is stored as simply as an integer or decimal. You’ll either have to format the numbers yourself using javascript (there are tons of libraries that support this) or convert the currency fields to formatted strings in the base itself and retrieve the strings through Airpress. If you want to do the latter, you might want to steal some code from my pretty-print routines as found in this Community post:

    https://community.airtable.com/t/number-and-currency-pretty-print-routines/10807

    Thread Starter shaunhornsby

    (@shaunhornsby)

    Mazoola

    Thanks for the idea. I honestly have not figured out yet how you did that with the formulas but it did give me an idea. In my product description column I included some html <p> </p> and a few other things just to make the descriptions look presentable once they got to the website. So i created another column that is a text column, i typed the price in the comma and decimal place manually with no dollar sign and on the site i use the following..

    $[apr field=”webMsrpPrice”]

    The dollar sign in the front adds the dollar sign to the number giving it the look it needs. So this does work for now but i will continue to try and figure out what you did to yours as that would be easier.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Converting numbers to Currency format?’ is closed to new replies.