Links
💾

How To Fetch Data from a specific row in Airtable in a Computed Field

For fetching data from Airtable we will have to use an Async Computed Field

Step 1: Create the Async Computed Field

Mark the async checkbox after creating the New Computed Field
​

Step 2: Settings of the Flow

In Entire Flow --> Options --> Advance, add the Keys that we will need to identify the Airtable row from where we want to extract the data. In this case, it would be customer_id

Step 3: Generate the function for the async Computed Field

function result({
customer_id,
}) {
return fetch(`https://api.airtable.com/v0/appZTPe3D7r1qi7KA/Report%20Results/${customer_id}`, {
method: 'GET',
headers: {
'Authorization': 'Bearer API_KEY',
},
}).then(response => response.json())
.then(data => {
const d = data.fields
​
return d
})
}
​
​

Step 4: Getting the Data in the Response

The Data is going to come as a JSON object, so we only need to access the fields we need by dot notation for example d.customer_id or d.main_score
"customer_id": "recGQGPy26Wh7nDBc",
"site_design_text": "This website is very good. The design is clean and clear with excellent use of spacing, colour and animation.

\nThis website stands a very strong chan...",
"main_comment": "This is a very good website",
"main_score": 100,
"company_url": "trysavvy.com",
"company_name": "Savvy",
"site_design_score": 25,
"Flow URL": "https://flows.trysavvy.com/flow/Py2LmcoIEINqAAo1Wint?customer_id=recGQGPy26Wh7nDBc"
}
​