Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Boolean search inside attachments - 2023 update?

1405 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Vikram
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Folks,

We have one or more attachments (pdf, docx mostly) per record, and want to run a Boolean search on the content of these documents. This is similar to how you can search in Google Drive, Dropbox etc.

@kuovonne I saw some of your suggested workaround. Do you know if Airtable or any extensions / integrations have done this seamlessly?

Thanks in advance,

Vikram

3 Replies 3
Stephen_Orr1
10 - Mercury
10 - Mercury

I'm not aware of any native ability to read the contents of an attachment but this could be done with Airtable scripting. You can use a somewhat hacky method with eval() to import external libraries that can do these things and parse the result in your base.

kuovonne
18 - Pluto
18 - Pluto

Airtable scripting cannot look directly inside pdf or doc attachments. It can look at plain text files. 

I suggest looking into third party services that can perform searches into the file types you want (or that can extract text into plain text format).

Vikram
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks folks. I'm exploring a two step process.

 

Step 1: Use the relevant 3rd party tool to extract the Data in a structured format (e.g. Google Sheets).

Step 2: Use Zapier to push a new record in Aortab