# Is there any way to limit the row to 10 per user in the data table?

**URL:** https://community.glideapps.com/t/is-there-any-way-to-limit-the-row-to-10-per-user-in-the-data-table/73280
**Category:** Ask for Help
**Created:** [May 12, 2024, 4:44am UTC](https://community.glideapps.com/t/is-there-any-way-to-limit-the-row-to-10-per-user-in-the-data-table/73280 "2024-05-12T04:44:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![sang73](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sang73/32/74638_2.png) [@sang73](https://community.glideapps.com/u/sang73)
#### Post date: [May 12, 2024, 4:44am UTC](https://community.glideapps.com/t/is-there-any-way-to-limit-the-row-to-10-per-user-in-the-data-table/73280/1 "2024-05-12T04:44:30Z")

</div>

Is there a way to limit the row to 10 per user using Glide’s own data table without using Google Sheets?

If the user adds a row, I ask if it is possible to delete the old row first.

---

<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: [May 12, 2024, 4:50am UTC](https://community.glideapps.com/t/is-there-any-way-to-limit-the-row-to-10-per-user-in-the-data-table/73280/2 "2024-05-12T04:50:00Z")

</div>

> [@sang73](#):
>
> Is there a way to limit the row to 10 per user using Glide’s own data table without using Google Sheets?

Yes. Use a query or multiple relation plus a rollup column to determine how many rows have already been added, then add a condition to your Add action to only allow if the total is less than or equal to 10.

> [@sang73](#):
>
> If the user adds a row, I ask if it is possible to delete the old row first.

Yes, you could do that also.  
You could use a single value column to fetch the RowID of the first record added by the User, use that RowID value to create a Single Relation, and then delete the row via that relation.

---

<div class="post-metadata">

### Author: ![sang73](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sang73/32/74638_2.png) [@sang73](https://community.glideapps.com/u/sang73)
#### Post date: [May 12, 2024, 4:57am UTC](https://community.glideapps.com/t/is-there-any-way-to-limit-the-row-to-10-per-user-in-the-data-table/73280/3 "2024-05-12T04:57:47Z")

</div>

thank you for your answer. it’s solved!!! thanks you x 100

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [May 19, 2024, 4:58am UTC](https://community.glideapps.com/t/is-there-any-way-to-limit-the-row-to-10-per-user-in-the-data-table/73280/4 "2024-05-19T04:58:47Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.