Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Automation run on existing records

997 4
cancel
Showing results for 
Search instead for 
Did you mean: 
marizmarj
4 - Data Explorer
4 - Data Explorer

The automation currently we are using only works on new records. Is there any way to push the automation to run on existing records in the same table? Right now, when form received, it will create new record. Goal is when form received, it will auto fill out the existing records in the table. Appreciate your help. Thank you!

4 Replies 4

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

Alexswerdlow
5 - Automation Enthusiast
5 - Automation Enthusiast

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

This video shows you how to set up an Airtable base that will automatically email a list of contacts and collect their RSVP responses. It uses automations and prefilled form fields to do that. The original idea came from this video by John at @no-code , which shows how to use this method to create