TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Add Currency Features
I am working on a DB that is using multiple currencies. Creating the conversion formulas are relatively simple but it is tedious. Keeping the exchange rates current can also be an issue.

I am thinking that this is a common enough need that it can be done universally as a teamdesk feature.

Add a Currency Convert Formula Column. Link it to a public currency table.
Add the country code to the basic currency column used by the conversion column to convert from. Default it to the database default currency.

Then we add the initial currency column, and then add a formula currency convert column for each currency needed.


I recommend that currency conversions be displayed, with the optional rate or date of conversion table update. ie. 15 (rate .56)
ID
1518
Category
TeamDesk
Author

cooper collier
Date Created
3/24/2022 9:38:57 AM
Date Updated
3/24/2022 3:54:33 PM
Status
New Idea
Score
40
Promoted By
Patricio BustosPhilipp Matuschka (MMB)Dale Oliver
cooper collier
Comments
basenine 3/24/2022 3:52:30 PM
Hello Cooper
You can configure a currency exchange API in TD

Here’s an example of an API service
https://currencyapi.com/
They give you up to 300 credits free per month
There are likely other services which are free altogether.
I seem to recall an example of this type of API setup in the Team Desk library (?)
basenine 3/24/2022 3:54:33 PM
Here’s one that is entirely free and is limited to 42 currencies

It may be enough for your needs?

https://www.currency-api.com/
Feedback
 
Back to Search Results