Hi,
Anybody else noticed that the Currency converter scripting block provided as a template when you add a new Scripting App no longer works. The fetch(‘https://api.exchangeratesapi.io/latest?base=USD’) endpoint has changed and also requires an acces...
Hi,
I have two tables. “Margins” and “Orders”. I need a script that would be triggered by an “New Record in the Orders table” automation that would use the value in the “Product” field to lookup a “Margin” value in the “Margins” table, then record th...
Hi,
We are looking for ways to pull data from our Linnworks.NET account (basically and order and inventory management platform) to Airtable. So far we have been using MiniExtensions to import csv files with data exported from Linnworks to Dropbox or ...
Hi,
We have a base that, amongst other things, generates requests and records when the request is completed. To provide feedback on performance, we measure the number of working days it took to complete the task using:
WORKDAY_DIFF({Request Date},{Ti...
Hi,
I am a little confused with exactly how to write an IF statement that checks that all three of the following conditions are true:
{Status} = “”{Replacement Required} = “Yes”IF(NOW() > WORKDAY({Date Created},2)
I have the first two worked out, but...
I have found the following exchange rate service that could be helpful and seems to allow one to change the base currency without an account.
https://api.ratesapi.io/api/latest?base=USD
Hi Sam,
Many thanks for your response. I will give your code a go. I have also been looking at Retrieve a Record api call as a solution.
On top top of this, as long as I have the margin value as a lookup field in the orders base (have have synced the...
Many thanks Bill for your prompt response. I do realise that by developing an api connection we there are suddenly a whole number of possibilities to expand what we are already doing with Airtable. I already have quite a long list of applications in ...
