Help

Re: Exchange currency

731 0
cancel
Showing results for 
Search instead for 
Did you mean: 
wa_vi
4 - Data Explorer
4 - Data Explorer

Is any tips/hint for exchange from one currency to another ?

example is a sale of the same product in more currency around the world like $ (dollar) € (eur) £ (sterlin).
I like show the product value in only € (euro) and imput in table the product value sale around world with the sale currency ?
( like sho : on sale cookbook 25€ | but my input is : store in london 20£ | store in newyork is 22$ etc…etc…)

thankyou

4 Replies 4
BIKE_gang
4 - Data Explorer
4 - Data Explorer
  1. Create an exchange table under google sheet

  2. Use googlefinance function to get exchange rate update (eg. =GoogleFinance(“CURRENCY:USDTWD” , “average”) … )

  3. Zapier to zap this record into airtable record.

Do you know what that zap in zapier would be?

I’ve been looking though and haven’t been able to figure out…

thanks!

pendolino
5 - Automation Enthusiast
5 - Automation Enthusiast

just tried to do it via Zapier. It seemed straightforward but then Zapier was buggy pulling the info from Google Sheets. gave up on this for now what a PITA

GavinA
8 - Airtable Astronomer
8 - Airtable Astronomer