Not using Airtable’s native forms. Airtable forms always add new records. They currently can’t be used to edit existing records. For that, you’ll need to use a third-party form tool like Jotform or Typeform, and route the output from that form through either Zapier or Integromat to update the appropriate Airtable record. You might consider posting to the Work Offered category to get help building this system if you don’t feel like you can do it on your own.
I’m confused. If you’re using an Autonumber field and a formula to create the ID values as I suggested earlier, duplicate numbers are impossible. Autonumber never duplicates numbers, so the final number created by the formula will always be unique. Could you please describe what you did in greater detail?
