Airtable definitely needs a way to change the record picker when using linked records from a synced table(or any table for that matter) or even allow a better search mechanism when picking those records. Right now you can search your linked records but not using any criteria of the lookup fields associated with them. Example would be that I have an Employee’s Full Names associated with an Employee ID #. When using the record picker, I can only search by the employee’s ID Number, No criteria matching that employee (First Name , Last Name). I have 250 IDs on file and have to add 20-50 records at a time with data. I cant memorize every employee ID. See Below trying to search with criteria shown in the record picker window
I also just learned that if you use a synced table and change the view on that synced table it also changes all the data on ALL other tables that was attached to it. Example: I have employees directory that keeps track of Employee information specifically if they are active or inactive. I have that table synced to another base that keeps track of all employee time on jobs. I have around 8000 records and over 3 years of data. When I changed to synced table view to only show active employees, all of my inactive employees employee data from another table was lost. The record existed but the employee data had vanished. Around 3000 records were gone by filtering a shared tables data.