I’ve set up an export of records from Looker to Airtable. The view that I’m exporting may contain duplicates of previously exported rows, and I’d like to set up a view that contains only the latest exported entry per each key, where key is a single column. I’ve set up a
RECORD_ID() columns and tried keeping the latest entry using links, but as far as I can see links need to be manually added which is completely unfeasible and kind of ruins the purpose of automation of the whole process.
How can this be done? I’m open to having to write code, use existing blocks, or similar.