Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Scratches head: merge multiple record list by specific matches

Topic Labels: Formulas
232 0
Showing results for 
Search instead for 
Did you mean: 

Hello, wonderful Airtable community.
Not sure if this is a formula or not, looking for some guidance.

I’m trying to shorten a list of things that contain sub-groupings by swapping out the full sub-group with a parent word/item.

For example, in my shop we sell:

  • Three types of apples: Fuji, Honeycrisp, Gala
  • Two types of oranges: Tangerine, Mandarin
  • One type of banana: Cavendish

Screen Shot 2021-02-26 at 7.12.58 PM

Within airtable there is a table of the most loyal customers and what they often purchase. A field linked to multiple records.

The question/challenge: How would you swap in the group name only if the customer purchases the full set of items?

  • If the list of multiple records contains “Fuji, Honeycrisp, Gala” then swap those out for “Apples”?


I have been scratching my head on this one for a few hours. Would really appreciate any guidance.
Thanks in advance.

0 Replies 0