BNI Professional Chapter - Meeting Portal (ລະບົບເຊັກອິນ)

Weekly Meeting Check-in / ເຊັກອິນປະຈຳສັບປະດາ

Welcome to Today's BNI Meeting

ຍິນດີຕ້ອນຮັບສູ່ການປະຊຸມ BNI ມື້ນີ້

Venue / ສະຖານທີ່: Kafepa' ANU

Member Check-in

ເຊັກອິນສະມາຊິກ / ຜູ້ຕາງໜ້າ

Attendance check-in for registered members or substitute attendees.

Visitor Check-in

ເຊັກອິນແຂກ / ຜູ້ຢ່ຽມຊົມ

Check in from active Visitor List or register new visitor details.

Active Special Events / ງານອົບຮົມ ແລະ ກິດຈະກຳພິເສດ

0 Active Events

Member Attendance Check-in / ເຊັກອິນສະມາຊິກ

Active Event Date: 2026-08-21 07:00 - 10:00

1. Select Target Event * / ເລືອກງານ/ການປະຊຸມ *

2. Select Member (Company Short - Nick) * / ເລືອກສະມາຊິກ *

Sort:

Type to search. List sorted by company (A–Z) by default.

3. Attendance Type * / ປະເພດການເຂົ້າຮ່ວມ *

Member Attending (ສະມາຊິກເຂົ້າຮ່ວມເອງ) Substitute Person (ຜູ້ຕາງໜ້າ)

Active Event Date: Friday, Aug 21, 2026 Weekly Chapter Meeting

Select Target Event * / ເລືອກງານ/ການປະຊຸມ *

Visitor List Check-in / ເຊັກອິນຈາກລາຍຊື່ແຂກ

Select your name to confirm check-in for the selected meeting.

New Visitor Registration Form / ແບບຟອມລົງທະບຽນແຂກໃໝ່

Welcome! Please fill in your details to join our networking meeting.

First Name * / ຊື່ *

Family / Last Name * / ນາມສະກຸນ *

Nick Name / ຊື່ຫຼິ້ນ

Business / Company Short Name * / ຊື່ຍໍ້ບໍລິສັດ *

Business Category / Industry * / ຂະແໜງທຸລະກິດ *

WhatsApp Phone Number * / ເບີ WhatsApp *

Email Address (Optional) / ອີເມວ (ບໍ່ບັງຄັບ)

Who Invited You to BNI? * / ໃຜເປັນຜູ້ເຊື້ອເຊີນທ່ານ? *

Role: Admin

Portal Management Hub / ສູນຄຸ້ມຄອງລະບົບ BNI

Manage reports, attendance logs, meeting dates, special events, member rosters, visitor database, and Google Sync.

Time Period Filter

Absence Threshold (Custom Number)

From Date (Custom)

To Date (Custom)

Member Full Name & Nickname	Company (Short & Registered)	Attended	Absences	Official Actions (WhatsApp & PDF Notice)

Substitute Person Tracker / ລາຍງານການເຂົ້າຮ່ວມຂອງຜູ້ຕາງໜ້າ

Time Period Filter

From Date

To Date

Substitute Threshold

Policy: >6 substitutes in 3 months → review membership

Event Date	Member Full Name & Company	Substitute Full Name & Company (ຜູ້ຕາງໜ້າ)	Position & Phone	Sub Count	Actions (WhatsApp & PDF Notice)

Member Birthday Reminder (ST Report)

For Secretary-Treasurer to prepare cake / recognition for members this week or this month.

View:

Birthday (MM-DD)	Member Full Name & Nickname	Company	LT Team	WhatsApp	When

Visitor Check-in History / ປະວັດການເຂົ້າຮ່ວມຂອງແຂກ

Event Date	Visitor Full Name & Nickname	Business / Category	Invited By	Attendance Count

Showing page 1 of 1

Attendance Log & Check-in Manager / ຈັດການບັນທຶກການເຂົ້າຮ່ວມ

Add manual check-ins, edit records, or remove accidental entries (Paginated 20 lines/page).

Date & Time	Type	Subject / Member	Check-in Details	Actions

Showing page 1 of 1

0 Members

Sort:

Photo	Full Name (First + Last)	Nickname	Company Short Name	Company Full Name (Registered)	LT Team	Birthday	WhatsApp	Action

