HOTO Process Tracker

High Rise Building Complex - Real-time Progress Tracking

Dashboard

Key Handover

CBRE Snagging

Project/MEP

TEAM4 CRM Workflow

CBRE CRM (Calls) Calls Only

First Visit

Handover

Interiors

Move-in

Excel Processor

Integration

Analytics

Key Handovers

Completion 0%

CBRE Snagging

Completion 0%

Project/MEP

Completion 0%

TEAM4 CRM

Completion 0%

CBRE CRM (Calls)

Completion 0%

First Visits

Completion 0%

Handovers

Completion 0%

Interiors

Completion 0%

Move-ins

Completion 0%

Tower-wise Progress Analysis

Upcoming Events (Next 7 Days)

Upcoming First Visits

No upcoming first visits in the next 7 days

Upcoming Handovers

No upcoming handovers in the next 7 days

Key Handover - Project Team to HOTO Team

Select Floor:

CBRE Snagging Process

Select Floor:

CBRE Snagging Details

Flat Number *

Tower *

MEP Snagging

MEP Inspector Name

MEP Start Date

MEP End Date

MEP Completed

Civil Snagging

Civil Inspector Name

Civil Start Date

Civil End Date

Civil Completed

Electrical Snagging

Electrical Inspector Name

Electrical Start Date

Electrical End Date

Electrical Completed

Water & Slopes Snagging

Water & Slopes Inspector Name

Water & Slopes Start Date

Water & Slopes End Date

Water & Slopes Completed

AC Drain Snagging

AC Drain Inspector Name

AC Drain Start Date

AC Drain End Date

AC Drain Completed

Tiles Snagging

Tiles Inspector Name

Tiles Start Date

Tiles End Date

Tiles Completed

Remarks for Incomplete Areas

Follow-up Date

Project/MEP Process

Select Floor:

TEAM4 CRM - Workflow CRM

Note: This is the actual CRM in the workflow process (Key → Snagging → Project/MEP → TEAM4 CRM → First Visit → Handover → Interiors → Move-in)

Select Floor:

TEAM4 CRM Details

Flat Number *

Tower *

CRM Action Type *

Assigned To *

Date *

Registration Completed

NOC Given to CBRE

Remarks

CBRE CRM - Calls Only

Note: This is for call tracking only and is NOT part of the main workflow process.

Select Floor:

CBRE CRM Call Details

Flat Number *

Date & time will appear after selection

Tower *

Call Description *

Informed To *

Call Status *

Caller Name (Optional)

Caller Phone (Optional)

Follow-up Date

Call Remarks (Optional)

Customer First Visit

Select Floor:

First Visit Details

Flat Number *

Tower *

Owner Name *

Owner Phone *

Visit Date & Time *

HOTO Team Member *

Owner will inform the date

Handover Date Suggested

Going for Third Party Inspection

Third Party Inspection Details

Date Not Confirmed (Save First Visit Only)

Date Confirmed *

Report Received Date

Report Copy Type

Soft Copy

Hard Copy

Informed to Project Team

CBRE Checking Done

Customer Remarks

CRM NOC Received

HOTO Handover Process

Select Floor:

Handover Details

Flat Number *

Tower *

Customer Name *

Customer Email *

Second Owner (if any)

Second Owner Email

HOTO Team Member *

Handover Date & Time *

Items Handed Over

All Keys

User Manual

Welcome Gift

Customer Feedback

Final Inspection Completed

Inspection Remarks

Customer Move-in Process

Select Floor:

Move-in Details

Flat Number *

Tower *

Customer Name *

Contact Number *

Move-in Date *

Move-in Time *

Move clearance given by fire and safety team

Move-in Remarks

Excel Data Processor

Step 1: Upload Excel File

Drag & Drop Excel File Here

or click to browse

Step 2: Configure Import

Select Process to Import *

Import Action *

Step 3: Export Options

Google Sheets Integration Setup

Connection Status

Current Status:

Not Connected

Last Sync:

Never

Local Records:

0 records

Cloud Records:

Not connected

Step 1: Configure Google Sheet

IMPORTANT: Your Google Sheet MUST have these sheets:

key_handover (Sheet name exactly as shown)

snagging (Sheet name exactly as shown)

first_visit (Sheet name exactly as shown)

handover (Sheet name exactly as shown)

