FEC Admin Panel

📋 Applications

💬 WhatsApp

⚙️ Settings

📋

Total Applications

🔵

Under Review

📞

Counseling

🏫

Shortlisted

✅

Confirmed

📄

Docs Pending

Student	College & Course	Cutoff	Budget	Date	Status	Fee Access	Actions
📭 Loading applications...

⚙️ WhatsApp API Setup (CallMeBot)

Enter your CallMeBot API key to enable WhatsApp notifications when students apply. Once set up, you'll get instant alerts on your phone.

📱 One-time setup:
1. Open WhatsApp → message +34 644 59 47 64
2. Send exactly: I allow callmebot to send me messages
3. You'll receive your API key (a number)
4. Enter it below and save ✅

💬 Send WhatsApp Message to Student

Send a custom message to any student directly from this panel.

📢 Broadcast to All Students

Send a message to all registered students at once. Use for announcements, deadline reminders, etc.

🔗 Google Sheets Connection

All student applications are saved to your Google Sheet in real time. Share the sheet link with your team for collaborative access.

📋 Your Google Sheet:
ID: 1-24YW4tlpO00DliiYgYYApq0H42Ec7qfsmE2tZ4H8PE

⚙️ Apps Script Setup (one time — 5 mins):
1. Open your Google Sheet → click Extensions → Apps Script
2. Delete all existing code → paste the script below
3. Click Deploy → New Deployment → Web App
4. Set "Who has access" to Anyone → Deploy
5. Copy the Web App URL → paste below and save

📋 Copy This Apps Script Code:

function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    var ss = SpreadsheetApp.openById('1-24YW4tlpO00DliiYgYYApq0H42Ec7qfsmE2tZ4H8PE');
    if (data.action === 'submit') {
      var sheet = ss.getSheetByName('Applications') || ss.insertSheet('Applications');
      if (sheet.getLastRow() === 0) {
        sheet.appendRow(['App ID','Name','Mobile','College 1','Course 1','College 2','Course 2','Cutoff','Percent','Board','Community','Budget','Hostel','Message','Status','Date','Notes','Docs Requested']);
        sheet.getRange(1,1,1,18).setFontWeight('bold').setBackground('#c0392b').setFontColor('white');
      }
      sheet.appendRow([data.id,data.name,data.mobile,data.college,data.course,data.college2||'',data.course2||'',data.cutoff||'',data.percent||'',data.board||'',data.community||'',data.budget||'',data.hostel||'',data.message||'','Under Review',data.date,'','']);
      return ContentService.createTextOutput(JSON.stringify({success:true})).setMimeType(ContentService.MimeType.JSON);
    }
    if (data.action === 'getAll') {
      var sheet = ss.getSheetByName('Applications');
      if (!sheet || sheet.getLastRow() <= 1) return ContentService.createTextOutput(JSON.stringify({data:[]})).setMimeType(ContentService.MimeType.JSON);
      var rows = sheet.getRange(2,1,sheet.getLastRow()-1,18).getValues();
      var result = rows.map(function(r){return {id:r[0],name:r[1],mobile:r[2],college:r[3],course:r[4],college2:r[5],course2:r[6],cutoff:r[7],percent:r[8],board:r[9],community:r[10],budget:r[11],hostel:r[12],message:r[13],status:r[14],date:r[15],notes:r[16],docsRequested:r[17]};});
      return ContentService.createTextOutput(JSON.stringify({data:result})).setMimeType(ContentService.MimeType.JSON);
    }
    if (data.action === 'updateStatus') {
      var sheet = ss.getSheetByName('Applications');
      var rows = sheet.getDataRange().getValues();
      for (var i=1;i<rows.length;i++){if(rows[i][0]===data.id){sheet.getRange(i+1,15).setValue(data.status);if(data.notes)sheet.getRange(i+1,17).setValue(data.notes);if(data.docsRequested)sheet.getRange(i+1,18).setValue(data.docsRequested);break;}}
      return ContentService.createTextOutput(JSON.stringify({success:true})).setMimeType(ContentService.MimeType.JSON);
    }
    if (data.action === 'getStatus') {
      var sheet = ss.getSheetByName('Applications');
      if(!sheet) return ContentService.createTextOutput(JSON.stringify({data:[]})).setMimeType(ContentService.MimeType.JSON);
      var rows = sheet.getDataRange().getValues();
      var result = rows.filter(function(r,i){return i>0&&r[2]==data.mobile;}).map(function(r){return {id:r[0],college:r[3],course:r[4],status:r[14],date:r[15],notes:r[16],docsRequested:r[17]};});
      return ContentService.createTextOutput(JSON.stringify({data:result})).setMimeType(ContentService.MimeType.JSON);
    }
  } catch(err) {
    return ContentService.createTextOutput(JSON.stringify({error:err.toString()})).setMimeType(ContentService.MimeType.JSON);
  }
}
function doGet(e) {
  try {
    var action = e.parameter.action;
    var ss = SpreadsheetApp.openById('1-24YW4tlpO00DliiYgYYApq0H42Ec7qfsmE2tZ4H8PE');
    var p = e.parameter;

    if (action === 'submit') {
      var sheet = ss.getSheetByName('Applications') || ss.insertSheet('Applications');
      if (sheet.getLastRow() === 0) {
        sheet.appendRow(['App ID','Name','Mobile','College 1','Course 1','College 2','Course 2','Cutoff','Percent','Board','Community','Budget','Hostel','Message','Status','Date','Notes','Docs']);
        sheet.getRange(1,1,1,18).setFontWeight('bold').setBackground('#080F3C').setFontColor('white');
      }
      sheet.appendRow([p.id||'',p.name||'',p.mobile||'',p.college||'',p.course||'',p.college2||'',p.course2||'',p.cutoff||'',p.percent||'',p.board||'',p.community||'',p.budget||'',p.hostel||'',p.message||'','Under Review',p.date||new Date().toLocaleDateString(),'','']);
      return ContentService.createTextOutput(JSON.stringify({success:true})).setMimeType(ContentService.MimeType.JSON);
    }
    if (action === 'getAll') {
      var sheet = ss.getSheetByName('Applications');
      if (!sheet || sheet.getLastRow() <= 1) return ContentService.createTextOutput(JSON.stringify({data:[]})).setMimeType(ContentService.MimeType.JSON);
      var rows = sheet.getRange(2,1,sheet.getLastRow()-1,18).getValues();
      var result = rows.map(function(r){return {id:r[0],name:r[1],mobile:r[2],college:r[3],course:r[4],college2:r[5],course2:r[6],cutoff:r[7],percent:r[8],board:r[9],community:r[10],budget:r[11],hostel:r[12],message:r[13],status:r[14],date:r[15],notes:r[16],docsRequested:r[17]};});
      return ContentService.createTextOutput(JSON.stringify({data:result})).setMimeType(ContentService.MimeType.JSON);
    }
    if (action === 'getStatus') {
      var sheet = ss.getSheetByName('Applications');
      if(!sheet) return ContentService.createTextOutput(JSON.stringify({data:[]})).setMimeType(ContentService.MimeType.JSON);
      var rows = sheet.getDataRange().getValues();
      var result = rows.filter(function(r,i){return i>0&&String(r[2])==String(p.mobile);}).map(function(r){return {id:r[0],college:r[3],course:r[4],status:r[14],date:r[15],notes:r[16],docsRequested:r[17]};});
      return ContentService.createTextOutput(JSON.stringify({data:result})).setMimeType(ContentService.MimeType.JSON);
    }
    if (action === 'updateStatus') {
      var sheet = ss.getSheetByName('Applications');
      var rows = sheet.getDataRange().getValues();
      for(var i=1;i<rows.length;i++){
        if(String(rows[i][0])===String(p.id)){
          sheet.getRange(i+1,15).setValue(p.status||rows[i][14]);
          sheet.getRange(i+1,17).setValue(p.notes||rows[i][16]);
          if(p.docsRequested) sheet.getRange(i+1,18).setValue(p.docsRequested);
          break;
        }
      }
      return ContentService.createTextOutput(JSON.stringify({success:true})).setMimeType(ContentService.MimeType.JSON);
    }
    return ContentService.createTextOutput(JSON.stringify({ok:true})).setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService.createTextOutput(JSON.stringify({error:err.toString()})).setMimeType(ContentService.MimeType.JSON);
  }
}

📧 Import Applications from Email

If Google Sheets is not set up, you can manually import applications received via email. Paste the application details below to add them to the panel.

🔐 Change Admin Password

Update your admin panel login credentials.