Full Name	Nickname	Company	Target Event Date	Category	Invited By	Phone	Action

Active Chapter Friday Meeting Settings

Friday Meeting Title (type here, then Save)

This name appears in the check-in event dropdown on Member & Visitor pages.

Active Date for Check-in

Start Time

End Time

Meeting Venue & GPS Check-in Radius

Venue / Location Name

Google Maps Link

Venue Latitude

Venue Longitude

Allowed Check-in Radius (Meters)

How many meters from venue GPS are allowed to check-in.

Enable Strict GPS Geofencing

Special Events Management

Configure special events, display dates, exact event check-in date/schedule, public banners, and gallery download links.

Event Title	Display Window (From - To)	Exact Event Check-in Schedule	Location	Public Visibility	Gallery Link	Action

Leadership Teams (LT) Roles Management

LT Team Name	Assigned Members	Action

Branding Logos & App Icons (URL or File Upload for ALL Logos)

1. Header Main Logo (URL or Upload File)

2. Browser Favicon / Tab Logo (URL or Upload File)

3. Web App / PWA Logo

4. iOS App Icon

5. Android App Icon

WhatsApp Policy Warning Messages (Bilingual Lao & English Combined)

Absence Policy Warning Script — WhatsApp (placeholders: {NAME} {COMPANY} {ABSENCES} {SUBS})

Substitute Policy Warning Script — WhatsApp (placeholders: {NAME} {COMPANY} {ABSENCES} {SUBS})

Birthday WhatsApp Message (placeholders: {NAME} {COMPANY} {BIRTHDAY} {NICK})

PDF Official Notice Content (editable — saved to Google Sheet)

Used inside the PDF warning notice body. Placeholders: {NAME} {COMPANY} {ABSENCES} {SUBS}

PDF Absence Notice Body

PDF Substitute Notice Body

Platform Text & Page Title Customization (Full Page Coverage)

Portal Chapter Main Title

Portal Subtitle (Lao Subtitle)

Home Page Welcome Title

Home Page Event Badge Text

Member Check-in Screen Header

Visitor Check-in Screen Header

Public Directory Header Title

Reports Hub Main Header

Security Protection

Master Admin Security PIN

Database Reset

Clear stored records and restore initial database state. Requires master password.

Google Sync & Cloud Database Setup Configure Web App URL + Sheet link + copy Apps Script below. Required for multi-device sync.

1 Google Apps Script Web App Endpoint URL

After you deploy Apps Script as a Web app, paste the URL that ends with /exec

Web App URL

Restore Backup File

Photos: After updating Apps Script, Push uploads member photos to Google Drive folder BNI_Portal_Photos and saves the image link in the Sheet. Other devices get photos after Pull.
Backup: Weekly auto-backup runs when you open the portal (every 7 days). Use Manual Backup for a full JSON file including photos on this device.

2 Google Sheet Database Link

Paste the full link of your spreadsheet (File → Share → Copy link). This is your cloud database.

Spreadsheet URL

Open Database Sheet

Multi-device

Put the same Web App URL + Sheet link on every phone/laptop. Edit on device A → Push. Open device B → auto-pull or Pull.

Auto-pull from Google Sheets when page opens

Local DB: checking...

3 Full Google Apps Script (Code.gs)

How to install: Open your Spreadsheet → Extensions → Apps Script → delete old code → paste this script → Save → Deploy → New deployment → Web app → Execute as Me, Who has access Anyone → Copy the /exec URL into box #1 above.

Script (select all or use Copy button)

/**
 * BNI Portal - Google Apps Script (Code.gs)
 * Deploy as Web App: Execute as ME, Who has access: ANYONE
 * Sheets: MemberList, VisitorList, SpecialEvents, AttendanceLogs, PlatformSettings, LtTeams, Backups
 *
 * Photos: http(s) URLs stored as-is. Base64 data: URLs uploaded to Drive folder
 * "BNI_Portal_Photos" and replaced with a public view link (fits Sheets cell limit).
 */
