# Prevent data duplication in create new row

**URL:** https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613
**Category:** Ask for Help
**Created:** [June 19, 2025, 3:31pm UTC](https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613 "2025-06-19T15:31:31Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![jikasef](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@jikasef](https://community.glideapps.com/u/jikasef)
#### Post date: [June 19, 2025, 3:31pm UTC](https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613/1 "2025-06-19T15:31:31Z")

</div>

I have a multi step form that creates a new row in a table. When user goes back and fort in the steps, a new row is created with the same data.  
How can I prevent duplicate data in the target table?

---

<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: [June 19, 2025, 3:39pm UTC](https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613/2 "2025-06-19T15:39:43Z")

</div>

Would be helpful if you can share more about how you have set it up.  
With a multi-step form, usually a row isn’t added until a user gets to the final step and submits. If the process of navigating the form is adding extra rows, then that suggests something is wrong with your setup. But without knowing/seeing what you’ve done, it’s very difficult to say exactly what the cause is.

---

<div class="post-metadata">

### Author: ![jikasef](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@jikasef](https://community.glideapps.com/u/jikasef)
#### Post date: [June 19, 2025, 3:48pm UTC](https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613/3 "2025-06-19T15:48:09Z")

</div>

The app is a golf score card.  
The setup is, for every step (hole) score is entered, next hole button is clicked to input score for next hole.  
On click (next hole) create new row in hole score table for data of previous hole. Reason for this is to be able to present live scores (Leader board - for public) as players enter scores.  
I hope this is clear enough 🤔

---

<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: [June 19, 2025, 3:52pm UTC](https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613/4 "2025-06-19T15:52:36Z")

</div>

Okay, so probably what you want to do is create some logic in the attached table to check whether or not the row for the previous hole already exists. And then modify your action so that a new row is only created if it isn’t already there.

---

<div class="post-metadata">

### Author: ![jikasef](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@jikasef](https://community.glideapps.com/u/jikasef)
#### Post date: [June 20, 2025, 8:55am UTC](https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613/5 "2025-06-20T08:55:28Z")

</div>

> [@Darren\_Murphy](#):
>
> create some logic in the attached table to check whether or not the row for the previous hole already exists. And then modify your action so that a new row is only created if it isn’t already there.

Can’t seem to get the logic right 🙁  
any pointers will be appreciated.

---

<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: [June 20, 2025, 9:13am UTC](https://community.glideapps.com/t/prevent-data-duplication-in-create-new-row/82613/6 "2025-06-20T09:13:53Z")

</div>

Can you show me what the data looks like, and what you have tried?
