I have a practical issue that entries in the forms are getting duplicated, as users chose to enter a new data when they have access to the link. This is creating duplication of entries in my database connected to the form.
How can I avoid duplicate entries, possibly using email address as a unique field ?
BR
Hi @uaebsagt ,
Yes, you can use the email as the unique key to merge records together for sure.
Could you please explain the use case ? I am guessing you need to send links to only authenticated users and they cant submit the form second time ?
Kind Regards,
Mehran
Yes, thats the right interpretation. We would like to avoid any duplicate entries, so we want to authenticate through email, or when someone is entering their email in the form, system should be able to detect if the email has already been captured. Request your kind support and advice in this regard.
Hi @uaebsagt ,
Let us work on the use case , i would keep you posted as we pushed an updated.
Kind Regards,
Mehran
Hi @uaebsagt ,
I am excited to inform you that we have added unique email check box so that same email can not be submitted again .
1 Like
Hey Mehran, I made the changes to chose email as the unique key in the form as per your recommendation. But when I check the Viprasanchaya Database, I can see a user who has submitted 8 entries with the same email ID. How can we avoid this ?
Onemore case, user has entered 25 entries with same email address. I had to delete one by one manually. I want a solution urgently
| Submitted On | Full Name of Primary Member |
|---|---|
| Fri, Nov 17, 2023 1:05 AM | Vinay Kumat |
| Fri, Nov 17, 2023 1:02 AM | Vinay Kumat |
| Fri, Nov 17, 2023 1:23 AM | Vinay Kumat |
| Sat, Nov 18, 2023 2:00 PM | Vinay Kumar |
| Sat, Nov 18, 2023 2:00 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:05 AM | Vinay Kumat |
| Sat, Nov 18, 2023 1:59 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:05 AM | Vinay Kumat |
| Fri, Nov 17, 2023 1:05 AM | Vinay Kumat |
| Fri, Nov 17, 2023 1:02 AM | Vinay Kumat |
| Sat, Nov 18, 2023 1:59 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:23 AM | Vinay Kumat |
| Fri, Nov 17, 2023 1:05 AM | Vinay Kumat |
| Sat, Nov 18, 2023 2:00 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:02 AM | Vinay Kumat |
| Sat, Nov 18, 2023 2:00 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:02 AM | Vinay Kumat |
| Sat, Nov 18, 2023 1:58 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:03 AM | Vinay Kumat |
| Sat, Nov 18, 2023 1:59 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:02 AM | Vinay Kumat |
| Fri, Nov 17, 2023 1:02 AM | Vinay Kumat |
| Sat, Nov 18, 2023 1:59 PM | Vinay Kumar |
| Fri, Nov 17, 2023 1:23 AM | Vinay Kumat |
| Fri, Nov 17, 2023 1:05 AM | Vinay Kumat |
Hi @uaebsagt ,
It may be due to old form and may have issue with the format. We can not reproduce the issue on our end and are still looking to find the root cause. Would update once we identify the issue.
Kind Regards,
Mehran
Please, as its been really creating lots of issue for us
Any updates on this issue Mehran, we are facing serious issues with many people reporting multiple records
Multiple records
| Submitted On | Full Name of Primary Member | |
|---|---|---|
| Mon, Nov 27, 2023 1:41 AM | Sahana Venkatesh | sahanavenkatesh@outlook.com |
| Mon, Nov 27, 2023 1:41 AM | Sahana Venkatesh | sahanavenkatesh@outlook.com |
| Mon, Nov 27, 2023 1:41 AM | Sahana Venkatesh | sahanavenkatesh@outlook.com |
| Mon, Nov 27, 2023 1:40 AM | Sahana Venkatesh | sahanavenkatesh@outlook.com |
| Mon, Nov 27, 2023 1:42 AM | Sahana Venkatesh | sahanavenkatesh@outlook.com |
Hey Mehran,
There are users who are also reporting errors when they register using the form. But when I check the Database their names are already existing with multiple records. Because it gives error, people are registering multiple times using the form. I need urgent assistance to solve this issue
Hi @uaebsagt ,
I am sorry for the delayed resolution and have escalated the issue to the dev team. Let us try to get back with a proper resolution .
Kind Regards,
Mehran
Thank you expecting your kind feedback
Mehran, Any progress, we are facing serious issues with duplicate records.
Who is this person testing data ? wit multpiple records ?
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
Roosevelt Pollich
hi @uaebsagt , we have pushed some changes few minutes back. can you check next few days and report back if any issues ?
Hi Mehran, I tried to add a record with an existing email id, and the record got saved. Please find below details
| Submitted On | Full Name of Primary Member(*) | Email (*) |
|---|---|---|
| Fri, Dec 8, 2023 3:52 AM | Arun Vasan | arunshi@yahoo.com |
| Wed, Dec 6, 2023 6:32 AM | Arun Vasan | arunshi@yahoo.com |
very odd . you have a big form may be let us try to duplicate the form and test on our end . d update once i push something .