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

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [{
            minDimensions: [5, 5],
            worksheetId: 'applicants',
            worksheetName: 'Applicants',
            columns: [
                {
                    type: 'text',
                    title: 'Name',
                    width: '120px'
                },
                {
                    type: 'dropdown',
                    title: 'Stage',
                    width: '100px',
                    source: [{
                        name: 'Interviewing',
                        color: '#007BFF',
                        id: 1,
                    }, {
                        name: 'Hire',
                        color: '#28A745',
                        id: 2,
                    }, {
                        name: 'No hire',
                        color: '#FB4B4B',
                        id: 3,
                    }, {
                        name: 'Decision needed',
                        color: '#6C757D',
                        id: 4,
                    }]
                },
                {
                    type: 'dropdown',
                    title: 'Applying for',
                    width: '100px',
                    source: ['Sales Manager', 'Developer', 'Designer'],
                    options: {
                        newOptions: true
                    }
                },
                {
                    type: 'email',
                    title: 'Email address',
                    width: '150px'
                },
                {
                    type: 'text',
                    title: 'Phone',
                    width: '120px'
                },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Eric Reinger',
                        '',
                        'Developer',
                        'eric@gmail.com',
                        '555-6192',
                    ],
                },
                {
                    id: 2,
                    data: [
                        'Darryl Quigley',
                        '3',
                        'Developer',
                        'darryl@gmail.com',
                        '403-1527',
                    ],
                },
                {
                    id: 3,
                    data: [
                        'Lennie Wisoky',
                        '2',
                        'Sales Manager',
                        'lennie@gmail.com',
                        '810-4817',
                    ],
                },
                {
                    id: 4,
                    data: [
                        'Giles Boyer',
                        '1',
                        'Designer',
                        'giles@gmail.com',
                        '600-5853',
                    ],
                },
                {
                    id: 5,
                    data: [
                        'Caterina Koss',
                        '4',
                        'Developer',
                        'caterina@gmail.com',
                        '844-6233',
                    ],
                }
            ]
        },
        {
            minDimensions: [3, 5],
            worksheetName: 'Interviews',
            tabs: true,
            columns: [{
                    type: 'record',
                    title: 'Interviewer',
                    worksheetId: 'interviewers',
                    width: '120px'
                },
                {
                    type: 'record',
                    title: 'Applicant',
                    worksheetId: 'applicants',
                    width: '120px'
                },
                {
                    type: 'calendar',
                    title: 'Interview date',
                    width: '150px'
                },
                {
                    type: 'notes',
                    title: 'Interviewer notes',
                    width: '150px'
                },
                {
                    type: 'dropdown',
                    title: 'Interview type',
                    source: ['Phone Interview', 'Onsite Interview'],
                    width: '120px',
                },
            ],
            data: [
                [
                    '3',
                    '4',
                    '2021-06-28',
                    'The applicant demonstrates good knowledge in the area, but more interviews will still be needed',
                    'Phone Interview'
                ],
                [
                    '1',
                    '2',
                    '2021-06-25',
                    'The applicant showed little knowledge in the area of the vacancy',
                    'Onsite Interview'
                ],
                [
                    '2',
                    '5',
                    '2021-06-29',
                    '',
                    'Onsite Interview'
                ],
                [
                    '3',
                    '3',
                    '2021-06-10',
                    'The applicant showed a lot of nervousness during the interview, so it was rescheduled for a new date, so that his real ability can be assessed',
                    'Onsite Interview'
                ],
                [
                    '1',
                    '3',
                    '2021-06-20',
                    'The applicant has demonstrated extensive knowledge and experience in his area',
                    'Onsite Interview'
                ],
            ]
        },
        {
            minDimensions: [6, 3],
            worksheetName: 'Interviewers',
            worksheetId: 'interviewers',
            tabs: true,
            columns: [{
                    type: 'text',
                    title: 'Name',
                    width: '120px'
                },
                {
                    type: 'email',
                    title: 'Email',
                    width: '150px'
                },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Paul Lennon',
                        'paul@gmail.com',
                    ],
                },
                {
                    id: 2,
                    data: [
                        'John Peter',
                        'john@gmail.com',
                        
                    ],
                },
                {
                    id: 3,
                    data: [
                        'Joany Graham',
                        'joany@gmail.com',
                    ],
                }
            ]
        },
    ]
}