TIASYSOMBATH Family Network

Add Relative

Adding relative for

Nickname *

Country *

Local Name (Lao/Thai/Viet)

Chinese Name

First Name *

Middle

Last Name *

Birth Year

Deceased

Gender *

Remark (Additional Data)

Select Relationship to Add

Welcome Family

Please identify yourself to access the platform. This helps track updates.

Who are you in the family tree?

If you are not in the list, please ask a relative to add you first.

☁️ Admin Settings

Connect this platform to a Google Sheet database & Manage Excel Files.

Excel Database Management

Import & Replace

Warning: Importing will overwrite the entire database.

App Settings (Home Screen)

App Short Name

1. Google Apps Script Code

function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    if (data.action === 'sync') {
      updateSheetData('FamilyDB', data.db);
      return ContentService.createTextOutput(JSON.stringify({"status": "success"})).setMimeType(ContentService.MimeType.JSON);
    }
  } catch(err) { return ContentService.createTextOutput(JSON.stringify({"status": "error", "message": err.toString()})).setMimeType(ContentService.MimeType.JSON); }
}
function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var result = { db: getSheetData(ss, 'FamilyDB') };
  return ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON);
}
function updateSheetData(sheetName, dataArray) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(sheetName);
  if (!sheet) sheet = ss.insertSheet(sheetName);
  sheet.clearContents();
  if(dataArray && dataArray.length > 0) sheet.getRange(1, 1, dataArray.length, dataArray[0].length).setValues(dataArray);
}
function getSheetData(ss, name) {
  var sheet = ss.getSheetByName(name);
  if(!sheet) return [];
  var range = sheet.getDataRange();
  if(range.getNumRows() == 0) return [];
  return range.getDisplayValues();
}

2. Deploy as Web App & Paste URL

TIASYSOMBATH

Name Surname

Work & Bio

Remarks / Additional Info

Contact & Location

Business Card / Document