I pull a .CSV report each day from a third party software that shows me all unpaid balances for reservations checking in in the next 60 days. I move these into airtable in order to sort with different views, add notes, etc.
Most records will end up being the same, but I still pull it every day in case new reservations were created or old reservations have new declined payments that were scheduled. I don’t want to have to go through hundreds of duplicate records each day to keep the original ones with my notes, etc.
Is there a way to just add new records to the table and ignore the import of any duplicate reservation numbers?