How to insert a number of dynamic fields into a mongoDB array?

Question

I have the following code in my page. Whenver I click on the "Add new field button" a new fields gets added to the page. What I need to accomplish is to insert every single new field into my mongodb database array.

    function addInput(divName){
        if (counter == limit)  {
            alert("You have reached the limit of adding " + counter + " inputs");
        }
        else {
            var newdiv = document.createElement('div');
            newdiv.className = "row-inputs";
            newdiv.innerHTML = '<input type="text" name="productName" placeholder="product name" class="q-product-name">'  + 
            '<input type="number" name="quantity" placeholder="1" class="q-quantity" value=1>' +
            '<input type="text" name="pricePerUnit" placeholder="price" class="q-price">' +
            '<input type="text" name="itemTotal" placeholder="price" class="q-total">';
            document.getElementById(divName).appendChild(newdiv);
            counter++;
        }
    }

The above is my schema:

const mongoose = require("mongoose");
const Schema = mongoose.Schema;

var InventorySchema = Schema({
    created_at: {type: Date, default: Date.now },
    name: String,
    list: [{
        product_name: String,
        quantity: Number,
        pricePerUnit: Number,
        itemTotal: Number
    }],
    invoiceTotal: Number,
    comment: String,
    dueDate: Date
})

var inventory = mongoose.model('inventory', InventorySchema);

module.exports = inventory;

How can I tell mongoose to add every fields created dynamically to my database?

Thank you so much!

Ridham Tarpara · Accepted Answer · 2018-03-20 04:27:21Z

1

You can not insert new fields if you have defined a static schema with types defined.

However, You can specify type of an attribute ({}) it will allow anything to be saved to it. If you want one of your object or whole schema dynamic then you can define a schema like this:

var InventorySchema = Schema({
    created_at: {type: Date, default: Date.now },
    name: String,
    list: [{ }],
    invoiceTotal: Number,
    comment: String,
    dueDate: Date
})

Caution: You will not be able to validate or typecast any of your dynamic variables.

answered Mar 20, 2018 at 4:27

Ridham Tarpara

6,1804 gold badges22 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Blinhawk Over a year ago

In that case, how would I loop true each different product? So far, I only get one "product name" with different values, instead a several product name with its own value.

Ridham Tarpara Over a year ago

unable to understand your concern. can you post the code snippet?

Collectives™ on Stack Overflow

How to insert a number of dynamic fields into a mongoDB array?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related