How to look up most recent field info while ignoring empty fields
Our Airtable base collects information about our program. Two of the tables track people and the programs that people are registered for. For more unchanging information--like name, email, or date of birth--we have fields on the people table. However, for information that can change from year to year--like city, job title, or phone number-- we collect it on the program registration table. In the past, we set up our base so the most recent records for a given person in the program registration table would update lookup fields in the people table, so the people table would display the most recent city, job title, phone number, etc. This system has worked well for us, but we are running into an issue where if the most recent record in the program registration table contains blank fields that correspond with people table lookups, then those people table lookup fields will also be blank. We would like to figure out a solution where the most recent pieces of information are st
