Hi,
I have an Airtable project with two tables, Clients and Enquiries.
I have a column in Enquiries called “Company for Invoice”, which uses AI to read through email chains and store the name of the company making the enquiry. When I search for records on the Enquiries table, the Company for Invoice is shown as a Collection, with state, value and isStale.
I want to take the value (Company Name), and pass it to another Airtable module to look up that company in the Clients table.
However, because it is outputted as a Collection, Make seems to be really struggling to parse the collection and only use the value. I have tried many combinations of get(), JSON scripts and other things, but I can’t get it to just output the value (the company name). Any suggestions, please?
Hi @Thumpercastle and welcome to the Make Community!
Do yuo have an example of output? If you do not want to share the exact data from Airtable, you can take the output of the module and edit the information in a text editor before pasting it here.
When you paste it, make sure to put it between the code quotes to make sure the formatting (or lack thereof) is correct.
L
Hi,
The JSON output is as follows. I’m trying to access “Company to Invoice AI.value” i.e. “Reds Property”. I want to then give that to another Airtable node to link to the Client record for Reds Property.
[
{
"Job Number": 32,
"Company to Invoice AI": {
"state": "generated",
"value": "Reds Property",
"isStale": false
},
"Agent Name": {
"state": "generated",
"value": "",
"isStale": false
},
"Agent Name copy": {
"state": "generated",
"value": "",
"isStale": false
},
"id": "rec3mntQBYimdgJ0X",
"createdTime": "2025-09-11T15:33:22.000Z",
"__IMTLENGTH__": 1,
"__IMTINDEX__": 1
}
]
OK, is this what you want:
In the first Module, I stored the string above. It could come from anywhere:
Then I use the Parse JSON module to get a structured result
In this case, I’m not using a specific structure, but I could create one from the output you have. Then Make can use that structure to validate the incoming data.
Finally, I take the value I need and put it in a variable. I could have done that with the correct AirTable module also:
L
3 Likes
