# Row contious record keeping

**URL:** <https://community.glideapps.com/t/row-contious-record-keeping/29486>\
**Category:** Ask for Help\
**Created:** [July 23, 2021, 5:30pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486 "2021-07-23T17:30:22Z")\
**Posts on this page:** 8\
**Page:** 1

<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 23, 2021, 5:30pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/1 "2021-07-23T17:30:22Z")

</div>

The Problem: Running out of rows keeping records…

The Setup: Admin controls the transfer of points to a list of 1000 names and growing. An add row action is used for each recorded points transfer. Includes Name, Date, Points Amount, Unique Id.  
(I know I could keep a running tally but I need the individual records to be searchable later in an inline list.)

Potential Solution: Is it possible to create a dynamic set of joined lists for the 1000 names and have each transfer add to the joined lists respectively? And then unpack the joined list into an inline list when called on to search a specific name?..or is this just wishful thinking lol

---

<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 23, 2021, 5:39pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/2 "2021-07-23T17:39:18Z")

</div>

i’m not sure if i understand correctly…  
but, you can join columns with templet and then you can filter that column with condition if included in that column… this way you can filter whole row in one condition

---

<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 23, 2021, 5:41pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/3 "2021-07-23T17:41:26Z")

</div>

The issue I’m facing is trying to keep the points transfer near instant in-app.

If I archive the records in some way i.e. appscript or Integromat I’ll have to introduce spreadsheet formula which will slow down the in-app response time.

---

<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 23, 2021, 5:42pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/4 "2021-07-23T17:42:29Z")

</div>

do you mean you have more rows than app limit?

---

<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 23, 2021, 5:44pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/5 "2021-07-23T17:44:11Z")

</div>

Correct. On pace to consume more than 25k+ rows in ~6 months. (With this feature alone)

---

<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 23, 2021, 5:45pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/6 "2021-07-23T17:45:50Z")

</div>

check how i solve this problem in my app… 164 thousands rows!  
it might not work correctly because is over 1000 limit of edits now

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

---

<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 23, 2021, 5:51pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/7 "2021-07-23T17:51:33Z")

</div>

It is brilliant! I think I am doing something similar for other aspects of my app.

If you were to add a word to the dictionary how soon could you have it show up in an inline list? What’s important to me is that rollup of new points totals happens instantly.

The search time of those records (~15 seconds) I could live with… but new record entries and rollups need to be instant. Doable?

---

<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 23, 2021, 5:52pm UTC](https://community.glideapps.com/t/row-contious-record-keeping/29486/8 "2021-07-23T17:52:44Z")

</div>

is instant in GS… to show-up in Glide up to 5 sec
