Google Forms Redenumire document inserat

Buna seara,

Vin catre voi cu rugamintea de a ma ajuta dupa multe ore incercand sa gasesc singur o sulutie. Nu am reusit si ma las pagubas.
Vreau ca pozele inserate printr-un formular sa fie automat redenumite in functie de un camp introdus tot in formular.
A mai facut cineva asa ceva? Am gasit pe stackoverflow mai multe exemple insa niciuna nu functioneaza. Fie gresesc undeva, fie imi scapa ceva.

Ma puteti ajuta cu un exemplu de script care sa faca treaba asta?

Eu m-am tot chinuit cu urmatorul insa ceva nu functioneaza.

function myFunction() {
var sheet=ss.getActiveSheet();
var rangeData = sheet.getDataRange();
var lastColumn = rangeData.getLastColumn();
var lastRow = rangeData.getLastRow();
// Notice the second 2, this is to avoid the Timestamp Column
var searchRange = sheet.getRange(2,2, lastRow-1, lastColumn-1);
// Replace with your values (Column A=1, B=2, etc...)
var nameColumn = 2; // B
var urlColumn = 3; // C
// Calculating index for array
nameColumn -= 2;
  urlColumn -= 2;}
// Use this to rename the last record
function last() {
  var lastRowContents=sheet.getRange(lastRow,2,1,sheet.getLastColumn()).getValues()[0];
  rename(lastRowContents);
}
// Retrieves the ID and Name fields from the row, then
// renames the file
function rename(row) {
  // Using the first field, Name (Index 0 becuse of the array, calculated above)
  // ** Even though the Name field is the second column, we see it as the first one since
  //	we ignored the timestamp column in the searchRange **
  var userName = row[nameColumn];
  var url = row[urlColumn];
  // Retrieve the ID from the URL
  var Id = url.split('=')[1];
  // Adapt this newFileName to your needs
  var newFileName = userName;
  // Get the file and rename it
  DriveApp.getFileById(Id).setName(newFileName);
  Logger.log("Renamed file with ID " + Id + " to " + newFileName);
}

Edited by sharque99, 16 December 2020 - 00:30.

Nimeni?

Daca nu reusesc sa redenumesc automat fisierele in momentul incarcarii, mai am alternativa de a le redenumia automat bazandu-ma pe informatiile dintr-ul fisier gsheets.
In fisier am numar_contract ; url_atasament.
Cum as putea redenumi atasamentele dintr-un folder cu informatia din numar_contract?