# Unable to show more that 10 rows in a Choice field

**URL:** https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294
**Category:** Report a Bug
**Created:** [July 23, 2023, 4:08pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294 "2023-07-23T16:08:21Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![Blaids\_Hearing](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blaids_hearing/32/62089_2.png) [@Blaids\_Hearing](https://community.glideapps.com/u/Blaids_Hearing)
#### Post date: [July 23, 2023, 4:08pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/1 "2023-07-23T16:08:21Z")

</div>

I have an app that takes user input from a predefined list. Recently i am unable to show more than 10 items in the drop down. Please note that i have note selected “limit number of items” option.

While this was working earlier and i was able to show more than 10 options in the drop down, now i am not able to show more that 10 options in the drop down in the “Choice” field created for user input.

 ![Items in app](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/8310584204cf634bd20461b3e2ab8a28418f265a.png)  
 ![Items in Excel](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/70af803013022009523a7b2e9b2fcd8e8e12d103.png)

---

<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: [July 23, 2023, 4:21pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/2 "2023-07-23T16:21:22Z")

</div>

I just tried to replicate this, but I can’t. A couple of questions:

- If you look in the Glide Data Editor, do you see all options?
- Are you working with a Glide Classic App?

---

<div class="post-metadata">

### Author: ![Blaids\_Hearing](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blaids_hearing/32/62089_2.png) [@Blaids\_Hearing](https://community.glideapps.com/u/Blaids_Hearing)
#### Post date: [July 23, 2023, 4:40pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/3 "2023-07-23T16:40:24Z")

</div>

I do not see al the options in glide data editor. The strage thing is even if i add all the items in the Glide Data editor, it gets added and i see it in the google sheet also in the app for a few mins. But after that it again goes back to the same state where i see 10 items in data editor and the app.

I am on a premium plan. I do not know what is glide app classic

 ![11 items](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/8120dba9805b30f0550cc4b1304a47869a77da96.png)

---

<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: [July 23, 2023, 4:51pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/4 "2023-07-23T16:51:13Z")

</div>

> [@Blaids\_Hearing](#):
>
> I do not see al the options in glide data editor. The strage thing is even if i add all the items in the Glide Data editor, it gets added and i see it in the google sheet also in the app for a few mins. But after that it again goes back to the same state where i see 10 items in data editor and the app.

That seems to suggest that there might be a sync issue. If you go to the Data Editor and force a manual sync, do you see any errors?

 ![CleanShot 2023-07-24 at 00.44.01@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/73c4ae8e73707d0ad564790ec71ee6282efb4f8d.jpeg)

> [@Blaids\_Hearing](#):
>
> I am on a premium plan. I do not know what is glide app classic

There is no such thing as a Premium Plan.  
You could either have a Team Based plan (Free, Starter, Pro, Business or Enterprise), or a legacy per App plan (Free, Basic, Pro, Private Pro).  
You can tell if your App is a Classic App by viewing it on your main dashboard. If it’s a Classic App, you will see the word “Classic” just below the App icon.

 ![CleanShot 2023-07-24 at 00.46.42@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4d4104cd7d91b7fe3fb2e841875d3f5dd26a93a.png)

---

<div class="post-metadata">

### Author: ![Blaids\_Hearing](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blaids_hearing/32/62089_2.png) [@Blaids\_Hearing](https://community.glideapps.com/u/Blaids_Hearing)
#### Post date: [July 28, 2023, 4:13am UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/5 "2023-07-28T04:13:14Z")

</div>

Yes, it is a classic app

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 28, 2023, 5:32am UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/6 "2023-07-28T05:32:51Z")

</div>

A lot of things not making sense here.

Your very first screenshot shows the choice component starting with Banana, whereas your sheet starts with American Nuts. That doesn’t make sense. Even if a table was only syncing 10 rows, it wouldn’t skip the first row.

You never showed what the data editor looks like in Glide. I don’t even know what data you are showing in your third screen shot. That data snippet is showing a RowID column, but I don’t see a row ID column in your sheet, so I don’t think you are showing us data from the correct table.

You never answered Darren’s question regarding what happens when you force a data sync. It’s hard to say if you have a sync issue, or if you are using the wrong table.

You never clarified which plan you are on. As Darren mentioned, there is not and has never been such a thing as a Premium plan. If you are on a free plan and you exceed your row limit, then it is possible that some tables will be truncated to 10 rows. It would really help to know which plan you are on, as well as where you are at for your app’s usage quotas.

I think the least relevant piece of information here is that it’s a Classic App. Shouldn’t really be that important as far as the issue is concerned.

---

<div class="post-metadata">

### Author: ![Steeve\_Richard](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steeve_richard/32/36486_2.png) [@Steeve\_Richard](https://community.glideapps.com/u/Steeve_Richard)
#### Post date: [August 3, 2023, 3:15pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/7 "2023-08-03T15:15:40Z")

</div>

Hi @Blaids_Hearing , do you resolved your isue? I have the same probleme for the moment. Impossible to make choice list for more 10 items. If i add new line in my google sheet, Glide remove line randomly during the sync

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 3, 2023, 3:55pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/8 "2023-08-03T15:55:25Z")

</div>

Which plan are you on?  
Where are you at as far as your usage limits for your plan?

---

<div class="post-metadata">

### Author: ![Steeve\_Richard](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steeve_richard/32/36486_2.png) [@Steeve\_Richard](https://community.glideapps.com/u/Steeve_Richard)
#### Post date: [August 3, 2023, 4:13pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/9 "2023-08-03T16:13:13Z")

</div>

Hi @Jeff_Hager , I m not to the limite 180/500. But after some test it is not a choice limit but a sheet probleme. If a create new sheet with only 2 columns, I’m not able to hav more 10 rows. I add 3 more columns and i can have more than 10 rows, is it Bug?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 3, 2023, 4:58pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/10 "2023-08-03T16:58:31Z")

