Video Summary - Appointment Management Web App Dashboard with Google Sheets| Admin Dashboard Web App

Summary of the video: Appointment Management Web App Dashboard using Google Sheets

The video demonstrates an appointment booking web app where users can submit an appointment form including:
- Name, phone, email
- Optional notes
- Date and time
After submitting, the appointment data is written into a Google Sheet (the presenter refreshes the sheet to confirm the entry).
The app includes a login system backed by Google Sheets, with configuration and role control:
- A login name/sheet is configured
- Email is stored in column B
- Passwords are stored in column C
- An access type column controls roles (e.g., admin, user, manager)
- Each login can be allowed or disallowed for access

Once logged in, the admin dashboard shows appointment statistics and a list of appointments:
- Total appointments
- Completed
- Pending
- Cancelled
The latest appointment appears at the top of the list.
The dashboard supports filtering by status (e.g., showing only Pending appointments).
Appointment status can be edited directly from the dashboard:
- Example workflow: Pending → Complete (totals update accordingly)
- Example workflow: Pending → Cancelled

The app includes a workflow to add appointments for other people/relatives:
- An “Add Appointment” button opens a form to enter name, phone, email, notes, date/time
- After adding, the new appointment is saved to the Google Sheet and appears on the dashboard

The Google Sheet entries support deletion via a delete icon:
- Deleting removes the appointment entry and updates the dashboard totals

The presenter/creator of the “B42” web app tutorial (speaking directly throughout the video).