# Concatenate Fields Before Insert

**URL:** <https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127>\
**Category:** Ask the community\
**Tags:** code\
**Created:** [April 15, 2024, 7:06am UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127 "2024-04-15T07:06:15Z")\
**Posts on this page:** 20\
**Page:** 3

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 7:37pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/41 "2024-04-17T19:37:50Z")

</div>

```javascript
function ProductsServices_beforeInsert(item) {
    const fieldValue1 = item.make;
    const fieldValue2 = item.model;
    // Concatenate the values
    const concatenatedValue = fieldValue1 + " " + fieldValue2;
    // Update the item with the concatenated value before inserting it into the collection
    item.makeModel = concatenatedValue;
    console.log(item);
    return item;
}

```

Try this

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 7:40pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/42 "2024-04-17T19:40:50Z")

</div>

by the way you can just concatenate the 2 objects like this:

```javascript
item = {
    "make": "make",
    "model": "model",
    "makeModel": ""
};
item.makeModel = item.make + " " + item.model

```

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 7:42pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/43 "2024-04-17T19:42:04Z")

</div>

OK. Where do I put this code ?

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 7:43pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/44 "2024-04-17T19:43:02Z")

</div>

is your code in the backend or frontend?

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 7:45pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/45 "2024-04-17T19:45:43Z")

</div>

backend

 ![Screenshot 2024-04-17 at 20.45.11](https://us1.discourse-cdn.com/wix/original/3X/8/0/802a17a65345ff1517c9eaa046e5bbcfce224a63.png)

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 7:47pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/46 "2024-04-17T19:47:26Z")

</div>

are you going to use wix-data and write the item to any collection?

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 7:48pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/47 "2024-04-17T19:48:43Z")

</div>

I am writing to a single collection when I edit the collection directly through the CMS

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 7:50pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/48 "2024-04-17T19:50:18Z")

</div>

just use the

```javascript
item = {
    "make": "make",
    "model": "model",
    "makeModel": ""
};
item.makeModel = item.make + " " + item.model

```

whenewer you need it there is no need for a function

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 7:52pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/49 "2024-04-17T19:52:28Z")

</div>

OK, where do I place this code ? In a hook ?

 ![Screenshot 2024-04-17 at 20.54.54](https://us1.discourse-cdn.com/wix/original/3X/6/c/6ce0ac14efac893133b44994b405220d107f5506.png)

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 8:00pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/50 "2024-04-17T20:00:25Z")

</div>

so lets say you want to write to the collection just use

```javascript
export function addToCollection(item){
    item.makeModel = item.make + " " + item.model;

    wixData.save('Cars', data).then(() => {
        console.log("Writing Successful. Make Model: " + item.makeModel)
    } ).catch((err) => {
        console.error(err);
    });
}

```

Note this will give an error becouse yo are using reference for your make field

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 8:03pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/51 "2024-04-17T20:03:42Z")

</div>

OK. How do I avoid the error ?

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 8:04pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/52 "2024-04-17T20:04:24Z")

</div>

How do I call this function when the item is added or updated ?

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 8:08pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/53 "2024-04-17T20:08:53Z")

</div>

```javascript
export function addToCollection(item){
    let makeID;

    wixData.query("makes")
      .eq("tittle"), item.make)
      .find()
      .then((results) => {
        if(results.items.length > 0) {
          makeID = results.items[0]._id;
        } else {
          console.err('no make found by name' + item.make)
        }
      })
      .catch((err) => {
        console.log(err);
      });
    item.makeModel = item.make + " " + item.model;

    let data = {
         "make" : makeID,
         "model": item.model,
         "makeModel": item.makeModel,
    }

    wixData.save('Cars', data).then(() => {
        console.log("Writing Successful. Make Model: " + item.makeModel)
    } ).catch((err) => {
        console.error(err);
    });
}

```

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 8:09pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/54 "2024-04-17T20:09:49Z")

</div>

and call the function whenever you want it to work

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 8:11pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/55 "2024-04-17T20:11:29Z")

</div>

Sorry, I am brand new to Velo and Wix.

How do I call it when a new item is added ?

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 8:12pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/56 "2024-04-17T20:12:23Z")

</div>

where it is going to be added?

---

<div class="post-metadata">

**Author:** ![user1786](https://avatars.discourse-cdn.com/v4/letter/u/ec9cab/32.png) [@user1786](https://forum.wixstudio.com/u/user1786)\
**Post date:** [April 17, 2024, 8:14pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/57 "2024-04-17T20:14:39Z")

</div>

I am adding items manually directly to my collection via the CMS.

I was getting undefined undefined earlier which seemed like progress but now I am getting nothing.

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 8:18pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/58 "2024-04-17T20:18:56Z")

</div>

becouse we didnt call the function

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 8:19pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/59 "2024-04-17T20:19:36Z")

</div>

can you share an screenshot?

---

<div class="post-metadata">

**Author:** ![Onur\_HAN](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onur_han/32/81620_2.png) [@Onur\_HAN](https://forum.wixstudio.com/u/Onur_HAN)\
**Post date:** [April 17, 2024, 8:20pm UTC](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127/60 "2024-04-17T20:20:35Z")

</div>

can you show me your collections?

[Previous page](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127.md?page=2)

[Next page](https://forum.wixstudio.com/t/concatenate-fields-before-insert/58127.md?page=4)