function doPost(e) {
  try {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var payload = JSON.parse(e.postData.contents);
    var type = payload.type || 'ATTENDANCE_LOG';

    if (type === 'PING') {
      return jsonOut({result: "success", message: "pong", time: new Date().toISOString()});
    }

    var sheetName = "AttendanceLogs";
    if (type === 'SAVE_MEMBERS') sheetName = "MemberList";
    else if (type === 'SAVE_VISITORS') sheetName = "VisitorList";
    else if (type === 'SPECIAL_EVENTS_ALL' || type === 'SPECIAL_EVENTS') sheetName = "SpecialEvents";
    else if (type === 'LOGS_ALL' || type === 'ATTENDANCE_LOG') sheetName = "AttendanceLogs";
    else if (type === 'SAVE_SETTINGS') sheetName = "PlatformSettings";
    else if (type === 'SAVE_LT_TEAMS') sheetName = "LtTeams";
    else if (type === 'SAVE_BACKUP') sheetName = "Backups";

    var sheet = getOrCreateSheet_(ss, sheetName);

    if (type === 'SAVE_MEMBERS' && Array.isArray(payload.data)) {
      sheet.clearContents();
      sheet.appendRow(["Member ID", "First Name", "Last Name", "Nickname", "Short Company", "Registered Company", "LT Team", "Phone", "Email", "Birthday", "Photo URL", "Company Logo"]);
      payload.data.forEach(function(m) {
        var photo = storeImage_(m.photo || m.photoUrl || '', m.id || 'member', 'photo');
        var logo = storeImage_(m.companyLogo || '', m.id || 'member', 'logo');
        sheet.appendRow([
          m.id || '', m.firstName || '', m.lastName || '', m.nickName || '',
          m.business || '', m.businessLong || '',
          m.ltTeam || '', stripPlus_(m.phone), m.email || '', m.birthday || '',
          photo, logo
        ]);
      });
    } else if (type === 'SAVE_VISITORS' && Array.isArray(payload.data)) {
      sheet.clearContents();
      sheet.appendRow(["Visitor ID", "First Name", "Last Name", "Nickname", "Company", "Target Event Date", "Category", "Phone", "Email", "Invited By", "Photo URL"]);
      payload.data.forEach(function(v) {
        var photo = storeImage_(v.photo || v.photoUrl || '', v.id || 'visitor', 'photo');
        sheet.appendRow([
          v.id || '', v.firstName || '', v.lastName || '', v.nickName || '',
          v.business || '', v.targetEventDate || '', v.category || '',
          stripPlus_(v.phone), v.email || '', v.invitedBy || '',
          photo
        ]);
      });
    } else if ((type === 'SPECIAL_EVENTS_ALL' || type === 'SPECIAL_EVENTS') && Array.isArray(payload.data)) {
      sheet.clearContents();
      sheet.appendRow(["Event ID", "Title", "Description", "From Date", "To Date", "Event Start Date", "Event End Date", "Start Time", "End Time", "Location", "Reg URL", "Gallery URL", "Show Public", "Photo URL"]);
      payload.data.forEach(function(se) {
        sheet.appendRow([
          se.id || '', se.title || '', se.description || '', se.fromDate || '', se.toDate || '',
          se.eventStartDate || '', se.eventEndDate || '', se.startTime || '', se.endTime || '',
          se.location || '', se.regUrl || '', se.photoDownloadUrl || '', se.showPublic !== false ? 'Yes' : 'No',
          se.photo || ''
        ]);
      });
    } else if (type === 'LOGS_ALL' && Array.isArray(payload.data)) {
      sheet.clearContents();
      sheet.appendRow(["Log ID", "Subject ID", "Type", "Date", "Timestamp", "Name", "Company", "Company Long", "Details JSON"]);
      payload.data.forEach(function(l) {
        var d = l.details || {};
        sheet.appendRow([
          l.id || '', l.subjectId || '', l.type || '', l.date || '', l.timestamp || '',
          d.name || '', d.company || '', d.companyLong || '', JSON.stringify(d)
        ]);
      });
    } else if (type === 'ATTENDANCE_LOG') {
      var log = payload.data || payload;
      var d = log.details || {};
      sheet.appendRow([
        log.id || '', log.subjectId || '', log.type || '', log.date || '', log.timestamp || '',
        d.name || '', d.company || '', d.companyLong || '', JSON.stringify(d)
      ]);
    } else if (type === 'SAVE_SETTINGS' && payload.data) {
      sheet.clearContents();
      sheet.appendRow(["Key", "Value"]);
      var data = payload.data;
      Object.keys(data).forEach(function(k) {
        var val = data[k];
        if (val === null || val === undefined) val = '';
        if (typeof val === 'object') val = JSON.stringify(val);
        // Branding logos may be base64 — convert to Drive URL
        if ((k.indexOf('Logo') >= 0 || k.indexOf('Icon') >= 0 || k.indexOf('favicon') >= 0 || k.indexOf('Url') >= 0) && String(val).indexOf('data:image') === 0) {
          val = storeImage_(String(val), 'branding', k);
        }
        // Sheets cell max ~50k
        val = String(val);
        if (val.length > 49000) val = val.substring(0, 49000);
        sheet.appendRow([k, val]);
      });
    } else if (type === 'SAVE_LT_TEAMS' && Array.isArray(payload.data)) {
      sheet.clearContents();
      sheet.appendRow(["LT Team Name", "Sort Order"]);
      payload.data.forEach(function(name, i) {
        sheet.appendRow([name || '', i + 1]);
      });
    } else if (type === 'SAVE_BACKUP' && payload.data) {
      // Append a backup snapshot row (timestamp + summary + JSON if small enough)
      if (sheet.getLastRow() === 0) {
        sheet.appendRow(["Backup ID", "Created At", "Members", "Visitors", "Logs", "Events", "Summary JSON"]);
      }
      var b = payload.data;
      var summary = JSON.stringify({
        members: b.memberCount || 0,
        visitors: b.visitorCount || 0,
        logs: b.logCount || 0,
        events: b.eventCount || 0,
        note: b.note || ''
      });
      sheet.appendRow([
        b.id || ('BK_' + new Date().getTime()),
        b.createdAt || new Date().toISOString(),
        b.memberCount || 0,
        b.visitorCount || 0,
        b.logCount || 0,
        b.eventCount || 0,
        summary
      ]);
    }

    return jsonOut({result: "success", type: type});
  } catch (error) {
    return jsonOut({result: "error", message: error.toString()});
  }
}

