In your case, your rollup arrays are collections of controlled document number strings.ĭirectly within Airtable, it’s not currently possible to compare arrays to find their differences, at least not on a record-by-record basis as you need (I may post my other solution to the Show and Tell category in case it helps elsewhere, but sadly it won’t help here). They could be collections of strings, numbers, dates, etc.
Your assumption that your controlled document numbers are strings is correct.
That makes complete sense (and trust me, novels are far better than short stories when it comes to explaining what you’re trying to achieve with a database).