- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 26, 2019 09:01 AM
I use air table for my test prep company. We help people pass a general contractor’s exams in many different states.
I’m using air tables to keep track of all the questions. Sometimes I’ll have a question that is used in multiple books such as:
“What is the maximum allowable foundation pressure for sandy gravel?”
That can be found in 2 different books. It’s in the Residential Code 2006 AND in the Builder Code 2015. (see image below)
The problem is, if I group by book, I only see that question in the group that shows both of those books.
I need it to show in the Residential Code 2006, AND in the Builder Code 2015 when I look at the questions for those individual groups.
How do I make it appear in each of those individual groups?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 02, 2019 07:01 PM
When using grouping, each record in Airtable may only be in a single group, as you saw. There’s no way around this. In a sense, Airtable records are like people in that way. A person (Bob) may belong to several different clubs, but if you gathered all the members of all the clubs that Bob belongs to in a single location, Bob can only stand with one of his clubs, even though he belongs to several.
To see the full question list for each book, try this: make a view named “Residential Code 2006”, and add a filter for your book assignment field (the name of which I can’t see in your screenshot, so I’ll call it {Book}
) that only shows records containing “2006 IRC” in that field. Duplicate this view, rename it Builder Code 2015, and change the filter so that it only shows those records where {Book}
contains “2015 IBC”. Each view will be the full list for a single book. Not quite as convenient as both full lists in one place, but it’s the best that can be done.