# $setOnInsert

*noun*

say it: **“DOL-er SET-on-in-SURT”** **/ˈdɑlər ˈsɛt ɑn ɪnˈsɝt/**

A MongoDB update operator that sets fields only when an upsert creates a new document.

## What does **$setOnInsert** do in a MongoDB update?

**$setOnInsert** sets its fields only when an upsert creates a new document; when the document already exists, they're left alone. It's how a first-saved date or a starting count is set once.

```javascript
db.ratings.updateOne(
  { user: "ana", recipeId: 4 },
  { $set: { stars: 5 }, $setOnInsert: { firstRated: new Date() } },
  { upsert: true }
);
// firstRated is set the first time only; stars changes every time
```

## In a sentence

- “Without **$setOnInsert**, the upsert would reset the join date each time the profile was saved.”
- “**$setOnInsert** stamped firstRated on the first rating and left it alone on every change after.”

Level: Journeyman · [More MongoDB terms at this level](https://www.ask-codey.com/glossary?category=mongodb&level=3)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/setoninsert
