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
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.
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.
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
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.