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' ]
}
],
},
]
}