How can I delete a previous record entry in a field?

Hi all, new-ish to Airtable and I’m having to build an inventory table to check for equipment conditions. The purpose of this table would be to show the type of item, brand, make, some descriptions, cost of item, condition, and date condition checkup was submitted.

The condition are pulled from another tab which is where my workers would be submitting their checkups, usually done once per week.

My issue here is that as of now, if a worker submits a second check up (lets say by week 2) the condition field will populate as “good” “good”. I would like to have a single, most up-to-date condition in that field and have it delete the previous entry. For example, if item 1 has been “good” for 4 weeks, but by week 5 something were to happen, the worker would check “needs repair”. I would like the “good” to auto delete and be replaced with “needs repair” until otherwise noted as good on the next check up.

I’m not sure if this is a task for formulas or for automation. I was toying around with both but couldn’t figure out how to get this to happen. Any chance one of you amazing people can help?

So you have linked records and you’re trying to Lookup one value from only the most recent linked record. If so, this is would require a few Lookups and Formulas but needs no automation.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.