Jun 10, 2020 06:46 AM
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?
Solved! Go to Solution.
Jun 10, 2020 07:00 AM
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:
Jun 10, 2020 07:00 AM
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:
Jun 15, 2020 07:48 AM
Great, thanks for your help!