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.
Automatic end of day rollup count of various string searches
+2
+17- Employee
Use a linked record and rollups
In your rollup filter on the item you are searching for and sum(values).
Your automation looks at your linked table (record aggregator in the pictures). Schedule it over your frequency (daily, monthly, etc) to record the values in record aggregator
+2Use a linked record and rollups
In your rollup filter on the item you are searching for and sum(values).
Your automation looks at your linked table (record aggregator in the pictures). Schedule it over your frequency (daily, monthly, etc) to record the values in record aggregator
Hi, thank you for the response!
Unfortunately, the Request Details field I am looking to search holds a whole bunch of different text. To do your method, I would need a way to extract from Request Details my string matches before I have those cleanly bucketed records like you have there.
+2When I mentioned pre-defined strings, I should clarify there are certain string matches I know to look for in the field Request Details, but Request Details stores a whole message and not simple single select values
+2Request Details for any record 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?
+17- Employee
The native find will only return 100 records. I don't think a daily search is the right approach.
In your count you can use the contains option which essentially does the search for you
+2The native find will only return 100 records. I don't think a daily search is the right approach.
In your count you can use the contains option which essentially does the search for you
conducting the search is one part, but to record the count from that search in an automated fashion - how would that be done?
+17- Employee
you records your results in a new "log" table with the keyfield being the date/timestamp.
+2you records your results in a new "log" table with the keyfield being the date/timestamp.
so there is no way to do this in an automated fashion? it requires manual input?
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.