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.
Best answer by TheTimeSavingCo
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".
I thought the "Main locations" should have a table of their own (I thought) but i am struggling to structure the thing correctly.
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:
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".
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".
I thought the "Main locations" should have a table of their own (I thought) but i am struggling to structure the thing correctly.
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:
