Stacking Fields

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!

Best Regards,

Nico

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