i am using this function to create new Form:
function CreateNewForm() {
// Create a new form, then add a checkbox question, a multiple choice question,
// a page break, then a date question and a grid of questions.
// let adName = adminName;
// Logger.log(`${adName}`);
var formNew = FormApp.create('Formularz - Narzędzie do umawiania spotkań');
var item = formNew.addTextItem();
item.setTitle('Imię');
item.setRequired(true);
var item = formNew.addTextItem();
item.setTitle('Email');
item.setRequired(true);
var item = formNew.addTextItem();
item.setTitle('Telefon/Uwagi');
item.setRequired(true);
var item = formNew.addListItem();
item.setTitle('Wybierz czas spotkania');
item.setRequired(true);
Logger.log('Published URL: ' + formNew.getPublishedUrl());
Logger.log('Published URL: ' + formNew.getId());
return formNew.getId();
}
and now i want to create link to this form from current worksheet. How can i do this? Best, Jacek