# Cannot use Single in Glide big table **URL:** \ **Category:** Ask for Help\ **Created:** [September 10, 2025, 6:01am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289 "2025-09-10T06:01:19Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Plai\_Official](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/plai_official/32/89253_2.png) [@Plai\_Official](https://community.glideapps.com/u/Plai_Official)\ **Post date:** [September 10, 2025, 6:01am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/1 "2025-09-10T06:01:19Z")
Hi there. I tried to use Single value in Glide big table but it doesn’t work. And I tried to use Relation from that big table. And also, it doesn’t save. Please help. ---
**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 10, 2025, 6:04am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/2 "2025-09-10T06:04:59Z")
There are limitations to Big Tables, which are documented below: > **[Big Tables | Glide Docs](https://www.glideapps.com/docs/essentials/data-sources/big-tables#limitations-of-big-tables)** > > Scale your app with up to 10 million rows of data. If you tell us more about your specific use case, we may be able to suggest a workaround. ---
**Author:** ![Plai\_Official](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/plai_official/32/89253_2.png) [@Plai\_Official](https://community.glideapps.com/u/Plai_Official)\ **Post date:** [September 10, 2025, 6:09am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/3 "2025-09-10T06:09:12Z")
> [@Darren\_Murphy](#): > > we may be a And also, I have just found that. It cannot use Roll up over than 100 rows. And why it named as Big table??? ---
**Author:** ![Plai\_Official](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/plai_official/32/89253_2.png) [@Plai\_Official](https://community.glideapps.com/u/Plai_Official)\ **Post date:** [September 10, 2025, 6:11am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/4 "2025-09-10T06:11:04Z")
In Glide AI described how to solve this problem by using multiple relation. But it still doesn’t work out. ---
**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 10, 2025, 6:12am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/5 "2025-09-10T06:12:07Z")
It depends what you are trying to rollup. If you are rolling up a non-computed column, there is no limit. If your are rolling up a computed column, yes the limit is 100 rows. ---
**Author:** ![Plai\_Official](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/plai_official/32/89253_2.png) [@Plai\_Official](https://community.glideapps.com/u/Plai_Official)\ **Post date:** [September 10, 2025, 6:13am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/6 "2025-09-10T06:13:55Z")
I tried this instruction step-by-step. But when I clicked save. It doesn’t allow to save. **“To create a Multiple Relation:** 1. In the Data Editor, add a new column 2. Select **Relation** as the column type 3. Specify matching values between tables (values must match exactly) 4. Enable **Match multiple** option 5. Click Done **Then use Single Value → First:** After creating the Multiple Relation, you can add a Single Value column that targets your Multiple Relation and select “First” to get a single value from the related data. This approach lets you access Big Table data through the relation, then extract the specific value you need with Single Value → First.” ---
**Author:** ![Swift\_Struck\_24](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swift_struck_24/32/91605_2.png) [@Swift\_Struck\_24](https://community.glideapps.com/u/Swift_Struck_24)\ **Post date:** [September 10, 2025, 6:34am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/7 "2025-09-10T06:34:12Z")
@Plai_Official , if you wanna extract a single entire row form a relation that is pulling data from another Glide Big Table.. then try these steps: 1. Create a relation from the current row to the Glide Big Table 2. Turn on “match multiple” for that relation column 3. Build a new query column and set the source to that relation column 4. Add a filter or use the sort option to sort the the field that will allow you to get your desired row at the top or bottom 1. In my case, if i always wanna extract the latest row, i sort the query by my “created on” timestamp by “Z-A” so the latest timestamp comes first 5. In your query, turn of “match multiple” to avoid returning more than 1 row Hope this helps 🙂 1. ![Screenshot 2025-09-10 at 12.00.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e3c5716595c0c2b5132ce21a68427e676bc514e.jpeg) ---
**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:** [September 11, 2025, 12:36am UTC](https://community.glideapps.com/t/cannot-use-single-in-glide-big-table/84289/8 "2025-09-11T00:36:25Z")
> [@Plai\_Official](#): > > And why it named as Big table??? Because in practice, it can hold much more rows than a normal table. But as Darren said, there are limitations on the calculation side so that your device doesn’t have to do an enormous load of work when you use the app.