Hello, does anyone know if it is possible within the use of Airtable with Zapier or even just Airtable to create an automation where the automation will search for a number of different pre-defined strings and count every record where it exists, then write to a table to record the count for various timeframes like day, week, month, year? If not exactly that, can be a more simplified version. As long as I can define certain strings I am searching for and have it count and record for a given time period - day, week, month, etc.
Request Details contains large text and for any record , Request Details could contain one or more of the string matches I am looking for. Would it be better to create an automation which searches Request Details field for the string matches I am looking for then create a linked record for every string match before accomplishing the original ask?
For example: I have a field called Request Details. I want to be able to search for certain string matches like Strawberry, Blueberry, Orange, etc. The automation will search my records within a given timeframe of a day, week, month or year where Request Details contains the various strings. Then it will count those records for each string and record to the given timeframe.