function doGet(e) {
  try {
    var action = (e && e.parameter && e.parameter.action) ? e.parameter.action : 'pull';
    var ss = SpreadsheetApp.getActiveSpreadsheet();

    if (action === 'ping') {
      return jsonOut({result: "success", message: "pong"});
    }

    var members = readSheetAsObjects_(ss, "MemberList", function(h, row) {
      return {
        id: cell_(row, h, "Member ID") || cell_(row, h, "ID"),
        firstName: cell_(row, h, "First Name"),
        lastName: cell_(row, h, "Last Name"),
        nickName: cell_(row, h, "Nickname") || cell_(row, h, "Nick Name"),
        business: cell_(row, h, "Short Company") || cell_(row, h, "Company"),
        businessLong: cell_(row, h, "Registered Company") || cell_(row, h, "Company Long Name") || cell_(row, h, "Short Company"),
        ltTeam: cell_(row, h, "LT Team") || "Member",
        phone: cell_(row, h, "Phone") || cell_(row, h, "WhatsApp"),
        email: cell_(row, h, "Email"),
        birthday: cell_(row, h, "Birthday") || cell_(row, h, "Date of Birth") || "",
        photo: cell_(row, h, "Photo URL") || cell_(row, h, "Photo") || "",
        companyLogo: cell_(row, h, "Company Logo") || ""
      };
    });

    var visitors = readSheetAsObjects_(ss, "VisitorList", function(h, row) {
      return {
        id: cell_(row, h, "Visitor ID") || cell_(row, h, "ID"),
        firstName: cell_(row, h, "First Name"),
        lastName: cell_(row, h, "Last Name"),
        nickName: cell_(row, h, "Nickname"),
        business: cell_(row, h, "Company"),
        targetEventDate: cell_(row, h, "Target Event Date"),
        category: cell_(row, h, "Category"),
        phone: cell_(row, h, "Phone"),
        email: cell_(row, h, "Email"),
        invitedBy: cell_(row, h, "Invited By"),
        photo: cell_(row, h, "Photo URL") || cell_(row, h, "Photo") || ""
      };
    });

    var events = readSheetAsObjects_(ss, "SpecialEvents", function(h, row) {
      return {
        id: cell_(row, h, "Event ID") || cell_(row, h, "ID"),
        title: cell_(row, h, "Title"),
        description: cell_(row, h, "Description"),
        fromDate: cell_(row, h, "From Date"),
        toDate: cell_(row, h, "To Date"),
        eventStartDate: cell_(row, h, "Event Start Date") || cell_(row, h, "From Date"),
        eventEndDate: cell_(row, h, "Event End Date") || cell_(row, h, "To Date"),
        startTime: cell_(row, h, "Start Time") || "07:00",
        endTime: cell_(row, h, "End Time") || "10:00",
        location: cell_(row, h, "Location"),
        regUrl: cell_(row, h, "Reg URL"),
        photoDownloadUrl: cell_(row, h, "Gallery URL"),
        showPublic: String(cell_(row, h, "Show Public") || "Yes").toLowerCase() !== "no",
        photo: cell_(row, h, "Photo URL") || ""
      };
    });

    var logs = readSheetAsObjects_(ss, "AttendanceLogs", function(h, row) {
      var detailsRaw = cell_(row, h, "Details JSON") || "{}";
      var details = {};
      try { details = JSON.parse(detailsRaw); } catch (err) { details = {}; }
      if (!details.name) details.name = cell_(row, h, "Name") || "";
      if (!details.company) details.company = cell_(row, h, "Company") || "";
      if (!details.companyLong) details.companyLong = cell_(row, h, "Company Long") || details.company;
      return {
        id: cell_(row, h, "Log ID") || cell_(row, h, "ID"),
        subjectId: cell_(row, h, "Subject ID"),
        type: cell_(row, h, "Type"),
        date: cell_(row, h, "Date"),
        timestamp: cell_(row, h, "Timestamp"),
        details: details
      };
    });

    var settings = {};
    var setSheet = ss.getSheetByName("PlatformSettings");
    if (setSheet && setSheet.getLastRow() >= 2) {
      var vals = setSheet.getDataRange().getValues();
      for (var i = 1; i < vals.length; i++) {
        var k = String(vals[i][0] || "").trim();
        var v = vals[i][1];
        if (!k) continue;
        if (v === null || v === undefined) v = "";
        settings[k] = String(v);
      }
    }

    var ltTeams = [];
    var ltSheet = ss.getSheetByName("LtTeams");
    if (ltSheet && ltSheet.getLastRow() >= 2) {
      var ltVals = ltSheet.getDataRange().getValues();
      for (var li = 1; li < ltVals.length; li++) {
        var nm = String(ltVals[li][0] || "").trim();
        if (nm) ltTeams.push(nm);
      }
      ltTeams.sort(function(a, b) { return a.localeCompare(b); });
    }

    return jsonOut({
      result: "success",
      members: members,
      visitors: visitors,
      specialEvents: events,
      attendanceLogs: logs,
      settings: settings,
      ltTeams: ltTeams
    });
  } catch (error) {
    return jsonOut({result: "error", message: error.toString()});
  }
}

