Form Responses - Filled in on(matched up to) Master List instead of adding a new entry

[Melanie_LaDue]

I’ve got a Master Employee list and am sending out a survey that links to that list with the employee name field. They’ll choose their name from the list on the form, then fill out their information (shirt size, etc.) BUT, my issue comes with the responses.

It’s adding them as another entry on my Master List - but I want to know if it’s possible to have their information fill in on the master list, rather than adding a new entry…

Anyone have a workaround for this?

[Justin_Barrett]

Editing an existing record via an Airtable form is not possible with Airtable’s native tools. However, this can be done (sorta-kinda) with some clever table setup and form design:

Editing an existing record via an Airtable form…sorta-kinda… Show and tell

Summary People sometimes ask whether it’s possible to use an Airtable form to edit an existing record. Technically the answer is “no” because Airtable forms always create new records. However, a base can be set up so that records created by a form end up affecting records in another “mirror" table. As with my first show-and-tell submission, this was inspired by a solution that I created in another thread. Long story short, the key to that solution was using two tables: one for collecting form …

I believe it might also be possible using a third-party form tool like Jotform, though there may be a cost involved.

[Daniel_Raymond]

Is it now possible to achieve this using the new “automations” feature?

[Justin_Barrett]

Welcome to the community, @Daniel_Raymond! :grinning_face_with_big_eyes: Unfortunately not. Automations work with the data that’s already in Airtable. If a form creates a new record, that new record can trigger an automation, which can then operate on the new record, but an automation can’t intercept the incoming data to modify an existing record instead of adding a new record.