# English Dictionary with 163,819 rows! **URL:** \ **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:** 2
**Author:** ![ray\_d](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@ray\_d](https://community.glideapps.com/u/ray_d)\ **Post date:** [July 11, 2021, 1:40pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/21 "2021-07-11T13:40:32Z")
This is awesome! Well done @Uzo ! Some UX feedback: I love the touch of the loading hour glass gif while it’s searching/loading. But at first it wasn’t clear that it was searching/loading because the icon was so small and the old results were still on the page. I thought it wasn’t working at first. If this is technically feasible, I think it can feel more responsive if you clear the list of results and replace it with a larger hour glass gif while it’s loading/searching. Otherwise-- incredible feat squeezing that much content into a free app! ---
**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 11, 2021, 2:00pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/22 "2021-07-11T14:00:40Z")
tnx… this App just past 1000 free edits… lol so it might not work correctly for few days… until it will reset… (free App) ---
**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 14, 2021, 1:43pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/23 "2021-07-14T13:43:40Z")
@Uzo do you know if there is a max number of rows that a single tab of GSHeet can have? I understand a GSheet workbook is limited to 5M cells. ---
**Author:** ![Gideon\_Lahav\_Busines](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gideon_lahav_busines/32/41121_2.png) [@Gideon\_Lahav\_Busines](https://community.glideapps.com/u/Gideon_Lahav_Busines)\ **Post date:** [July 14, 2021, 1:50pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/24 "2021-07-14T13:50:47Z")
How did you do the “top” button ---
**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 14, 2021, 2:06pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/25 "2021-07-14T14:06:43Z")
I believe it’s toggling between two different tabs with visibility conditions. ---
**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 14, 2021, 6:10pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/26 "2021-07-14T18:10:10Z")
There is no actual limit of rows in gs… 5 mil cell is a limit… so you can have 5 mil rows if you have just 1 column… The top button is a manipulator between 2 clone lists visibility ---
**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 15, 2021, 9:15pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/27 "2021-07-15T21:15:13Z")
Care to share that workflow or formula? would love to try it as I am building a Sustainability Dictionary… thank you ---
**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 16, 2021, 5:49pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/28 "2021-07-16T17:49:52Z")
I’m just trying to figure out what to do in sheets to handle the query so that the rows are counted less… right now it is filling up my app… ---
**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 16, 2021, 6:09pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/29 "2021-07-16T18:09:49Z")
You need to filter your database and divide results by maximum 400 rows… in my app i did by 100 for faster loading… then create a button to load next 100 results, so you need 3 Google sheets for this to work. ---
**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:** [August 21, 2021, 4:05am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/30 "2021-08-21T04:05:10Z")
1000 views … thank you! > **[English Dictionary](https://english-dictionary.glideapp.io/)** > > 163,819 words, english dictionary, with two way search [![avatar dictionary](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2fdbc74aa4dfe9cc37e2fa8f62a21c876666c340.jpeg)](https://english-dictionary.glideapp.io/) some new functionality was added ---
**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\ **Post date:** [August 21, 2021, 2:26pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/31 "2021-08-21T14:26:37Z")
Hi, very nice app; can you tell me (us) how and where you put the loading hour glass and how to activate it? Wim ---
**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:** [August 21, 2021, 6:44pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/32 "2021-08-21T18:44:06Z")
You put it as an avatar, and activate with if else column ---
**Author:** ![Wim\_De\_Coninck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wim_de_coninck/32/28179_2.png) [@Wim\_De\_Coninck](https://community.glideapps.com/u/Wim_De_Coninck)\ **Post date:** [August 27, 2021, 3:59pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/33 "2021-08-27T15:59:53Z")
Thanks, I could add an avatar (one image with avatar, another without). I hope you understand what I mean. In my app I’m using 2 GS, one with ± 2000 lines (= static data) and another one with one sheet that has the search-string (input via Glide App). With filter/importrange, the results are copied to a sheet that is read by Glide. So far so good and when a user hits my “search” button, I changed a parameter in my GS from 0 to 1 to have Glide (visibility of component) switching between image with and without avatar. But I can’t figure out to let GS or Glide know the filtering had ended (to set my parameter back from 0 to 1) Any suggestion? ---
**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:** [August 27, 2021, 7:42pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/34 "2021-08-27T19:42:49Z")
I’m using gs formula to copy keywords to another column and in glide if else column to check if these two are the same… this way i know when search is finished ---
**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:** [December 12, 2022, 10:59am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/35 "2022-12-12T10:59:07Z")
![English Dictionary](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff5ee8bf66fa20d167f62e84499dbb9b59bcd196.jpeg) I redesigned my English Dictionary App LOL. Now you can have unlimited editable rows in the Free Glide App, that you can view, edit, and add new rows… also improved loading speed by 2-5 seconds, choosing pages, searching inside pages, improving back to top button, and no Glide updates used! > **[Dictionary JSON](https://dictionary-json.glideapp.io/)** > > A free Glide App, with over 160 thousands rows, that you can view, edit and add more! No row limit No updates limit ---
**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:** [December 15, 2022, 2:37pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/36 "2022-12-15T14:37:47Z")
Speed improvement… it goes under 3 seconds now… I still do not see Glide edits… so… this is the Ultimate rows extender LOL, I tested multiple users searching the same key at the same time… no problems! I made a mini version of the Dictionary App… just to extend my free rows and edits… ![Exterial Data](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d7391f7121d5076cbb72bba4d6ae782778f75ebf.jpeg) > **[External Data Glide](https://external-data-glide.glideapp.io/)** > > Super fast external data storage ---
**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:** [January 4, 2023, 3:51am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/37 "2023-01-04T03:51:14Z")
New improved version!!! - much faster - pages can be entered manually ( to avoid scrolling hundreds of them) - instant page switching - improved mobile speed - unlimited rows - unlimited Glide updates - it learns your search, to get your results faster ![Dictionary](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e099e3e2f00a05f0c154812a28efb3bff8476287.jpeg) > **[Dictionary JSON](https://dictionary-json.glideapp.io/)** > > A free Glide App, with over 160 thousands rows, that you can view, edit and add more! ---
**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:** [January 5, 2023, 8:27am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/38 "2023-01-05T08:27:51Z")
@Uzo > ---
**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:** [January 5, 2023, 1:54pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/39 "2023-01-05T13:54:34Z")
Thank you for your Twit! I will post the Pages version soon… 😀 ---
**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:** [January 7, 2023, 4:53am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/40 "2023-01-07T04:53:47Z")
since my App got the honor of the App of the Week!..(by no other than Glide itself 🤩) here is a sneak peek of my biggest take on Glide Pages… 164 thousand rows x 11 columns of data… over 80 million characters… all of that under half of the second (up to 3-5 sec for the initial call) I literally coded an OS for Glide and Google Sheets… redid all mapping and coding from the English Dictionary App… The results are so impressive!!! ![main view](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/918a4dd38e90ce98f66108427616a4273a86d474.jpeg) ![main view 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/797a5dd830a1b0956a554e30413a96439b75bfc8.jpeg) Thank you Glide for making my App the App of the week… I got hundreds of hits!!! my counter is just going crazy … LOL (it was the first one???) Stay tuned for the finished Glide Page “Unlimited Data Source”. and this is the end of my Google Sheet… lol… I have to generate all of that data… and now is all accessible… editable… from Glide Page… UNDER 0.5 sec!!! ![Screen Shot 2023-01-07 at 12.02.42 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/8871bcf646a43ee2119faa94b37dde933753b34d.jpeg) [Previous page](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645.md?page=1) [Next page](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645.md?page=3)