/** Convert base64 data-URL to Drive file; return public view URL. Pass-through for http(s). */
function storeImage_(val, idHint, kind) {
  if (val === null || val === undefined) return "";
  val = String(val).trim();
  if (!val) return "";
  if (val.indexOf("http://") === 0 || val.indexOf("https://") === 0) return val;
  if (val.indexOf("data:image") !== 0) {
    // Already a short token or path — keep if small
    return val.length > 49000 ? "" : val;
  }
  try {
    var folder = getPhotoFolder_();
    var comma = val.indexOf(",");
    var meta = comma > 0 ? val.substring(0, comma) : "data:image/jpeg;base64";
    var b64 = comma > 0 ? val.substring(comma + 1) : val;
    var mime = "image/jpeg";
    var m = meta.match(/data:(image\/[a-zA-Z0-9.+-]+);/);
    if (m) mime = m[1];
    var ext = mime.indexOf("png") >= 0 ? "png" : (mime.indexOf("webp") >= 0 ? "webp" : "jpg");
    var bytes = Utilities.base64Decode(b64);
    var blob = Utilities.newBlob(bytes, mime, (idHint || "img") + "_" + (kind || "photo") + "." + ext);
    var file = folder.createFile(blob);
    file.setSharing(DriveApp.Access.ANYONE_WITH_LINK, DriveApp.Permission.VIEW);
    return "https://drive.google.com/uc?export=view&id=" + file.getId();
  } catch (err) {
    // Fallback: store truncated (may be blank on other devices)
    return val.length > 49000 ? "" : val;
  }
}