</div>

I can kind of reproduce the issue, but not exactly as you say. Definitely seems like the manual sync is unreliable.

Have you tried simply refreshing the browser window?

---

<div class="post-metadata">

### Author: ![Steeve\_Richard](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steeve_richard/32/36486_2.png) [@Steeve\_Richard](https://community.glideapps.com/u/Steeve_Richard)
#### Post date: [August 3, 2023, 5:02pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/11 "2023-08-03T17:02:10Z")

</div>

Same probleme in new browser

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 3, 2023, 5:33pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/12 "2023-08-03T17:33:01Z")

</div>

I’m not sure what to say. I’ve seen weird things in the past, especially when you have other unused tables in your google sheet. I’ve had cases where the combination of used and unused tables would technically exceed the plan’s row limits, but the tables that were actually used by the app, had a cumulative row count less than the limit. Regardless, because of the extra unused data, it seems that glide will not willingly sync more than 10 rows in some tables. In my experience, it has usually worked itself out and returned to normal after a few days. Maybe it takes a while for Glide to realize which tables are used, and which are unused, and assign priority to those tables that are actually used by the app. 🤷‍♂️

I guess if you have extra unused tables in your google sheet, you could try removing them from the sheet itself, so your total cumulative rows across all tables are less than 500.

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [August 3, 2023, 5:44pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/13 "2023-08-03T17:44:17Z")

</div>

Moving this to #Report a Bug and opening a ticket with the dev team. 👍

@Steeve_Richard - Are you also having this issue in a Classic app?

---

<div class="post-metadata">

### Author: ![Steeve\_Richard](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steeve_richard/32/36486_2.png) [@Steeve\_Richard](https://community.glideapps.com/u/Steeve_Richard)
#### Post date: [August 3, 2023, 5:58pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/14 "2023-08-03T17:58:15Z")

</div>

Ok for thicket

Is it on classic app.

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [August 7, 2023, 4:10pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/15 "2023-08-07T16:10:11Z")

</div>

@Steeve_Richard @Blaids_Hearing

Thank you both. Two questions for you:

- Which plans are you on? (Free? Starter? Pro?)
- Can you provide a support link to your apps? [More info here.](https://community.glideapps.com/t/support-links/17192)

---

<div class="post-metadata">

### Author: ![fabio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio/32/16336_2.png) [@fabio](https://community.glideapps.com/u/fabio)
#### Post date: [August 22, 2023, 4:19pm UTC](https://community.glideapps.com/t/unable-to-show-more-that-10-rows-in-a-choice-field/64294/16 "2023-08-22T16:19:54Z")

</div>

Dear all, it seems to me I have the same issue with unused sheets…Would it be possible for someone from glide to check my app?

[https://go.glideapps.com/support/66af695c-b597-4e27-9f31-3e1b2394d7fd](https://go.glideapps.com/support/66af695c-b597-4e27-9f31-3e1b2394d7fd)

I am on a starter plan (not classic app). If I sum the row usage stated in “usage” web-page on glide and the viewable rows in the editor of the unused sheet (I have one unused sheet on the google sheet) it makes exactly 5000…which is my row limit…

I have been waiting for more than 2 weeks to see if this would have been soved on its own…

Thanks to anyone giving help!

Fabio
