CODEWITHSUNDEEP
dateif-statementgoogle-sheetslambdagoogle-sheets-formula
Daniel Zabczyk
Daniel Zabczyk

Reputation: 37

Using ArrayFormula for "myfunction" custom formula - Google Sheets

Could you help me with this?

I have one "myfunction" formula which is simple script:

`

function myFunction(url)
{
   url = "https://www.google.com/search?q=site:"+url;
      var options = {
     'muteHttpExceptions': true,
     'followRedirects': true
   };
   var response = UrlFetchApp.fetch(url, options);
   var html     = response.getContentText();
   if (html.match(/Your search -.*- did not match any documents./) ){
     return "Not Indexed";
     }
     else {
     return "Indexed";
     }
}

`

And what I want to do is to use ArrayFormula for this funciton but it is not working.

Here's the spreadsheet with example: https://docs.google.com/spreadsheets/d/1CYuRd8SlkRVoQjWrFcOzMB387bJU15zLhunylPRIEJY/edit?usp=sharing

Any ideas?

Thanks a lot!

I've tried this one:

=arrayformula(myfunction(A3))

Upvotes: 1

Views: 65

Answers (1)

player0
player0

Reputation: 1

use:

=BYROW(A1:INDEX(A:A, COUNTA(A:A)), LAMBDA(x, myfunction(x)))

enter image description here

update:

=INDEX(IF((A1:A="")+ISDATE_STRICT(A1:A)+ISNUMBER(A1:A),,
 BYROW(A1:INDEX(A:A, COUNTA(A:A)), LAMBDA(x, myfunction(x)))))

Upvotes: 1

Related Questions