A very useful feature to have would be the ability to “drill-down” another level when working with Look-Up fields. We use AirTable to manage our company E-mail accounts and Distribution Lists (Distribution Lists are email addresses that contain members and distribute messages to all who are assigned to it, i.e. info@company.com can go to John, Mary, and Paul). Here is the basic set-up between 3 tables: Table PEOPLE contains a list of all employees, and links to EMAIL which contains all email addresses (including distribution lists) Table EMAIL links to DIST LISTS DIST LISTS contains a lookup field to list the names of people on each distribution list. I am running into this problem: because a distribution list’s members can contain OTHER distribution lists, I cannot get a comprehensive list of all members wherever this happens (which is often). For example (using arbitrary email addresses)… say "info@company.com" has 2 members: john.doe@company.com and hr@company.com "hr@company.com" has 2 members: jane.doe@company.com and jim.doe@company.com. The lookup field will only give me “John Doe” as a name as it doesn’t drill-down another layer to lookup the names under hr@company.com. I managed to set-up a second level of “Sub-Members” with some linking (a bit too complicated to explain here), but it would be so helpful to have the ability to look-up a second layer. I know this sounds complicated - I did my best to try and explain in the most simple way I could!
... View more