depending on your plan and the user experience you want to have in search there are the 2 following solutions for searching in Airtable records:
Does it work for you?
This tool from MiniExtensions will let you search across multiple PDF attachments (but only because it extracts the text from your PDF files and puts that text into text fields for you):
There are many other tools on the market that also extract text from PDF files, but the one above is probably the easiest & quickest to use.
Hey all, thanks for the replies and support.
It is within a single attachment that may have 1000 pages - I found that loading attachment as a scroll opposed to the independent page view meant that I was able to CMD-F and search for the key words.