# Can I use the following computed columns in Big Tables?

**URL:** <https://community.glideapps.com/t/can-i-use-the-following-computed-columns-in-big-tables/62475>\
**Category:** Ask for Help\
**Tags:** big-tables\
**Created:** [June 5, 2023, 9:54pm UTC](https://community.glideapps.com/t/can-i-use-the-following-computed-columns-in-big-tables/62475 "2023-06-05T21:54:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [June 5, 2023, 9:54pm UTC](https://community.glideapps.com/t/can-i-use-the-following-computed-columns-in-big-tables/62475/1 "2023-06-05T21:54:57Z")

</div>

Can I use the following computed columns in Big Tables?

1. Multi Relationships
2. Lookups
3. Find Element Index
4. Query
5. User Specific Column
6. Template
7. If-else

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 6, 2023, 12:10am UTC](https://community.glideapps.com/t/can-i-use-the-following-computed-columns-in-big-tables/62475/2 "2023-06-06T00:10:46Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/519206f48551bdd3cb82fcb5c8b70e6a15ee116f.png)

At the moment, here are the things that won’t work with Big Tables.

> **[Glide • Big Tables](https://www.glideapps.com/docs/reference/data-sources/big-tables#limitations-of-big-tables)**
>
> Scale your app with up to 10 million rows of data.

---

<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:** [June 6, 2023, 2:06am UTC](https://community.glideapps.com/t/can-i-use-the-following-computed-columns-in-big-tables/62475/3 "2023-06-06T02:06:27Z")

</div>

> [@Hassan\_Nadeem](#):
>
> Multi Relationships

Yes, but you cannot match with computed columns in the Big Table.

> [@Hassan\_Nadeem](#):
>
> Lookups

Yes, but only via Single Relations.

> [@Hassan\_Nadeem](#):
>
> Find Element Index

Yes, but if you’re wanting to use that to add a Row Index column to a Big Table, that won’t work because you can’t create the array of RowIDs that it would reference. (see previous answer)

> [@Hassan\_Nadeem](#):
>
> Query

Yes. The query column works really well with Big Tables.

> [@Hassan\_Nadeem](#):
>
> User Specific Column

Yes.

> [@Hassan\_Nadeem](#):
>
> Template

Yes.

> [@Hassan\_Nadeem](#):
>
> If-else

Yes.

---

<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:** [June 7, 2023, 2:07am UTC](https://community.glideapps.com/t/can-i-use-the-following-computed-columns-in-big-tables/62475/4 "2023-06-07T02:07:17Z")

</div>

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