Ändern Sie den Titel der Tabelle ab, hängt vom Titel im Blatt mit dem Datenarray ab ⇐ JavaScript

[Anonymous]

Gibt es eine Formel, die das Datenarray unter Verwendung des Datenarrays unter Verwendung des Wertes in dem Blatt ändert, den Titel auch im Datenarray und in der Tabelle nachdenken? src = "https://i.Sstatic.net/it8oye6j.gif"/>
Der Code:
Code.gs

Code: Select all

let MySheets  = SpreadsheetApp.getActiveSpreadsheet();
let LoginSheet  = MySheets.getSheetByName("Attendance");
let UserSheet  = MySheets.getSheetByName("User");

function doGet(e) {
var output = HtmlService.createTemplateFromFile('Login');
var sess = getSession();
if (sess.loggedIn) {

let page = e.parameter.page;         //01
if (page == null) page = "Main";     //02
output = HtmlService.createTemplateFromFile(page);
return output.evaluate().setTitle('Page')
.addMetaTag('viewport', 'width=device-width, initial-scale=1');
}

return output.evaluate().setTitle('Login Page')
.addMetaTag('viewport', 'width=device-width, initial-scale=1');
}

function includeHeader()   //05
{
return HtmlService.createTemplateFromFile("Header.html").evaluate().getContent();
}

function myURL() {
return ScriptApp.getService().getUrl();
}

function setSession(session) {
var sId   = Session.getTemporaryActiveUserKey();
var uProp = PropertiesService.getUserProperties();
uProp.setProperty(sId, JSON.stringify(session));
}

function getSession() {
var sId   = Session.getTemporaryActiveUserKey();
var uProp = PropertiesService.getUserProperties();
var sData = uProp.getProperty(sId);
return sData ? JSON.parse(sData) : { loggedIn: false };
}

function loginUser(pUID, pPassword) {

if (loginCheck(pUID, pPassword)) {

var sess = getSession();
sess.loggedIn = true;
sess.uid = pUID;
setSession(sess);

return 'success';
}
else {
return 'failure';
}
}

function logoutUser() {
var sess = getSession();
sess.loggedIn = false;
setSession(sess);
}

function loginCheck(pUID, pPassword) {
let LoginPass =  false;
let ReturnData = UserSheet.getRange("A:A").createTextFinder(pUID).matchEntireCell(true).findAll();

ReturnData.forEach(function (range) {
let StartRow = range.getRow();
let TmpPass = UserSheet.getRange(StartRow, 2).getValue();
if (TmpPass == pPassword)
{
LoginPass = true;
}
});

return LoginPass;
}
function include(filename) {
return HtmlService.createHtmlOutputFromFile(filename).getContent();
}

/**DataTable */
function getAllDataAtt() {
var sess = getSession();
var uid = sess.uid;
var range = LoginSheet.getDataRange().getDisplayValues();
var header = range.shift();
var userData = range.filter(function(row) {
return row[29] === uid;
});
Logger.log(userData);
return userData;
}< /code>
< /div>
< /div>
< /p>
[b] main.html[/b]