# Update or append in airtable **URL:** \ **Category:** Questions\ **Tags:** workflow-building, airtable\ **Created:** [June 15, 2022, 7:04am UTC](https://community.n8n.io/t/update-or-append-in-airtable/14871 "2022-06-15T07:04:50Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Joachim\_Brindeau](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/joachim_brindeau/32/13995_2.png) [@Joachim\_Brindeau](https://community.n8n.io/u/Joachim_Brindeau)\ **Post date:** [June 15, 2022, 7:04am UTC](https://community.n8n.io/t/update-or-append-in-airtable/14871/1 "2022-06-15T07:04:51Z")
Hello everyone, I’m having trouble understanding what blocks to use in the following case. I have: - A csv with record set A + record set B with field NUMBER - An airtable with record set A with field NUMBER and field ID **How can I check whether to append or update into airtable depending if the NUMBER from the CSV is already in Airtable or not?** I thought a simple switch would suffice but apparently not. Kind of lost on this. Thanks a lot Joachim ---
**Author:** ![marcus](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/marcus/32/15989_2.png) [@marcus](https://community.n8n.io/u/marcus)\ **Post date:** [June 15, 2022, 7:27am UTC](https://community.n8n.io/t/update-or-append-in-airtable/14871/2 "2022-06-15T07:27:14Z")
Hi @Joachim_Brindeau, you can use Airtables List operation with `Filter By Formula` to only return items where `fieldName="value"`, ![image](https://europe1.discourse-cdn.com/n8n/original/2X/e/eb11db50f2aeb7d1dae3ef076cc199a1b9db80a9.png) ---
**Author:** ![Joachim\_Brindeau](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/joachim_brindeau/32/13995_2.png) [@Joachim\_Brindeau](https://community.n8n.io/u/Joachim_Brindeau)\ **Post date:** [June 15, 2022, 7:45am UTC](https://community.n8n.io/t/update-or-append-in-airtable/14871/3 "2022-06-15T07:45:42Z")
Thanks! That would let me update the records. How do I filter out these records for the create step? My current issue is the duplicates being created. Thanks again for your help ---
**Author:** ![marcus](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/marcus/32/15989_2.png) [@marcus](https://community.n8n.io/u/marcus)\ **Post date:** [June 15, 2022, 11:10am UTC](https://community.n8n.io/t/update-or-append-in-airtable/14871/4 "2022-06-15T11:10:10Z")
Hey Joachim, the following workflow to append/update records in airtable is losely based on [n8n Course Level 1](https://docs.n8n.io/courses/level-one/). Make sure to also checkout [n8n Course Level 2](https://blog.n8n.io/announcing-course-level-two/) to better understand how to _work with data_ in n8n. The first time the records are appended. ![image](https://europe1.discourse-cdn.com/n8n/original/2X/0/0a81fb88f5372a25b0bd3afe77e6a6619c7be72d.png) The second time the records are updated. ![image](https://europe1.discourse-cdn.com/n8n/original/2X/7/74995c1fd9c64c8659e91b62d0d87b79cb34ed85.png) Make sure to update all occurences of `orderID` and `employeeName` according to your scenario. ---
**Author:** ![Joachim\_Brindeau](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/joachim_brindeau/32/13995_2.png) [@Joachim\_Brindeau](https://community.n8n.io/u/Joachim_Brindeau)\ **Post date:** [March 12, 2023, 2:18pm UTC](https://community.n8n.io/t/update-or-append-in-airtable/14871/5 "2023-03-12T14:18:53Z")
I did not notice your answer! Thanks a lot for taking the time. I gave up on n8n but seeing my [make.com](http://make.com) bill, now I’m back with a fresh install on AWS! ---
**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\ **Post date:** [March 19, 2023, 2:19pm UTC](https://community.n8n.io/t/update-or-append-in-airtable/14871/6 "2023-03-19T14:19:22Z")
Closed on March 19, 2023, 2:19pm UTC This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.