I have a column of linked records. I would like to make a second column that filters those linked records based on a condition.
- Table 1 Column A is a checkbox
- Table 2 Column A links to records of People that are associated with the Business
- Table 2 Column B should be a conditional subset of Table 2 Column A; linked records in Table 2 Column A should only appear in Table 2 Column B if the linked record has Table 1 Column A checked.
Any time a checked record is added to Table 2 Column A, it should automatically appear in Table 2 Column B. Similarly, any time a record is checked or unchecked in Table 1 Column A, it should be added or removed from Table 2 Column B.
From what I can tell, this is not possible in AirTable. Are there any creative ways to make it happen?