Skip to main content

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






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.

Be the first to reply!

Reply