Taking a brief look at your shared Table, maybe it is worth examining your first field…
If you can get away with having the ‘Code’ be your Primary Key/Field then you have some quick
Airtable tricks available to you to simulate a
With ‘Code’ ( e.g. ‘Co_20_15_08’) as your first field, if you create a new Formula field:
This will give you the beginning 5 characters of ‘Code’ (e.g. Co_20’). Then, change the Field Type from
Link to another record. Select your same Table. As soon as you do this, the field will be linked to the ‘grouping’ record in your question, from there you can ‘lookup’ things like ‘Code Title’, etc
So, was it what you asked for? :face_with_raised_eyebrow: Nah, but it might end up being more useful than your current setup.