Get the value of the text in the form, TRY IT OUT: First name: GetDATA

For Tagmanager or just basic JS/HTML exercise: <script> function GiveBackName() { let inputvalue = document.getElementById("fname").value alert(inputvalue) console.log(inputvalue) // for TagManager you just need: // return document.getElementById("fname").value } </script>

function loopit_percentages() { var percentcols = ['D', 'E','F'] for (var k = 0; k<= percentcols.length -1; k++) { for (var i = 1; i<=20;i++) { var rng = percentcols[k] + i.toString() Logger.log(rng) SpreadsheetApp.getActiveSheet().getRange(rng).setNumberFormat("0.00%") }}} function…