image: img/spreadsheet-templates-dentist.jpg folder: small-business category: template

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [
        {
            worksheetName: 'Appointment',
            columns: [
                { type: 'record', title: 'Dentist', worksheetId: 'dentists', width: '200px' },
                { type: 'record', title: 'Patient', worksheetId: 'patients', width: '200px' },
                { type: 'dropdown', title: 'Room', source: ['1', '2', '3', '4', '5'] },
                { type: 'calendar', title: 'Time', width: '150px', options: { time: true, format: 'YYYY-MM-DD hh:m' } },
                { type: 'notes', title:'Reason', width: '150px' },
            ],
            data: [
                [
                    '1',
                    '2',
                    '2',
                    '2021-06-16 11:00',
                    'Remove wisdom tooth'
                ],
                [
                    '1',
                    '1',
                    '2',
                    '2021-06-16 12:30',
                    'Feeling pain in the lower left canine'
                ],
                [
                    '2',
                    '4',
                    '1',
                    '2021-06-16 11:00',
                    'Putting on orthodontic braces'
                ],
                [
                    '4',
                    '5',
                    '3',
                    '2021-06-16 12:00',
                    'Maintenance of the orthodontic braces'
                ],
                [
                    '3',
                    '7',
                    '3',
                    '2021-06-15 15:40',
                    'Dental cleaning'
                ],
                [
                    '4',
                    '5',
                    '5',
                    '2021-07-16 12:00',
                    'Maintenance of the orthodontic braces'
                ],
                [
                    '5',
                    '8',
                    '4',
                    '2021-06-15 09:20',
                    'Dental cleaning'
                ],
            ],
            worksheetId: 'schedule',
            plugins:['schedule.js']
        },
        {
            worksheetName: 'Dentist',
            worksheetId: 'dentists',
            columns: [
                { type: 'text', title:'Name', width: '200px' },
                { type: 'dropdown', title: 'Specialty', width: '200px', source: ['Pediatric Dentistry', 'Endodontics', 'Periodontics'] },
                { type: 'text', title:'Phone', width: '200px' },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Milton Kuhlman MD',
                        'Endodontics',
                        '983-7183',
                    ]
                },
                {
                    id: 2,
                    data: [
                        'Brycen Cremin',
                        'Pediatric Dentistry',
                        '512-4075',
                    ]
                },
                {
                    id: 3,
                    data: [
                        'Catalina Gerhold',
                        'Pediatric Dentistry',
                        '931-3503',
                    ]
                },
                {
                    id: 4,
                    data: [
                        'Elenora Gottlieb',
                        'Endodontics',
                        '541-8162',
                    ]
                },
                {
                    id: 5,
                    data: [
                        'Willis Graham',
                        'Periodontics',
                        '815-603',
                    ]
                },
            ]
        },
        {
            worksheetName: 'Patient',
            worksheetId: 'patients',
            columns: [
                { type: 'text', title:'Name', width: '200px' },
                { type: 'text', title:'Phone' },
                { type: 'text', title:'Adress', width: '300px' },
            ],
            data: [
                {
                    id: 1,
                    data: [
                        'Tiffany Durgan',
                        '882-7274',
                        '9929 Veum Track',
                    ]
                },
                {
                    id: 2,
                    data: [
                        'Lance Prosacco',
                        '717-0080',
                        '805 Morissette Gardens',
                    ]
                },
                {
                    id: 3,
                    data: [
                        'Savion Jacobs',
                        '260-1197',
                        '82589 Bashirian Alley',
                    ]
                },
                {
                    id: 4,
                    data: [
                        'Kiel Mayer',
                        '665-4077',
                        '29941 Baumbach Points',
                    ]
                },
                {
                    id: 5,
                    data: [
                        'Alexandrine McDermott',
                        '719-9230',
                        '475 Elwin Islands',
                    ]
                },
                {
                    id: 6,
                    data: [
                        'Roy Funk',
                        '556-6028',
                        '901 Bartoletti Knolls',
                    ]
                },
                {
                    id: 7,
                    data: [
                        'Carmel Berge',
                        '968-6211',
                        '5595 Boyd Drives',
                    ]
                },
                {
                    id: 8,
                    data: [
                        'Jovani Friesen DDS',
                        '270-9397',
                        '489 Gottlieb Junction',
                    ]
                },
            ]
        }
    ]
}