Duplicate form entries

Paul Crawford

When using a form as an event registration page, how do i avoid someone registering for the event more than once? Is there a setting on a column i should use?

caseygilbert

1. Create a "Duplicates" Column:
   Add a new column, for example, named "Duplicates". You can set this column type to "Text/Number" or a "Checkbox" for a visual indication. 
2. Apply a Formula:
   In the "Duplicates" column, use a formula like =COUNTIFS([Column Name]:[Column Name], = [Column Name]@row, [Column 2]:[Column 2], =[Column 2]@row) to count occurrences of duplicate values across specified columns. If the count is greater than 1, it indicates a duplicate. 
3. Conditional Formatting:
   Set up conditional formatting based on the "Duplicates" column. If the value in the "Duplicates" column is greater than 1, apply formatting like highlighting the row or changing the cell background color to visually mark the duplicate. 
   OR
4. Create a Workflow:
   You can set up a workflow so that when a column is added and "Duplicates" becomes checked, you can automatically move or copy the row to another sheet (maybe label it [Sheet Name] Duplicates).
   
   In either case, I would still recommend some manual monitoring to make sure everything is working as it should be, but this should help your eyes!

caseygilbert

1. Create a "Duplicates" Column:
   Add a new column, for example, named "Duplicates". You can set this column type to "Text/Number" or a "Checkbox" for a visual indication. 
2. Apply a Formula:
   In the "Duplicates" column, use a formula like =COUNTIFS([Column Name]:[Column Name], = [Column Name]@row, [Column 2]:[Column 2], =[Column 2]@row) to count occurrences of duplicate values across specified columns. If the count is greater than 1, it indicates a duplicate. 
3. Conditional Formatting:
   Set up conditional formatting based on the "Duplicates" column. If the value in the "Duplicates" column is greater than 1, apply formatting like highlighting the row or changing the cell background color to visually mark the duplicate. 
   OR
4. Create a Workflow:
   You can set up a workflow so that when a column is added and "Duplicates" becomes checked, you can automatically move or copy the row to another sheet (maybe label it [Sheet Name] Duplicates).
   
   In either case, I would still recommend some manual monitoring to make sure everything is working as it should be, but this should help your eyes!