Jan 18, 2021
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.
Create new recipe
Assign (link) ingredients to the recipe based on linked fields.
Group the ingredeients linked to that recipe.
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.
Jan 19, 2021
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.