Help

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

Rollup using a group of results from linked table

Topic Labels: Formulas
286 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi guys, I am having trouble with an ROLLUP function hoping for some help.

See LOOM video attached

How on earth can I ROLLUP using a GROUP of results from a list.

Essentially this is my workflow plan.

APP: to create a Nutritional Label from data sources in the airtable data.

Workflow:

  1. Create new recipe

  2. Assign (link) ingredients to the recipe based on linked fields.

  3. Group the ingredeients linked to that recipe.

  4. Use formulas to create nutiriontal values based on the values from the linked ingredients.

Where I am getting stuck is grabbing the values from a group of ingredients, especially in a ROLLUP.

Screen Shot 2021-01-18 at 9.22.59 pm

1 Reply 1

Hi Simon,

Try loosing the condition. I tested a similar but much simpler base without the condition and used ARRAYJOIN(values) in the aggregation formula, it worked perfectly well.