# How to add fields to app from an airtable rollup or formula column?

**URL:** <https://community.glideapps.com/t/how-to-add-fields-to-app-from-an-airtable-rollup-or-formula-column/66560>\
**Category:** Ask for Help\
**Created:** [September 27, 2023, 10:09am UTC](https://community.glideapps.com/t/how-to-add-fields-to-app-from-an-airtable-rollup-or-formula-column/66560 "2023-09-27T10:09:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![onceuponarob](https://avatars.discourse-cdn.com/v4/letter/o/b487fb/32.png) [@onceuponarob](https://community.glideapps.com/u/onceuponarob)\
**Post date:** [September 27, 2023, 10:09am UTC](https://community.glideapps.com/t/how-to-add-fields-to-app-from-an-airtable-rollup-or-formula-column/66560/1 "2023-09-27T10:09:18Z")

</div>

Hello,

Ive discovered that my rollup and formula fields in airtable - although copying across to Glide fine and having data populated - are not available as fields that I can select when designing the app layout.

I can select other fields from the table but not the rollup ones.

It isn’s available in the ‘items data’ settings for a collection nor in the Fields component data source.

How do I do this?

The objective is:  
I have a table of Recipes. One of the columns is an Ingredients text field.  
For each recipe that meets certain conditions, I want a single field that shows the aggregated Ingredients from all those recipes.

I want the glide app to display the results of that aggregation.

My technique was:  
All recipes are automatically linked to a row in a second global table.  
That second global table has a rollup field that aggregates the Ingredients field from the linked Recipes (which is all of them) where certain conditions are met.

I thought I could then simply add a field to a page layout in glide that displays that information but i can’t

Thanks  
Rob

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 27, 2023, 11:24am UTC](https://community.glideapps.com/t/how-to-add-fields-to-app-from-an-airtable-rollup-or-formula-column/66560/2 "2023-09-27T11:24:21Z")

</div>

I’m not an Airtable user, but it sounds like what you are looking for in Glide is a Joined List column.

Can you show me how your Airtable column appears in the Glide Data Editor?

---

<div class="post-metadata">

**Author:** ![onceuponarob](https://avatars.discourse-cdn.com/v4/letter/o/b487fb/32.png) [@onceuponarob](https://community.glideapps.com/u/onceuponarob)\
**Post date:** [September 27, 2023, 12:15pm UTC](https://community.glideapps.com/t/how-to-add-fields-to-app-from-an-airtable-rollup-or-formula-column/66560/3 "2023-09-27T12:15:34Z")

</div>

Thank you,

This solved it. I had to create a new field in glide of joined list type that references the rollup field from airtable.

Best  
Rob

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 4, 2023, 12:15pm UTC](https://community.glideapps.com/t/how-to-add-fields-to-app-from-an-airtable-rollup-or-formula-column/66560/4 "2023-10-04T12:15:37Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.