Append Data With Airtable Automations in Multi Select & Linked Records (Update Records)

In this video, I will show you how to append data with Airtable automations. After wathing this video, you will be able to use Airtable automations to append data in multi select and linked records. Additionally, at the end of this video I include a bonus tip about how to how to update Airtable records from new rows in Google sheets. I hope you enjoyed this video about how to append data with Airtable automations and you use these skills to gain value!

I hope you loved that video! Hit the subscribe button and smash the like button. If you have any questions or have a question you want answered, throw it in the comments section!!

AIRTABLE HELP

MY FAVORITE SOFTWARE

🎥GET MY GEAR

SAY HI

WHO AM I?
My name is Ben Green, I am the CEO of Optimize IS. We help remote teams, small businesses, startups, and other small teams set up the information systems that run your business when you sleep. This allows you to save time, save money, be more efficient, and work in your zone of genius.

We do this though implementing “best practice” processes with the most integrated software stack to back up the processes. We implement software tools like Airtable, Asana, Slack, Toggl, Active Campaign, Process Street, JotForm, Zapier, and many more to make your business run smoothly. Also, we use methods such as database implementation, workflow automation, and systems integration. We have experts on our team in Airtable Consulting, Zapier Consulting, and Systems Integration.

• Reliable automation frees countless hours
• Streamlined workflows for better efficiency
• Increase revenue by eliminating faulty and inefficient systems
• Solutions suitable for non-tech savvy users
• Done-for-you, customized optimization of all processes
• Easy to use automation with little or no coding required
• Optimizing your software stack eliminates wasteful redundancies

*note: There may be affiliate links in this description or video*

#bengreen #automation #optimizeis #airtable #zapier

[scotty]

Ben, your videos are great! Love them! Also loved how you showed how to work through a problem that crops up.

[patrickdezeeuw]

how do you get airtable to return a static value from a formula and store it in a cell in airtable? i want to keep the value from an estimate without having it get modified later if prices change in the product table. Thank you.

[cottagekeeper]

Always appreciate your tutorials! I need to do this with blank fields within Airtable. My scenario is I have two tables one is inventory the second is transactions. I get a .csv file and paste it into the transactions table every week or so. Using the Item ID# I would like some of the data from the transactions table to populate into the specific fields in the Inventory table. Basically updating the records in my Inventory table based on the Item ID#. Can this be done?

[krisw.]

Nice tutorial, Ben. Glad to see you left in the "hiccup." It's helpful to see you work through that. One issue that I found with the dynamic Find Record automation - if the trigger is based on a record within Airtable (rather than a record in Google Sheets as in your example), when looking for a record with [let's say "Name"] that matches a field value from the record in step one I cannot seem to pull that field value. It seems to be a glitch right now (recognizing that Find Record is a very new automation).

[ShacharHaas]

Great tutorial, question... how can I group this by individual contact? for instance, the table as it was on 01:08, when I group it by contact, it shows one record for Ben, one for Jane and one for both! I want to have 2 records for each contact...Thanks