When I start typing in a lookup column Coda suggests rows in the target table that match what I am typing, but it only matches based on the primary (first?) column. Is there any way, in Coda or otherwise, to match data in any column of the target table?
For example, suppose I have a Department table with a lookup into an Employee Table in which the employee name is the primary key. When I start typing “John…” it will suggest “John Smith” and “Mike Johnson” but it won’t suggest Mary White who lives in Johnstown, because address is a separate column.
Perhaps if I use a formula to concatenate all my columns into one, is there a way to get Coda to suggest rows where the string is found in that column? Any other way to do this? Even in other tools?