# Upsert records without deleting existing records in Airtable **URL:** \ **Category:** Questions\ **Tags:** airtable\ **Created:** [April 29, 2024, 4:58pm UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494 "2024-04-29T16:58:10Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Vivien\_Chantrel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vivien_chantrel/32/18996_2.png) [@Vivien\_Chantrel](https://community.make.com/u/Vivien_Chantrel)\ **Post date:** [April 29, 2024, 4:58pm UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/1 "2024-04-29T16:58:10Z")
Hello All, My goal is to migrate data from a google sheet to an Airtable base to link them. The context is simple, I have a list of orders and each orders create a new customer in my customer table. If a customer already exist, I want to add the new order and link it to the customer records. But when a customer is already in the table, the records of the orders is not appended, it is updated, which means that he delete the first one to replace by the latest one. Whereas, I want to add it into the records without delete this orders into the customer records. I’ve tried smart links and many more but I can’t find a way to append them without delete the older order who were already appended to the customer records. ![Capture d’écran 2024-04-29 à 18.45.18](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/7/47e8d72fbd58fac2865cbb88c5a9854e9ae84370.png) In this screenshot, you can find the final result, What I’d like is both of them having the records of the customer linked to this order without deleting the first one because both of them are an order of this customers. ![Capture d’écran 2024-04-29 à 18.56.26](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/3/8371ef8c0b6602d6856ea2b704401c2016222be0.png) ![Capture d’écran 2024-04-29 à 18.56.33](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/4/c43af7d60e3bac65557663abe370e80f1f98bafa.jpeg) Thanks a lot for your help ! ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [April 30, 2024, 4:33am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/2 "2024-04-30T04:33:19Z")
@Vivien_Chantrel The Update module will replace the field value with the new value. To prevent the removal of existing values, retrieves the previous value from the search, combines it with the new value, and then updates the field accordingly. If you require additional assistance, please don’t hesitate to reach out to us. [MSquare Support](https://calendly.com/msquarepro/meeting) Visit us [here](https://www.msquare.pro/) [Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ) ---
**Author:** ![Vivien\_Chantrel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vivien_chantrel/32/18996_2.png) [@Vivien\_Chantrel](https://community.make.com/u/Vivien_Chantrel)\ **Post date:** [April 30, 2024, 8:27am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/3 "2024-04-30T08:27:48Z")
Hello, This is not an update but an upsert module. As you can see in the screenshot, I already have a search module before the update to determine if he has to create a new records or upsert into the new records. I dont want to update, I want to insert new order into the same customers. The smartlinks doesnt do anything. “If smart links is enabled, you can a) use names in linked record fields instead of record IDs to select an existing record or create a new one if it doesn’t exist b) use (add) new options in single/multiple select fields.” ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [April 30, 2024, 8:55am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/4 "2024-04-30T08:55:56Z")
Hi @Vivien_Chantrel Utilize the “create a record” module in your workflow. Here’s a sample workflow illustration: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/a/6a36dcccd93dcd06b18f1328358d37ac9eda6b07.png) Additionally, remember that when updating records, ensure that you merge the previous data you want to retain, otherwise it will be replaced as empty. If you require additional assistance, please don’t hesitate to reach out to us. [MSquare Support](https://calendly.com/msquarepro/meeting) Visit us [here](https://www.msquare.pro/) [Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ) ---
**Author:** ![Vivien\_Chantrel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vivien_chantrel/32/18996_2.png) [@Vivien\_Chantrel](https://community.make.com/u/Vivien_Chantrel)\ **Post date:** [April 30, 2024, 11:27am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/5 "2024-04-30T11:27:46Z")
Hello, Thanks for your answer, but this is what I do with the Upsert module. If the customer does not exist it will be create, otherwise, he will be update it. But me, I want to append the record id of the order into the customer records. The problem is it overtake all the last order who was linked instead of linking a new order. ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [April 30, 2024, 11:51am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/6 "2024-04-30T11:51:27Z")
Hi @Vivien_Chantrel Just appending new data will overwrite the existing data. In the example given below for status , the existing data is in array format, so new data must be added in the following format. Similar approach for the name field also. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/f/9fd06da8238d917cd6219c28d55f238e37bbac6e.png) ---
**Author:** ![Vivien\_Chantrel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vivien_chantrel/32/18996_2.png) [@Vivien\_Chantrel](https://community.make.com/u/Vivien_Chantrel)\ **Post date:** [May 1, 2024, 9:43am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/7 "2024-05-01T09:43:10Z")
Hello ! @Msquare_Automation ! Thanks a lot for your help. Basically, I didnt do what you told me to do because it was not specifically working for my case but I have found the solution. I changed the sense of the airtable module to get this. ![Capture d’écran 2024-05-01 à 11.42.01](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/c/5c2732b5da1d74c769cdb7e38fbc1f2f3f773818.png) I’ll search then upsert and then, create the records and link it to the record. My sense was not right at first. Thanks for your help, even if it was not the right solution, you taught me something and found then the solution. Have a great day! ---
**Author:** ![roberrtt](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/roberrtt/32/32609_2.png) [@roberrtt](https://community.make.com/u/roberrtt)\ **Post date:** [May 1, 2024, 12:52pm UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/8 "2024-05-01T12:52:00Z")
Thanks for sharing these insights mate as I found it very much useful and informative. ---
**Author:** ![vendy](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/vendy/32/12635_2.png) [@vendy](https://community.make.com/u/vendy)\ **Post date:** [May 2, 2024, 8:28am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/9 "2024-05-02T08:28:01Z")
Hey there @Vivien_Chantrel 👋 Just wanted to stop by and say congratulations for the great solution! Thank you very much for sharing with us as it’s helpful for other Makers as well. Keep up the awesome job! 🙏 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [May 15, 2024, 9:49am UTC](https://community.make.com/t/upsert-records-without-deleting-existing-records-in-airtable/35494/10 "2024-05-15T09:49:07Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.