Untitled

function assignPoints() {
    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Attendance Tracker');
    const range = sheet.getRange('C2:D' + sheet.getLastRow());
    const data = range.getValues();
    
    data.forEach((row, index) => {
        const eventType = row[0];
        let points = 0;
        switch(eventType) {
            case 'Fundraiser': points = 2; break;
            case 'GBM': points = 1; break;
            case 'Social': points = 1; break;
            case 'Clinic Donation': points = 1; break;
            case 'Volunteer Event': points = 1; break;
            case 'Attend Clinic': points = -3; break;
        }
        data[index][1] = points; // Assign points to the second column in the range
    });
    range.setValues(data); // Update the sheet with new points
}