Copydown alternative

[Eder Triana]

Hi everyone, i have an alternative while they fix this add-on and its very simple:

Step 1:

You have to uninstall copy down add-on and then erase your copy down column

Step 2:

You have tu select A1 and then you go to format - convert to table

And that's it, when you summit a new response formulas will automatic copy down, i don't know why it works like that but works for me in 3 different sheets, let me know if you have any doubts.

(I'm from Mexico so sorry for my bad english). 

[Eduardo Lozano Sierra]

No vuelvo a instalar el Copy? 

Porque lo intente , instalando de nuevo con los pasos que mencionas pero no me funciono, lo puedes volver a decir en español xD gracias.

[Eder Triana]

Mandame un meet al correo edertrian...@gmail.com y con gusto hacemos un meet para explicarte mejor

[Eder Triana]

This video should help you:

https://www.youtube.com/watch?v=JpPEyLhfY24&ab_channel=WandaTerral

[Mesón Leyendas]

Eder Muchas gracias por la información, resuelve el problema de Copy Down y creo que es más robusto que el propio complemento, añado un video donde viene como copiar los formatos (de manera sencilla), espero y sea de utilidad.

https://www.youtube.com/watch?v=vkWnBEw7F3w

Saludos

--
You received this message because you are subscribed to the Google Groups "NV Copy Down Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-copy-down-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/efe22121-7f73-42c8-824e-caa96b2c0828n%40googlegroups.com.

[M Psych Services]

Hi,

since copydown is down and it really disrupted my work, i decided to create a code with the help of chatgpt that works like copydown function, you may want to try it

function onFormSubmit(e) {

var sheetName = 'Form Responses 1';

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);

var lastRow = sheet.getLastRow();

var formulaRow = 2; // Row that contains the formulas

var newRow = lastRow; // The new row where the formulas will be copied

// Get the range of the formulas in the second row

var formulaRange = sheet.getRange(formulaRow, 1, 1, sheet.getLastColumn());

var formulas = formulaRange.getFormulas()[0]; // Get formulas as strings

// Get the range of the new row

var newRowRange = sheet.getRange(newRow, 1, 1, sheet.getLastColumn());

// Loop through each formula

formulas.forEach(function(formula, columnIndex) {

if (formula) {

// Adjust the formula to refer to the new row

var adjustedFormula = formula.replace(/\$?([A-Z]+\d+)/g, function(match) {

if (match.startsWith('$')) {

// Preserve absolute reference

return match;

} else {

// Extract the column and row parts

var columnPart = match.match(/[A-Z]+/)[0];

var rowPart = match.match(/\d+/)[0];

// Adjust row reference to new row

var newRowIndex = parseInt(rowPart) + (newRow - formulaRow);

return columnPart + newRowIndex;

}

});

// Set the adjusted formula in the new row only if there was a formula in the original cell

if (adjustedFormula !== "") {

newRowRange.getCell(1, columnIndex + 1).setFormula(adjustedFormula);

} else {

// Clear the cell in the new row if there was no formula in the original cell

newRowRange.getCell(1, columnIndex + 1).clear({contentsOnly: true});

}

}

});

}

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-copy-down-add-on/CAKK1FCYc%2BH1LHZ5vAdwfPOtnezW8%2BQfA%2BqqLqon29FAOTCsrrg%40mail.gmail.com.