google-apps-script

I collect people's full names through Google Forms, etc.the data, and the form writes it to the Google spreadsheet. I really ... d in red). Me it seems that with the help of Google Apps Script it was possible to do this, but I'm not good at programming.

There is a google table, editing rights are given to everyone. There is a myonEdit script-set to run as a trigger that sends ... necessary to hide it, or I don't even know how. I think there is a way to achieve what I want. Tell me which way to Google.

In my script, I get the cell value (the content is the date in the short format dd. mm.yyyy, the cell in the format "Date") a ... s. What did I do wrong in the first version of the code, that I got the date a day less than the one that came from the cell?

Actually, the question is in the name of the topic. I tried it like this , but it didn't work: SpreadsheetApp.openById(OrderSpreadSheet); So it opens the file on the server, but how in the browser?

A telegram bot has been created that sends certain data from a Google table on request. The message is collected and formatte ... ers in the message text are always on the right edge, regardless of the number of characters? Approximately as in the picture

Closed. This question should be specified . Answers to it are not accepted at the moment. ... In excel on vba did... here somehow everything is not so... If anyone has a link to Russian-language resources, please write.

Is there any way to get a picture (png/jpg) from part of the Google sheet range as a placemark? I tried to build a diagram in ... var chart = chartTableBuilder.build(); sheet.insertChart(chart); // var img = chart.getAs('image/png'); Здесь ошибка

JSON. stringify converts the date-time in Moscow time format, for example, "Sat Apr 25 2020 10:12:42 GMT+0300 (MSK)", and to ... any time correction (such as getTimezoneOffset ()), but to solve it systemically at the level of formats or project settings.

I found a ready-made solution on the internet, but I really want to understand how it works. I have a Google form where the ... the full name) FULL NAME: [""]. This is not nice (if you use a script to send a copy to the person who filled out the form).

How do I implement a drop-down list with values from another table? There are 3 tables: Report; Projects; Tasks. You need to import projects and tasks to them into the report

How to implement data exchange between tables Google Spreadsheet? For clarity, I visualized everything in the picture: The ... ocuments. When you edit the cells, the information should be updated in a different table. String matching must be observed.

How to call VK API via Google Apps Script? You need to write a function for accessing the api for the specified cells (each ... e output data in xml format by taking only a few values from certain tags(a numeric value) and inserting them into the table.

We have a table with data. Where each row is a separate record. I perform a certain operation with these records. A script is ... when launched, expanded the range from one selected cell to the required number of columns. In Google Script, I can't do it.

function Copy_Z() { var spreadsheet = SpreadsheetApp.getActive(); var range = SpreadsheetApp.getActiveSpreadsheet().getAc ... tRow(), spreadsheet.getActiveRange().getNumRows()); }; How can I clear the data of certain columns from the selected range?