we can use Api in spreadsheet
https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet
For example if we put this code to scripts it will send e-mail with last
row....
function sendMail() {
//test_mail-название листа в таблице
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Ответы
на форму (1)');
var values = sheet.getDataRange().getValues();
// проверяем наличие хотя бы одной записи
if (values.length < 2)
return;
var lastValueIndex = values.length - 1;
var myEmail = '[email protected]'; // Ваш e-mail
var subject = 'НОВЫЙ ЗАКАЗ!!!';
//values[lastValueIndex][1]-это столбик из таблицы, нужно будет менять
циферку. Так же проверил, можно ли несколько в одно объяденить, можно
var mes=values[lastValueIndex][6]+("\n")+values[lastValueIndex][2]+("\n")+
values[lastValueIndex][3]+("\n")+values[lastValueIndex][4]+("\n")+values[
lastValueIndex][5]+("\n")+values[lastValueIndex][7];
// отправляем письмо
MailApp.sendEmail(myEmail, subject,mes);
}
понедельник, 25 апреля 2016 г., 9:31:50 UTC+3 пользователь Jed Carty
написал:
> That is all the test button does right now. The interesting things I have
> done are more on the back end where it uses web workers so it doesn't hurt
> the performance of the wiki when you are loading things from slow sites.
> Since things are mostly hidden from normal use now I posted in the dev
> group and will probably not post here until I have something more
> interesting to show for it.
>
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/d2abcf0d-5e65-4f46-958a-50e93332e628%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
