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
6/7/2023 3:56:31 AM
Status
New Idea
Score
50
Promoted By
Ivan PapishPatricio BustosPhilipp Matuschka (MMB)
Dale Olivercooper 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/
JonnyGee 3/8/2023 2:30:27 PM
So how would one go about setting this up? I have an account setup with a free Currency API (Limited Calls).
On the surface of it, it seems that you are provided with a 'Generated Request URL' strong and a Key, but I see no clear and obvious place in TeamDesk whereby this could be connected.... The API section seems to require much more info than the Currency API Providers, provide....
If I can get some help from TeamDesk to connect to this and get live exchange rate calls working in a table in Team Desk, I would gladly write a little article/User guide so other users can connect the same functionality. Typing in exchange rates multiple times a day does not feel right with the power of TeamDesk!
Cheers
Jonathan
Jorge Sola Ullod 6/7/2023 3:56:31 AM
Hi, Jonny.

Sorry I didn'd see this before. Let me know if you already worked this out. Otherwise, I'll be happy to show you how to do it.
Feedback
 
Back to Search Results