How to make custom function for google spreadsheet?

Question

JavaScript

It is necessary to make the following function:

Increase by one the value of a certain cell, in which the function will be placed, if a cell located in a specific range of cells has a reference value.

The bottom line: this is a work plan in a Google spreadsheet, a media plan in which topics of publications are packed, and when a publication is released, a link is attached to the entry, as a result of which the value of the cell in which the number of published publications is fixed should increase by one. I built something here, thanks to Maxim Stoyanov, who gave a working hasLink () function. But the knowledge is clearly lacking.

function makeTotal(sells){
  const sheet = SpreadsheetApp.getActiveSpreadsheet();
 
  var range = sheet.getRange(sells);
  var values = range.getValues();
  var z = 0;
  
    for (var i=0;i < range.length;i++){
      if(hasLink(values)){z++;}
      
      }
  return z;
    }


  

      function hasLink ( cell_address ) {
  const sheet = SpreadsheetApp.getActiveSheet();
  
  const formula = sheet.getActiveRange().getFormula();
  const args = formula.match(/hasLink\(([^\)]*?)\)/i)[1].trim();
  range = sheet.getRange(args);
  
  const values = range.getRichTextValues();
  
  const result = [];
  
  for ( let cells of values ) {
    for ( let cell of cells ) {
      const link_url = cell.getLinkUrl();
      if (link_url) result.push(link_url);
    }
  }
  
  return result.length ? true : false;
}

Answer 1

Isn't it easier to count links this way? (counts in column A):

=СЧЁТЗ(ЕСЛИОШИБКА(filter(A:A;REGEXMATCH(A:A;"(https?:\/\/)?([\w\.]+)\.([a-z]{2,6}\.?)(\/[\w\.]*)*\/?"))))