Is there a way to search for records based on historical data, specifically transitional statuses? Say a record was in Status A, went to B, went to C, went to D. Is there a way to see all records that ever entered status B

I am building a simple recruiting database in AirTable. Here are the tables that I have Candidates - (names, all information, name of recruiter linked to Recruiter table) Recruiters - Name, Email Position - Position, company, salary, etc. Submission ...