- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
As far as I know, currently itโs not possible to create a parent/child style application in AirTable. A dynamic filter that could filter records in one table based on the current record in another related table would help tremendously.
Example:
Table: โProjectsโ (Parent)
Field: โProject IDโ
Values: 1,2,3,4 (4 different records)
Table: โResourcesโ (Parent)
Field: โResource IDโ
Values: 1,2,3,4,5 (5 different records)
Table: โProject Resourcesโ (Child of โProjectsโ and โResourcesโ)
โProject IDโ , โResource IDโ
1, 1
1, 2
1, 3
1, 4
2, 1
2, 5
3, 1
3, 2
3, 5
Currently the filter in โProject Resourcesโ would have to be hard-coded:
Project ID = 1 (hard-coded) to show only the resources with Project ID of 1.
Filter: Project ID = 1
โProject IDโ, โResource IDโ
1, 1
1, 2
1, 3
1, 4
However, the below filter would help establish a Parent/Child Relationship dynamically:
Filter: Project ID = {Projects}.Key (or the โcurrent row valueโ of any field in the โProjectsโ table.
Where:
- โProject IDโ is a field in table โProjects Resourcesโ linking โProjects Resourcesโ table to โProjectsโ table (a foreign key).
- {Projects} is the table โProjectsโ
- Key is the value of the โcurrent rowโ of a field called โKeyโ in the โProjectsโ table.
This would allow you to see only the โResource IDโ records that are associated with the โCurrent Projectโ. So, as you traverse the records in the โProjectsโ tab/table, you would only see associated resources in the โProject Resourcesโ tab/table when you switch to that tab.