Get External Exchange Rates Based on Input Date and Currency Fields

[Francis]

I am new to Caspio and wonder if it is possible to get the exchange rates from an external website based on the date and currency entered by the user and return the exchange rate back the exchange rate field in a table?

I don't know anything regarding api and therefore need more guideline on this.

Thanks

 

 

 

[MayMusic]

You can have an scheduled import to update your table frequently by getting the excel sheet and importing it to Caspio to replace with the current file. You can choose which column to import and also update the data based on unique field value. Look at this article: http://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-import-task/