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 Papish		Patricio Bustos		Philipp 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/
	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 Solá 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