# How to avoid duplicated info in the same topic?

**URL:** https://community.glideapps.com/t/how-to-avoid-duplicated-info-in-the-same-topic/49559
**Category:** Ask for Help
**Created:** [September 18, 2022, 4:57am UTC](https://community.glideapps.com/t/how-to-avoid-duplicated-info-in-the-same-topic/49559 "2022-09-18T04:57:10Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Ettore\_Paiola](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ettore_paiola/32/47964_2.png) [@Ettore\_Paiola](https://community.glideapps.com/u/Ettore_Paiola)
#### Post date: [September 18, 2022, 4:57am UTC](https://community.glideapps.com/t/how-to-avoid-duplicated-info-in-the-same-topic/49559/1 "2022-09-18T04:57:10Z")

</div>

I have an app that allows users to confirm their presence at the event. There are 2 important data that are essential.

- Identify who is going to participate and who won’t from the event.
- Get only the last answer about each person related to each event. The answers are duplicated at the moment.

Here you can see an example. My user should be present only once.

 ![Screen Shot 2022-09-18 at 01.50.47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/283a15f153127eab9e420e85fb120905748100e1.jpeg)

What do I need to do to avoid the duplicated answer? The idea is to present only the last answer from each event.

My database is built with a table that records all the answers from the users.

Thanks for all support.

---

<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: [September 18, 2022, 5:13am UTC](https://community.glideapps.com/t/how-to-avoid-duplicated-info-in-the-same-topic/49559/2 "2022-09-18T05:13:05Z")

</div>

if you record answers directly to the event row… and then relate it… there should be no duplications

---

<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: [September 18, 2022, 5:14am UTC](https://community.glideapps.com/t/how-to-avoid-duplicated-info-in-the-same-topic/49559/3 "2022-09-18T05:14:19Z")

</div>

Watch the below video tutorial:

> [@dizzy The Trebuchet Method](https://community.glideapps.com/t/the-trebuchet-method/48325):
>
> In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w…

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 19, 2022, 12:38am UTC](https://community.glideapps.com/t/how-to-avoid-duplicated-info-in-the-same-topic/49559/4 "2022-09-19T00:38:02Z")

</div>

Are you recording it in multiple rows? If you don’t want to go the Trebuchet way, you can:

- Create a template joining the user’s email/ID with the event ID in the Events table, assuming you’re writing both of these fields in the destination table.

- Do the same template column on the destination table’s side.

- Create a relation from the Events table to the destination table using the 2 columns above.

- The button to confirm or reject should write a new row to the destination table if the relation above is empty, else you do a set column to set the chosen value to the existing row in the destination table.