Breaking News: Grepper is joining You.com. Read the official announcement!

Plumsail - DataTable Cascading Dropdowns

Levent Acar answered on May 3, 2022 Popularity 1/10 Helpfulness 1/10

answer Plumsail - DataTable Cascading Dropdowns

Plumsail - DataTable Cascading Dropdowns

Comment

fd.spRendered(function() {
    fd.control('DataTable1').$on('edit', function(e) {
        if (e.column.field === 'Category') {
            //pass widget + current Category value
            populateCategories(e.widget, e.model.Category);
        }

        if (e.column.field === 'Product') {
            //pass widget + current Category and Product value
            populateProducts(e.widget, e.model.Category, e.model.Product);
        }
    })

});

function populateCategories(widget, value) {
    //will show as loading
    widget._showBusy();

    sp.web.lists.getByTitle('Categories').items
        .select('ID', 'Title')
        .get()
        .then(function(items) {
            //set options
            widget.setDataSource({
                data: items.map(function(i) { return i.Title })
            });

            //set value if one was select
            widget.value(value);
            //hide loading state
            widget._hideBusy();
        });
}

function populateProducts(widget, parentValue, value) {
    //will show as loading
    widget._showBusy();

    sp.web.lists.getByTitle('Products').items
        .select('ID', 'Title', 'Category/Title')
        .expand('Category')
        .filter("Category/Title eq '" + parentValue + "'")
        .get()
        .then(function(items) {
            widget.setDataSource({
                data: items.map(function(i) { return i.Title })
            });

            //set value if one was select
            widget.value(value);
            //hide loading state
            widget._hideBusy();
        });
}

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: plumsail.com

Tags: cascading datatable javascript

Link to this answer
Share Copy Link

Contributed on May 03 2022

Levent Acar

0 Answers Avg Quality 2/10

Plumsail - DataTable Cascading Dropdowns

Contents

More Related Answers

Plumsail - DataTable Cascading Dropdowns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.