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] 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.

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

Watch the below video tutorial: [image] dizzy The Trebuchet Method Community Resources 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…

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.

How to avoid duplicated info in the same topic?

Ask for Help

Darren_Murphy September 18, 2022, 5:14am 3

Watch the below video tutorial:

Topic		Replies	Views
Multiple Key Ask for Help	6	333	December 12, 2022
Limit duplicates display in a collection Ask for Help	1	37	July 18, 2025
No duplicate row Ask for Help	1	253	June 6, 2022
Duplicate a table when submitting a form? Ask for Help	0	79	April 3, 2024
Determine if row exists in a table Ask for Help	10	2271	December 4, 2021

How to avoid duplicated info in the same topic?

Related topics