Table Entry Line

SergeiBaklan I've updated my script to:

a) find and only apply to a table next to the active cell

b) not overwrite table formulas (and still copy value only if formula in the insert line)

c) still do not delete formula from insert line

d) throw error (i.e. comment in log) if active cell is not next to a table

e) after entering data and clearing input line, set cursor to 1 cell on that line

I also created 2 'companion' scripts: 1 to clear the input line (i.e. change your mind and don't want that data) and 1 to use the input line as a filter for the table (actually need to finish this script)

Here is the new look:

and the updated code:

/**
 * This script inserts the row above a table into the table.
 */
function main(workbook: ExcelScript.Workbook) {
  let wksht = workbook.getActiveWorksheet();
  //Unlock worksheet
  let wkshtProtect = wksht.getProtection().getProtected();
  if (wkshtProtect) {wksht.getProtection().unprotect(); };

  //find active cell and 3x3 around that cell as 'activeBubble' to find correct table
  let activeCell = workbook.getActiveCell();
  let aMinRow = activeCell.getRowIndex() - 1;
  if (aMinRow < 0) { aMinRow = 0; };
  let aMinCol = activeCell.getColumnIndex() - 1;
  if (aMinCol < 0) { aMinCol = 0; };
  let activeBubble = wksht.getRangeByIndexes(aMinRow, aMinCol, 3, 3).getAddress();

  //Check each table if row above overlaps activeBubble
  let tCount = wksht.getTables().length;
  let foundTable = 0;
//  let tbl = wksht.getTables().shift()  
  wksht.getTables().forEach( (tbl) => {
    foundTable= Math.abs(foundTable); 
    let newData = tbl.getHeaderRowRange().getOffsetRange(-1, 0);
    if (wksht.getRange(newData.getAddress()).getIntersection(activeBubble)) {
      //let remFormat = newData.getFormat();
      //tbl.addRows(-1, newData.getValues());
      tbl.addRow();
      let newRow = tbl.getRange().getLastRow();   //.getTotalRowRange().getLastRow();
      
      let n = newData.getColumnCount();

      for (let i = 0; i< n; i++) { 
        //selectively inserts data from input line (i.e. do not overwrite table formulas)
        if ( !newRow.getCell(0, i).getFormula().toString().startsWith("=") ) {
          newRow.getCell(0, i).copyFrom(newData.getCell(0, i), ExcelScript.RangeCopyType.values); 
        };
        //selectively clear input line (i.e. do not clear formulas)
        if ( !newData.getCell(0, i).getFormula().toString().startsWith("=") ) {
          newData.getCell(0, i).setValue(""); //.clear
        };
      };
      //put cursor back on 'start' of input line
      newData.getCell(0,0).select();
    } else {foundTable++};
  });
  //console.log("tCount=" + tCount + " foundTable=" + foundTable);
  if (tCount == foundTable){
    //console.log("no table found next to last active cell.");
    //return;
    throw 'no table found next to last active cell'; 
  }
  //TEST CODE SECTION - IGNORE
  
  
  //if it was protected, re-protect
  if (wkshtProtect) {wksht.getProtection().protect();};
}