# English Dictionary with 163,819 rows!

**URL:** <https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645>\
**Category:** Project Showcase\
**Created:** [July 3, 2021, 4:11am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645 "2021-07-03T04:11:11Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 3, 2021, 4:11am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/1 "2021-07-03T04:11:11Z")

</div>

this is example how to use big numbers of rows in free or paid App… enjoy!  
(in this app i’m using 163,819 rows but i can easy add up to 2 millions)

> **[English Dictionary](https://english-dictionary.glideapp.io/)**
>
> 163,819 words, english dictionary, with two way search

[![Screen Shot 2021-07-03 at 12.04.07 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94d90d419384ae3dbd84b7be070880316f3a0c99.png)](https://english-dictionary.glideapp.io/)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 3, 2021, 4:59am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/2 "2021-07-03T04:59:57Z")

</div>

please let me know if you can find a bigger data files for dictionary … tnx

---

<div class="post-metadata">

**Author:** ![Fabio\_Leanzi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio_leanzi/32/6838_2.png) [@Fabio\_Leanzi](https://community.glideapps.com/u/Fabio_Leanzi)\
**Post date:** [July 3, 2021, 6:39am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/3 "2021-07-03T06:39:04Z")

</div>

Very interesting! How did you do?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 3, 2021, 9:34am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/4 "2021-07-03T09:34:05Z")

</div>

just updated to a 157,548 (rows) words with descriptions !!! lol… and this is a free App! ;-))))  
Search time 5 to 10 seconds. Sometimes is getting stock for glide to populate whole list, but not bad!

---

<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 3, 2021, 9:59am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/5 "2021-07-03T09:59:44Z")

</div>

Curious to know how you implemented the “Go to Top” action?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 3, 2021, 10:01am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/6 "2021-07-03T10:01:32Z")

</div>

two lists with visibility condition

---

<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 3, 2021, 10:02am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/7 "2021-07-03T10:02:23Z")

</div>

ah, okay

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 3, 2021, 11:13am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/8 "2021-07-03T11:13:25Z")

</div>

now i can play scrabble ! LOL… I can’t believe how good this is… no need for PRO Apps… hahahah

---

<div class="post-metadata">

**Author:** ![administrasi\_kitsda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/administrasi_kitsda/32/7240_2.png) [@administrasi\_kitsda](https://community.glideapps.com/u/administrasi_kitsda)\
**Post date:** [July 3, 2021, 2:59pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/9 "2021-07-03T14:59:28Z")

</div>

This use query on google sheet i think.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 3, 2021, 10:08pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/10 "2021-07-03T22:08:29Z")

</div>

Not exactly, but close 😉

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 4, 2021, 8:29am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/11 "2021-07-04T08:29:57Z")

</div>

I updated 7k more words, and i think is good enough

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [July 4, 2021, 10:15am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/12 "2021-07-04T10:15:05Z")

</div>

That is a juicy row count! Interesting 🧐

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [July 4, 2021, 3:16pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/13 "2021-07-04T15:16:33Z")

</div>

Well done.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 4, 2021, 6:07pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/14 "2021-07-04T18:07:47Z")

</div>

thank you! Let me know guys if is working well?

---

<div class="post-metadata">

**Author:** ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)\
**Post date:** [July 9, 2021, 8:42pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/15 "2021-07-09T20:42:26Z")

</div>

Ok… so this is awesome. I have a Surveyors Dictionary App that has far less rows, but I am having a hard time figuring out how to add the search screen in a way which doesn’t overload my free app. Any chance you could provide a short tutorial?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 9, 2021, 9:15pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/16 "2021-07-09T21:15:27Z")

</div>

You have to create a formula that bring only limited amount of results to a sheet where glide takes data from, to populate list, than another function to bring next load of limited results when user click next button. In my app i divided results by 100 at the time, so it will fast load data and not cross 500 rows limit for the free app

---

<div class="post-metadata">

**Author:** ![Blue\_Community](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blue_community/32/16616_2.png) [@Blue\_Community](https://community.glideapps.com/u/Blue_Community)\
**Post date:** [July 9, 2021, 9:21pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/17 "2021-07-09T21:21:46Z")

</div>

When you say “formula” do you mean create an action or multistep action?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 9, 2021, 9:22pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/18 "2021-07-09T21:22:14Z")

</div>

Formula in Google sheets, all magic is happening in Google sheets, glide is only displaying results

---

<div class="post-metadata">

**Author:** ![administrasi\_kitsda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/administrasi_kitsda/32/7240_2.png) [@administrasi\_kitsda](https://community.glideapps.com/u/administrasi_kitsda)\
**Post date:** [July 10, 2021, 1:32pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/19 "2021-07-10T13:32:45Z")

</div>

I think it only works well with display app. Can we edit data

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [July 10, 2021, 1:42pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/20 "2021-07-10T13:42:05Z")

</div>

You can easily add data the way you would normally do, to edit it… that has to be done by script, so it will be about 5 seconds delay. @administrasi_kitsda… so if a little delay is not a big problem… you can have a free app with up to 5 million rows… but if don’t mind up to 10-15 seconds delays… you can expand the rows limit almost infinitely… by adding more Google sheets and spreadsheets.

[Next page](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645.md?page=2)
