- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 06, 2024 06:14 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 06, 2024 05:34 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 07, 2024 05:50 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 07, 2024 06:58 PM - edited ‎May 07, 2024 06:59 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2025 12:17 AM
This is a fantastic tutorial on how to do this: https://www.youtube.com/watch?v=BkAY7OHEgdc. Hope it helps!
