Webform From One Table Update Another Table w/out Destroying

​@INeedSomeHelp 

Are you trying to update a pre-existing Airtable record with a form?

It sounds like you’re trying to merge the form submission’s data with the pre-existing data in a pre-existing record?

That is not natively supported by Airtable, but you could create an automation that updates the existing record’s multi-select field by appending the new data to the old data.

Within your automation’s “update record” action for the multi-select field, you can do this by inserting the NEW multi-select values, then typing a comma, then inserting the OLD multi-select values.

Please see my screenshot below for how this might look in your automations.

However, you will get unexpected results if either the OLD or the NEW values are blank. Airtable will add a blank entry to your multi-select values. To prevent that from happening, you would want to add some conditional actions to your automation to take different actions if either of the multi-select values are blank.

Although a much much easier way to update existing records with a form is to simply use Fillout’s advanced forms for Airtable, because it lets you update pre-existing Airtable records using a form!

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to:

• update Airtable records using a form
• create new linked records on a form
• create custom PDF files from a form submission
• display Airtable lookup fields on forms
• perform math or other live calculations on your forms
• create multi-page forms with conditional paths
• pre-fetch dynamic data from an Airtable record
• accept payments on forms
• customize the style and branding of your form
• customize a theme for your form
• add a login page to your form
• collect signatures on a form
• connect a single form to dozens of external apps simultaneously
• add CAPTCHAs to your form
• and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to update a pre-existing Airtable record & create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

The quickest way to do it would be like Scott mentioned above!  This adds a sort of ghost option in situations where the initial value is empty.  This is just a display thing and doesn’t affect one’s workflows normally

If you want to, you can add a Run a Script step to your automation to make that not happen and I’ve set it up here for you to check out!

And here’s how the script’s setup:

let { original, newOption } = input.config()

let combined = [...(original || []), ...(newOption || [])]

output.set('combined', combined)

Thank you. I’ll have to check in to this later. For some reason I feel like this isn’t going to work but I’ll check in and let you know.