Hi @AirtableIsGreat ,
Forms in Airtable always create new records, they never update existing records.
You have 2 options for working around this limitation:
1. You can have your form feed into an additional table that acts as the repository for all of your form submissions, and then you can create an automation in Airtable that finds the original record in the original table and updates the original record with the data from the form.
2. However, in my opinion, the quicker, easier, and more bulletproof way to create a form that updates existing Airtable records is to use Fillout's advanced forms for Airtable. You wouldn't even need to prefill the form because it automatically pulls in all the record data that you'd like to see on the form.
Fillout also offers over 100 advanced form features that Airtable's native forms don't offer, such as displaying formulas & lookup fields & rollup fields & attachments on forms, allowing dynamic linked record filters (i.e. dynamic dropdown selections), the ability to have multi-page forms with conditional paths, the ability to create new linked records on a form, the ability to accept payments on forms, visually displaying as many fields as you want to see in a linked record selection list (including attachment fields), limiting the number of linked records that can be chosen, and much more. I give a brief demonstration of Fillout on this episode of the BuiltOnAir Podcast.
p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
