Record deletion after a certain number of responses

[brianhale9798]

Hello! I want to automate a process in my app that will delete a record(s) after a certain number of responses to a very specific set of info. So I've got a Column for "Haulers" and one of the pieces of data in that column is "S1168", I want to make it to where after a record is submitted for "S1168" 8 times,it deletes the very first record, thus always having only 7 of the most recent responses for the specific hauler "S1168". This will be a process I utilize for every "Hauler" that is added throughout the course of using the app, so it will be used for "S1166,S1167,S1168,etc)

[TeeSee1]

AND(
 COUNT(FILTER("Haulers",[hauler]=[_THISROW].[hauler])) > 7,
 MINROW("hauler","_RowNumber",[hauler] = [_THISROW].[hauler]) = [_THISROW]
)

This expression should evaluate to TRUE for those rows that match your criteria.

Set this in "Only if this condition is true" condition of a Delete action and run it after you create/save a record or run a scheduled task against every row or both.