Products

image: img/spreadsheet-templates-software-feedback-tracker.jpg, folder: technology, category: template

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [
        {
            minDimensions: [, 7],
            worksheetName: 'Feedbacks',
            tableOverflow: true,
            data: [
                [1, 1, 'Functional error', 'Error in the registration system.', 'High', 2, true],
                [2, 1, 'Functional error', 'Student grade not updated', 'Medium', 3, true, ''],
                [5, 2, 'Design error', 'The interface does not conform to the prototype', 'Low', 4, false, ''],
                [3, 3, 'Functional error', 'Failed to select real-time location', 'Medium', 2, false, ''],
                [4, 3, 'Missing command', 'It is not possible to remove an item from the cart', 'High', 2, true, ''],
                [5, 2, 'Missing command', 'Error trying to remove an existing contact', 'Medium', 3, true, '']
            ],
            tableWidth: '800px',
            columns: [
                {
                    type: 'record',
                    title: 'User',
                    width: '120px',
                    worksheetId: 'users',
                },
                {
                    type: 'record',
                    title: 'Project',
                    width: '200px',
                    worksheetId: 'projects',
                    worksheetColumn: 1
                },
                {
                    type: 'dropdown',
                    title: 'Category',
                    width: '150px',
                    source: ['Functional error', 'Hardware error', 'Missing command', 'Design error'],
                    options: {
                        newOptions: true
                    }
                },
                {
                    type: 'notes',
                    title: 'Description',
                    width: '200px'
                },
                {
                    type: 'dropdown',
                    title: 'Priority',
                    width: '120px',
                    source: ['High', 'Medium', 'Low']
                },
                {
                    type: 'record',
                    title: 'Employee',
                    width: '150px',
                    worksheetId: 'employees',
                },
                {
                    type: 'checkbox',
                    title: 'Fixed',
                    width: '100px'
                }
            ],
        },
        {
            data: [
                [ '1', 'School App', 'Changing the education', 'Mobile' ],
                [ '2', 'Social Managment', 'Manage all your contacts in the same platform', 'Mobile' ],
                [ '3', 'Delivery App', 'Food delivery', 'Mobile' ],
            ],
            minDimensions: [, 4],
            worksheetName: 'Projects',
            worksheetId: 'projects',
            columns: [
                {
                    type: 'text',
                    title: 'Code',
                    width: '100px',
                    primaryKey: true,
                },
                {
                    type: 'text',
                    title: 'Project name',
                    width: '140px'
                },
                {
                    type: 'notes',
                    title: 'Description',
                    width: '220px'
                },
                {
                    type: 'dropdown',
                    title: 'Platforms',
                    width: '200px',
                    source: ['Mobile', 'Desktop', 'Web'],
                    multiple: true,
                    options: {
                        newOptions: true
                    }
                },
            ],
        },
        {
            data: [
                { id: 1, data: [ 'Jorge', 'jorge@data.com', '1975-10-11', 'Male' ] },
                { id: 2, data: [ 'Maria', 'maria@data.com', '1981-01-12', 'Female' ] },
                { id: 3, data: [ 'Paul', 'paul@data.com', '1985-09-21', 'Male' ] },
                { id: 4, data: [ 'Mario', 'mario@data.com', '1987-09-21', 'Male' ] },
                { id: 5, data: [ 'Lucy', 'lucy@data.com', '1981-02-15', 'Female' ] },
            ],
            minDimensions: [, 6],
            worksheetName: 'Users',
            worksheetId: 'users',
            columns: [{
                    type: 'text',
                    title: 'Name',
                    width: '200px'
                },
                {
                    type: 'email',
                    title: 'E-mail',
                    width: '300px'
                },
                {
                    type: 'calendar',
                    title: 'Birth',
                    width: '120px',
                    format: 'DD/MM/YYYY',
                },
                {
                    type: 'dropdown',
                    title: 'Gender',
                    width: '120px',
                    source: ['Male', 'Female']
                },
            ],
        },
        {
            data: [
                { id: 1, data: [ 'Adrian', 'adrian@soft.com', 'Manager' ] },
                { id: 2, data: [ 'Ben', 'ben@soft.com', 'Developer' ] },
                { id: 3, data: [ 'Robert', 'robert@soft.com', 'Developer' ] },
                { id: 4, data: [ 'Dan', 'dan@soft.com', 'Designer' ] },
                { id: 5, data: [ 'Mark', 'mark@soft.com', 'Designer' ] },
                { id: 6, data: [ 'Joseph', 'joseph@soft.com', 'Intern' ] },
            ],
            minDimensions: [, 7],
            worksheetName: 'Employees',
            worksheetId: 'employees',
            columns: [{
                    type: 'text',
                    title: 'Name',
                    width: '200px'
                },
                {
                    type: 'email',
                    title: 'E-mail',
                    width: '300px'
                },
                {
                    type: 'dropdown',
                    title: 'Role',
                    width: '120px',
                    source: [ 'Developer', 'Manager', 'Analyst', 'Designer', 'Intern' ]
                }
            ],
        },
    ]
}