image: img/spreadsheet-templates-house-huning.jpg folder: personal category: template

const config = {
    tabs: true,
    toolbar: true,
    worksheets: [{
        worksheetName: 'House',
        worksheetId: 'houses',
        columns: [{
                type: 'text',
                title: 'Adress',
                width: '200px'
            },
            {
                type: 'number',
                title: 'Size',
                width: '80px'
            },
            {
                type: 'number',
                title: 'floors',
                width: '80px'
            },
            {
                type: 'number',
                title: 'Bedrooms',
                width: '100px'
            },
            {
                type: 'number',
                title: 'Bathrooms',
                width: '100px'
            },
            {
                type: 'number',
                title: 'Price',
                mask: '$ #.##,00',
                width: '100px',
                decimal: ',',
                disabledMaskOnEdition: true
            },
            {
                type: 'text',
                title: 'Phone',
            },
        ],
        data: [
            {
                id: 1,
                data: [
                    '604 Christy Knolls',
                    '100',
                    '1',
                    '2',
                    '1',
                    '400',
                    '540-5554'
                ]
            },
            {
                id: 2,
                data: [
                    '213 Caleigh Port',
                    '160',
                    '2',
                    '2',
                    '2',
                    '700',
                    '693-9184'
                ]
            },
            {
                id: 3,
                data: [
                    '715 Kuhlman Lodge',
                    '140',
                    '2',
                    '1',
                    '1',
                    '490',
                    '566-1941'
                ]
            },
            {
                id: 4,
                data: [
                    '21867 Ole Harbors',
                    '80',
                    '1',
                    '1',
                    '1',
                    '340',
                    '678-2186'
                ]
            },
            {
                id: 5,
                data: [
                    '9478 Brendan Pass',
                    '200',
                    '1',
                    '3',
                    '2',
                    '660',
                    '363-7518'
                ]
            },
            {
                id: 6,
                data: [
                    '081 Gracie Bypass',
                    '250',
                    '2',
                    '3',
                    '3',
                    '1000',
                    '437-9164'
                ]
            },
        ],
    },
    {
        worksheetName: 'Visit',
        columns: [{
                type: 'record',
                title: 'House',
                worksheetId: 'houses',
                width: '200px',
                source: []
            },
            {
                type: 'calendar',
                title: 'Time',
                width: '150px',
                options: {
                    time: true,
                    format: 'YYYY-MM-DD hh:m'
                }
            },
            {
                type: 'dropdown',
                title: 'Visitor',
                width: '120px',
                source: ['me', 'wife', 'husband']
            },
            {
                type: 'checkbox',
                title: 'Visited',
                width: '100px'
            },
            {
                type: 'notes',
                title: 'Resume',
                width: '150px'
            },
            {
                type: 'rating',
                title: 'Rating',
                width: '100px'
            },
        ],
        data: [
            [
                '1',
                '2021-07-01 10:20',
                'me',
                'true',
                'A cozy house, but it seems to need some renovations',
                '2'
            ],
            [
                '3',
                '2021-07-01 15:50',
                'wife',
                'true',
                'The person responsible for showing the house did not show up',
                ''
            ],
            [
                '2',
                '2021-07-12 09:00',
                'me',
                'true',
                'A newly built house located in a very safe region',
                '5'
            ],
            [
                '3',
                '2021-07-16 09:20',
                'me',
                'true',
                'The person responsible for showing the house did not show up',
                ''
            ],
            [
                '5',
                '2021-07-20 17:00',
                'wife',
                'true',
                'The house itself is amazing, but the neighborhood has a lot of car noise',
                '3'
            ],
            [
                '4',
                '2021-07-24 17:00',
                'wife',
                'false',
                '',
                ''
            ],
            [
                '6',
                '2021-07-25 08:40',
                'me',
                'false',
                '',
                ''
            ],
        ],
    }]
};