Automation run on existing records

Hm could you elaborate on "fill out the existing records" in the table?  Can you provide example screenshots of your table setup as well as expected output from the automation?

The goal is to merge automatic the new record to existing record when the form received. We are using AirTable forms to fill out data from customers but customer has already existing record in the table/grid. We just them a form via email automation trigger just to update their form. Hope this helps. Thank you!

Ah I see!  Airtable has a guide on this that you might find useful: https://support.airtable.com/docs/use-case-update-records-via-a-form

Airtable forms will create new records as it's base functionality, so there's no way around that I'm afraid.  You could try adding a "Run a script" action to delete the submitted form if you want?

The other possibility would be to use a third party form tool like Fillout.com which provides functionality for you to edit records via a form

This is a fantastic tutorial on how to do this: https://www.youtube.com/watch?v=BkAY7OHEgdc. Hope it helps!