Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / how to update only a specific field in a record?
Ask Question
Jiva Ram
Jiva Ram

Student

I am the only man in my village who has completed his education, and that fact carries both pride and responsibility. Coming from a remote rural area where education is often overlooked in favor of traditional labor, my journey was anything but easy.

Message

1 Answers

Jiva Ram
Jiva Ram 30 Jun 2025
Report Abuse

To update a specific field in a record in IndexedDB, follow this common pattern:

  • Get the record by key (get()).
  • Modify the specific field.
  • Put the updated record back using put().

IndexedDB doesn't support partial updates directly — so you need to overwrite the whole object after changing just the part you want.

Example: Update a Specific Field

Suppose we have a Users object store with this record:

{ id: 1, name: "John", email: "john@example.com", age: 30 }

Now we want to update only the email field.

Function to Update One Field

function updateField(db, storeName, key, fieldName, newValue) {
    return new Promise((resolve, reject) => {
        const tx = db.transaction(storeName, 'readwrite');
        const store = tx.objectStore(storeName);

        const getRequest = store.get(key);

        getRequest.onsuccess = () => {
            const record = getRequest.result;

            if (!record) {
                reject('Record not found');
                return;
            }

            // Update the specific field
            record[fieldName] = newValue;

            const updateRequest = store.put(record);

            updateRequest.onsuccess = () => resolve('Field updated');
            updateRequest.onerror = (e) => reject(`Update error: ${e.target.errorCode}`);
        };

        getRequest.onerror = (e) => reject(`Get error: ${e.target.errorCode}`);
    });
}

Usage

(async () => {
    const db = await openDatabase('MyDB', 'Users'); // use the openDatabase function from earlier

    try {
        await updateField(db, 'Users', 1, 'email', 'new.email@example.com');
        console.log('Email updated!');
    } catch (err) {
        console.error(err);
    }
})();

Tip: Batch Field Updates

To update multiple fields:

Object.assign(record, { email: 'new@email.com', age: 31 });

Summary

  • You must fetch the full object, update the field(s), then overwrite it with put().
  • IndexedDB doesn’t support in-place field updates (like SQL’s UPDATE ... SET ...).
  • Use get(), modify, and put() for partial updates.
advertising