Help

Duplicate Custom Form Entries

Topic Labels: Views
Solved
Jump to Solution
1584 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Pamela_Hannon
6 - Interface Innovator
6 - Interface Innovator

Hello -
I recently created a Custom form using the ‘Encode URL’ component to prefill fields on a feedback form for our members. We email the custom URL to customers but when they complete it, it’s creating a duplicate entry on the grid view in Airtable vs updating the record with the URL we sent. Anyone else experience this? Is there some way to prevent it?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Submitting a form in Airtable always creates a new record. Submitting a form never updates existing records.

The prefill feature is simply there to help your users do quicker data entry when filling out a form… for when they are wanting to create a new record in your system. The prefill feature is not designed to match & update an existing record in your system.

To update an existing record in your system, you would need to turn to external tools such as MiniExtensions.com, Zapier.com, Integromat.com, or Stacker.

Also, to quickly eliminate duplicate records in your system, you can use the Dedupe Block.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Submitting a form in Airtable always creates a new record. Submitting a form never updates existing records.

The prefill feature is simply there to help your users do quicker data entry when filling out a form… for when they are wanting to create a new record in your system. The prefill feature is not designed to match & update an existing record in your system.

To update an existing record in your system, you would need to turn to external tools such as MiniExtensions.com, Zapier.com, Integromat.com, or Stacker.

Also, to quickly eliminate duplicate records in your system, you can use the Dedupe Block.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

Pamela_Hannon
6 - Interface Innovator
6 - Interface Innovator

Great, thanks for your help!