
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2023 01:42 PM - edited ‎Mar 10, 2023 01:43 PM
Subrecords is the one aspect I don't like in Air Table and I am struggling with a case right now. Maybe somebody has a smart and simple solution. I feel my design is flawed but I did not find any other practical way to work this.
Let's say I have
TABLE A
Field 1: Location name (text)
Field 2: Sub-location name (text)
Field 3: [Field 1] & [Field 2] (calculation field)
Field 4:: A chekmark field to filter out sub-records, so I can a list of records without seing all the time I repeat Field 1.
TABLE B
Field 1: Area code (text)
Field 2: [TABLE A Field 3] (linked)
What I would like is a list of unique records of Table A Field 1, with all the linked records in Table B Field 1.
And I can't seem to find a simple solution.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 12, 2023 11:08 PM
Ahh, yes, with the way you've got it set up you'd need a table just for "Main" locations, and you'd create a lookup field for the scenes. You can convert your "Decor" field into a linked field and select "Create a new table" and that should do it:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 10, 2023 07:26 PM
Could you provide screenshots of your tables and the relevant fields, as well as an example of how you'd want the data to be formatted in an ideal scenario?
Once I know how your data is set up and how you want it to look eventually I may be able to suggest something

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 12, 2023 12:35 PM
Sure, thanks for taking some time for my small problem.
If you look at the screenshot, you'll see three text fields. A "Main" location (A), a "sub-location" (B), a field calculated from both fields (A+B) and linked records from another table. A+B is the main field (and is unique for each record).
What I would like is to have, somewhere, a list of the main locations with the linked records of all their "sub-locations".
In this example, that would mean a way to show :
"Centre-ville" , and "9.15, 9.16, 9.17, 9.31, 9.44, 10.19, 11.13, 12.15"
"Route de campagne", and "11.11, 13.46".
I thought the "Main locations" should have a table of their own (I thought) but i am struggling to structure the thing correctly.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 12, 2023 11:08 PM
Ahh, yes, with the way you've got it set up you'd need a table just for "Main" locations, and you'd create a lookup field for the scenes. You can convert your "Decor" field into a linked field and select "Create a new table" and that should do it:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 03:34 PM
Beautiful, thank you!
