image: img/spreadsheet-templates-freelancer-managment.jpg folder: human-resources-and-legal category: template

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [{
            worksheetName: 'Assignment',
            columns: [{
                    type: 'record',
                    title: 'Project',
                    worksheetId: 'projects',
                    width: '200px',
                },
                {
                    type: 'record',
                    title: 'Freelancer',
                    worksheetId: 'freelancers',
                    width: '200px',
                    source: []
                },
                {
                    type: 'number',
                    title: 'Price',
                    mask: '$ #.##,00',
                    width: '100px',
                    decimal: ',',
                    disabledMaskOnEdition: true
                },
                {
                    type: 'checkbox',
                    title: 'Finished',
                },
            ],
            data: [
                [
                    '1',
                    '1',
                    '3000',
                    'true'
                ],
                [
                    '1',
                    '3',
                    '2500',
                    'true'
                ],
                [
                    '1',
                    '6',
                    '3500',
                    'true'
                ],
                [
                    '2',
                    '2',
                    '2000',
                    'false'
                ],
                [
                    '2',
                    '5',
                    '2500',
                    'false'
                ],
                [
                    '2',
                    '4',
                    '3000',
                    'false'
                ]
            ]
        },
        {
            worksheetName: 'Project',
            worksheetId: 'projects',
            columns: [{
                    type: 'text',
                    title: 'Name',
                    width: '200px'
                },
                {
                    type: 'calendar',
                    title: 'Initial date',
                    width: '150px'
                },
                {
                    type: 'calendar',
                    title: 'Expected end date',
                    width: '150px'
                },
                {
                    type: 'calendar',
                    title: 'End date',
                    width: '150px'
                },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Library management',
                        '2016-05-01',
                        '2016-06-31',
                        '2016-06-11',
                    ]
                },
                {
                    id: 2,
                    data: [
                        'Social network',
                        '2016-05-18',
                        '2016-09-20',
                        '',
                    ]
                },
                {
                    id: 3,
                    data: [
                        'E-commerce',
                        '2016-07-13',
                        '2016-09-10',
                        '',
                    ]
                }
            ]
        },
        {
            worksheetName: 'Freelancer',
            worksheetId: 'freelancers',
            columns: [{
                    type: 'text',
                    title: 'Name',
                    width: '200px'
                },
                {
                    type: 'dropdown',
                    title: 'Specialty',
                    width: '100px',
                    source: ['Backend', 'Frontend', 'Full Stack'],
                    options: {
                        newOptions: true
                    }
                },
                {
                    type: 'rating',
                    title: 'Overall performance',
                    width: '150px'
                },
                {
                    type: 'email',
                    title: 'E-mail',
                    width: '200px'
                },
                {
                    type: 'notes',
                    title: 'Bank information',
                    width: '200px'
                },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Shanny Cole',
                        'Backend',
                        '5',
                        'Shanny80@hotmail.com',
                        'XXXXXXXXXX',
                    ]
                },
                {
                    id: 2,
                    data: [
                        'Jo Wehner',
                        'Frontend',
                        '1',
                        'Jo46@yahoo.com',
                        'XXXXXXXXXX',
                    ]
                },
                {
                    id: 3,
                    data: [
                        'Kiara Langworth',
                        'Frontend',
                        '4',
                        'Kiara.Langworth12@hotmail.com',
                        'XXXXXXXXXX',
                    ]
                },
                {
                    id: 4,
                    data: [
                        'Rollin Rohan',
                        'Full Stack',
                        '2',
                        'Rollin19@hotmail.com',
                        'XXXXXXXXXX',
                    ]
                },
                {
                    id: 5,
                    data: [
                        'Trisha Jakubowski',
                        'Backend',
                        '3',
                        'Trisha_Jakubowski31@hotmail.com',
                        'XXXXXXXXXX',
                    ]
                },
                {
                    id: 6,
                    data: [
                        'Emil Padberg',
                        'Full Stack',
                        '5',
                        'Emil_Padberg96@gmail.com',
                        'XXXXXXXXXX',
                    ]
                }
            ]
        }
    ]
}