interiors (Sheet name exactly as shown)

movein (Sheet name exactly as shown)

project_mep (Sheet name exactly as shown)

team4_crm (TEAM4 CRM - Actual Workflow)

cbre_crm (CBRE CRM - Calls Only)

Create Template

Create a new Google Sheet with the required sheets or use our template:

Step 2: Deploy Google Apps Script

Follow these steps:

Open your Google Sheet
Click Extensions → Apps Script
Delete any existing code
Copy and paste the code from the box below
Click Save (Ctrl+S)
Click Deploy → New Deployment
Select Web App as type
Set "Execute as" to Me
Set "Who has access" to Anyone
Click Deploy
Copy the Web App URL provided

Google Apps Script Code:

// SIMPLIFIED Google Apps Script for HOTO Process Tracker
function doGet(e) {
  return handleRequest(e);
}

function doPost(e) {
  return handleRequest(e);
}

function handleRequest(e) {
  const action = e.parameter.action;
  
  // Create response
  let response;
  
  switch(action) {
    case 'ping':
      response = {
        status: 'online',
        timestamp: new Date().toISOString(),
        message: 'HOTO Process Tracker v3.0',
        version: '3.0'
      };
      break;
      
    case 'test':
      response = {
        status: 'success',
        message: 'Test successful! Your web app is working.',
        timestamp: new Date().toISOString()
      };
      break;
      
    case 'get_data':
      const process = e.parameter.process;
      response = {
        status: 'success',
        process: process,
        data: [],
        count: 0,
        message: 'Data retrieval is working'
      };
      break;
      
    case 'save_data':
      const saveProcess = e.parameter.process;
      response = {
        status: 'success',
        process: saveProcess,
        action: 'saved',
        message: 'Data saved successfully',
        timestamp: new Date().toISOString()
      };
      break;
      
    default:
      response = {
        status: 'error',
        message: 'Invalid action. Use "ping" to test connection.',
        valid_actions: ['ping', 'test', 'get_data', 'save_data']
      };
  }
  
  // Return JSON response with CORS headers
  return ContentService
    .createTextOutput(JSON.stringify(response))
    .setMimeType(ContentService.MimeType.JSON)
    .setHeader('Access-Control-Allow-Origin', '*')
    .setHeader('Access-Control-Allow-Methods', 'GET, POST, OPTIONS')
    .setHeader('Access-Control-Allow-Headers', 'Content-Type');
}

// Test function - run this in Apps Script editor first
function testSetup() {
  console.log('HOTO Process Tracker - Test Setup');
  console.log('Spreadsheet URL: ' + SpreadsheetApp.getActiveSpreadsheet().getUrl());
  return 'Setup test completed successfully';
}

Step 3: Connect to Web App

Web App URL *

Paste the URL from your deployed web app (ends with /exec)

Analytics Dashboard

Start Date

End Date

Tower Filter

Tower-wise Progress Analysis

Upcoming Events (Next 7 Days)

Upcoming First Visits

Upcoming Handovers

Key Handover - Project Team to HOTO Team

Key Handover Details

CBRE Snagging Process

CBRE Snagging Details

MEP Snagging

Civil Snagging

Electrical Snagging

Water & Slopes Snagging

AC Drain Snagging

Tiles Snagging

Project/MEP Process

Project/MEP Details

TEAM4 CRM - Workflow CRM

TEAM4 CRM Details

CBRE CRM - Calls Only

CBRE CRM Call Details

Customer First Visit

First Visit Details

Third Party Inspection Details

HOTO Handover Process

Handover Details

Interiors Work Process

Interiors Work Details

Main Vendor Details

Additional Vendor

Customer Move-in Process

Move-in Details

Recorded Deviations (From Interiors)

Excel Data Processor

Step 1: Upload Excel File

Drag & Drop Excel File Here

Validation Results

Correct Data Found (First 10 rows)

Data with Errors

Step 2: Configure Import

Import Summary

Step 3: Export Options

Google Sheets Integration Setup

Connection Status

Step 1: Configure Google Sheet

IMPORTANT: Your Google Sheet MUST have these sheets:

Create Template

Step 2: Deploy Google Apps Script

Step 3: Connect to Web App

Analytics Dashboard

Process Completion Rates

Tower-wise Distribution

Monthly Progress Trend

Status Overview

Complete Flat Details

Record Deviation