function getPhotoFolder_() {
  var name = "BNI_Portal_Photos";
  var folders = DriveApp.getFoldersByName(name);
  if (folders.hasNext()) return folders.next();
  return DriveApp.createFolder(name);
}

function stripPlus_(phone) {
  if (phone === null || phone === undefined) return "";
  return String(phone).replace(/\+/g, "").replace(/\s+/g, " ").trim();
}

function jsonOut(obj) {
  return ContentService.createTextOutput(JSON.stringify(obj))
    .setMimeType(ContentService.MimeType.JSON);
}

function getOrCreateSheet_(ss, name) {
  var sheet = ss.getSheetByName(name);
  if (!sheet) sheet = ss.insertSheet(name);
  return sheet;
}

function readSheetAsObjects_(ss, name, mapper) {
  var sheet = ss.getSheetByName(name);
  if (!sheet || sheet.getLastRow() < 2) return [];
  var values = sheet.getDataRange().getValues();
  if (!values || values.length < 2) return [];
  var headers = values[0].map(function(h) { return String(h || "").trim(); });
  var out = [];
  for (var i = 1; i < values.length; i++) {
    var row = values[i];
    if (!row || row.join("").trim() === "") continue;
    var obj = mapper(headers, row);
    if (obj && (obj.id || obj.firstName || obj.title)) out.push(obj);
  }
  return out;
}

function cell_(row, headers, name) {
  var idx = headers.indexOf(name);
  if (idx < 0) return "";
  var v = row[idx];
  if (v === null || v === undefined) return "";
  if (Object.prototype.toString.call(v) === "[object Date]") {
    return Utilities.formatDate(v, Session.getScriptTimeZone(), "yyyy-MM-dd");
  }
  return String(v).trim();
}

Welcome to Today's BNI Meeting

Member Check-in

Visitor Check-in

Active Special Events / ງານອົບຮົມ ແລະ ກິດຈະກຳພິເສດ

Chapter Member Directory / ລາຍຊື່ສະມາຊິກ BNI

Member Attendance Check-in / ເຊັກອິນສະມາຊິກ

Substitute Information / ຂໍ້ມູນຜູ້ຕາງໜ້າ

Visitor List Check-in / ເຊັກອິນຈາກລາຍຊື່ແຂກ

New Visitor Registration Form / ແບບຟອມລົງທະບຽນແຂກໃໝ່

Portal Management Hub / ສູນຄຸ້ມຄອງລະບົບ BNI

Substitute Person Tracker / ລາຍງານການເຂົ້າຮ່ວມຂອງຜູ້ຕາງໜ້າ

Member Birthday Reminder (ST Report)

Visitor Check-in History / ປະວັດການເຂົ້າຮ່ວມຂອງແຂກ

Attendance Log & Check-in Manager / ຈັດການບັນທຶກການເຂົ້າຮ່ວມ

Active Chapter Friday Meeting Settings

Meeting Venue & GPS Check-in Radius

Special Events Management

Leadership Teams (LT) Roles Management

Branding Logos & App Icons (URL or File Upload for ALL Logos)

WhatsApp Policy Warning Messages (Bilingual Lao & English Combined)

PDF Official Notice Content (editable — saved to Google Sheet)

Platform Text & Page Title Customization (Full Page Coverage)

Security Protection

Database Reset

1 Google Apps Script Web App Endpoint URL

2 Google Sheet Database Link

Multi-device

3 Full Google Apps Script (Code.gs)

Member Name

Today is Not Friday!

You are Not at Meeting Venue!

Check-in Confirmed!

Full Name

Already Checked In!

Enter Access PIN

Clear Entire Database

Add New Member

Add / Edit Visitor

Add Special Event

Exact Event Check-in Schedule

Add Custom LT Team

Add Manual Attendance Log

Substitute / Guest Details (Optional)