Skip to main content

Hello guys, I have an Airtable managing my bills in multiple currencies.



I’ve been trying to customize the eAirtable Currency Converter]


(Airtable Scripting) to convert each record with the conversation rate of its date. I want it to be automated given that I have 5,000 records of bills.



I suspect my syntax is wrong, but maybe the logic of my code is completely wrong too.



My code is the following :



// load table and records





let table = base.getTable("Table 1");





let result = await table.selectRecordsAsync();





// launch a 'for' loop to fetch conversation rate then update each record depending on value of "Date" field





for (let record of result.records) {





    await





    // fetching exchange rate





    let apiResponse = await fetch(`https://api.exchangeratesapi.io/${record.getCellValue("Date")}?base=EUR`);





    let data = await apiResponse.json();





    let conversionRate = data.rates.GBP;





    // updating the record





    table.updateRecordAsync(record, {





        'Exchange rate': conversionRate,





    });





}


The code doesn’t work. Thank you for your help / insights / corrections.

Hi @tyloria - you’re pretty close. You’ve got a rogue await in the for loop that is causing the issue. This works:



let table = base.getTable('Table 1');





let query = await table.selectRecordsAsync();





for (let record of query.records) {


    let date = record.getCellValue('Date');


    console.log(date);


    let apiResponse = await fetch(`https://api.exchangeratesapi.io/${date}?base=EUR`);


    let data = await apiResponse.json();


    let conversionRate = data.rates.GBP;


    console.log(conversionRate);    


    table.updateRecordAsync(record, {


        'Exchange rate': conversionRate,


    });    


}

Hi @tyloria - you’re pretty close. You’ve got a rogue await in the for loop that is causing the issue. This works:



let table = base.getTable('Table 1');





let query = await table.selectRecordsAsync();





for (let record of query.records) {


    let date = record.getCellValue('Date');


    console.log(date);


    let apiResponse = await fetch(`https://api.exchangeratesapi.io/${date}?base=EUR`);


    let data = await apiResponse.json();


    let conversionRate = data.rates.GBP;


    console.log(conversionRate);    


    table.updateRecordAsync(record, {


        'Exchange rate': conversionRate,


    });    


}

Absolutely amazing … The scripting block is so cool for people who don’t really know how to code like me !



thank you @JonathanBowen !

Reply


Terms & Conditions