You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I've been looking for a solution for since a week
I will explain it here hoping to get help
i made a script that interacts with telegram using Apps script and i have a spreadsheet which has a database...
3 columns 500 rows
ID , Username, Full Name
i want to make a command for tg bot like when i send /who "ID NUMBER" it looks up in the spreadsheet in first columns for that specific ID NUMBER and sends back the Full name of it
here is my apps script
var ssId = "16Rw-ilDTdozSHOn73I0fhXeaTJuixyQOp7BDDXfY9Cs";
function setWebhook() {
var url = telegramUrl + "/setWebhook?url=" + webAppUrl;
var response = UrlFetchApp.fetch(url);
}
function sendMessage(id, text,) {
var url = telegramUrl + "/sendMessage?chat_id=" + id + "&text=" + text;
var response = UrlFetchApp.fetch(url);
}
function doPost(s) {
var contents = JSON.parse(s.postData.contents);
var id = contents.message.from.id; // user ID
var name = contents.message.from.first_name; // Sender First name
var uname = contents.message.from.username; // Sender Username
var text = contents.message.text; // Message Text
if (text.includes("/who")) {
var result = text.substr(text.indexOf(" ") + 1);; // this line removes the first word from the Message`
The text was updated successfully, but these errors were encountered:
Simple example
Var result =138 // im looking for the full name of this id
I want the script to lookup in the sheet for that id in the first column in every row
If its in A83 i want to put C83 value in a var found
Hello,
I've been looking for a solution for since a week
I will explain it here hoping to get help
i made a script that interacts with telegram using Apps script and i have a spreadsheet which has a database...
3 columns 500 rows
ID , Username, Full Name
i want to make a command for tg bot like when i send /who "ID NUMBER" it looks up in the spreadsheet in first columns for that specific ID NUMBER and sends back the Full name of it
here is my apps script
var ssId = "16Rw-ilDTdozSHOn73I0fhXeaTJuixyQOp7BDDXfY9Cs";
function setWebhook() {
var url = telegramUrl + "/setWebhook?url=" + webAppUrl;
var response = UrlFetchApp.fetch(url);
}
function sendMessage(id, text,) {
var url = telegramUrl + "/sendMessage?chat_id=" + id + "&text=" + text;
var response = UrlFetchApp.fetch(url);
}
function doPost(s) {
var contents = JSON.parse(s.postData.contents);
var id = contents.message.from.id; // user ID
var name = contents.message.from.first_name; // Sender First name
var uname = contents.message.from.username; // Sender Username
var text = contents.message.text; // Message Text
if (text.includes("/who")) {
The text was updated successfully, but these errors were encountered: