Hello Airtable Community!
I’m using Airtable to keep track of a series of components on a customer site via the Serial Number, location and revision level and am currently trying to merge data from an inspection table and a installation tracker table to spit out the most recent entry entry so that I have an accurate real time master sheet. Unfortunately neither of these are perfectly accurate or complete so they often fill each others data gaps.
The current issue I’m having is I can’t seem to find a way to stack serial numbers from 2 fields into a single field. I figured this would be a good way to compile a master list and then use a formula to clear duplicates and keep the most recent entries.
If there is a better way about going this I’m all ears as well!