Creating a custom formula with array having multiple arguments in columns with different data

Question

Up to this point I've managed to get it to work for a single argument (body) but without the second argument (photoUrl):

function SendTelegram(body,photoUrl) {
  if (body.map) {
    var response = body.map(function(b) {return SendTelegram(b);});
  } else {
    var response = UrlFetchApp.fetch(
      "https://api.telegram.org/bot" + 'AAA' + 
        "/sendPhoto?caption=" + encodeURIComponent(body) + 
          "&photo=" + encodeURIComponent(photoUrl) + 
            "&chat_id=" + 'BBB' + 
              "&disable_web_page_preview=true&parse_mode=HTML"
    );
  }
}

I'm not able to understand how I should proceed to work with this two different arguments, for example, the function in the spreadsheet would be:

=ARRAYFORMULA(SendTelegram(A1:A,B1:B))

In my attempts when I try to add the second argument, it always uses the first row value in all calls, it doesn't follow the array one by one.

Tanaike · Accepted Answer · 2022-05-27 13:51:16Z

1

In your script, at SendTelegram(b) of var response = body.map(function(b) {return SendTelegram(b);});, the 2nd argument is not set. By this, at 2nd loop, photoUrl is not declared. I thought that this might be the reason of your issue.

And, in your script, I thought that it might be required to return the response value. So, how about the following modification?

Modified script:

function SendTelegram(body, photoUrl) {
  if (body.map) {
    return body.map((b, i) => SendTelegram(b, photoUrl[i]));
  } else if (body && photoUrl) {
    return UrlFetchApp.fetch(
      "https://api.telegram.org/bot" + 'AAA' +
      "/sendPhoto?caption=" + encodeURIComponent(body) +
      "&photo=" + encodeURIComponent(photoUrl) +
      "&chat_id=" + 'BBB' +
      "&disable_web_page_preview=true&parse_mode=HTML", { muteHttpExceptions: true }
    ).getContentText();
  }
  return null;
}

Note:

This is a simple modification. Because I cannot understand your expected value from the URL. So, please modify the script for your situation.

answered May 27, 2022 at 13:51

Tanaike

204k12 gold badges126 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Digital Farmer Over a year ago

Hi @Tanaike When called, it sends the text and image to a channel alert on Telegram, the direct use is for that, I end up not needing to register anything, I just send it and finish using the function. Thanks for support!

Tanaike Over a year ago

@Brondby IF Thank you for replying. I'm glad your issue was resolved. Thank you, too.

Collectives™ on Stack Overflow

Creating a custom formula with array having multiple arguments in columns with different data

1 Answer 1

Modified script:

Note:

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Modified script:

Note:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related