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. email@example.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)…
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 firstname.lastname@example.org. 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!