Google Apps script – The onEdit feature does not work under the following features

I have problems with my GAS below:

The problem is that the sendSms () function does not work after editing the sheet.

// datownik

Function onEdit (e) {
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var sheet = e.source.getActiveSheet (). getName ();
var editedColumn = e.range.getSheet (). getActiveCell (). getColumn ();
if (e.value == "ZAKONCZONO" && editedColumn == 12 && e.range.offset (0,5) .isBlank () &&! e.range.offset (0,3) .isBlank () &&! e. range.offset (0.4) .isBlank ()) {
e.range.offset (0.5) .setValue (new Date ()). setNumberFormat ("yyyy-MM-dd");
Send a SMS();
}
}

// Wysyłanie powiadomień SMS

Function sendSms () {
var key = "key = ***************";
var password = "password = ********";
var from = "from = TEST";
var to = "to = **********";
var msg = "msg = mytext";
var url = "https://api.playsms.pl/send?" + key + "&" + password + "&" + from + "&" + to + "&" + msg;
UrlFetchApp.fetch (url);
}

How do I use the SPLIT feature in Google Spreadsheets with different delimiters and some delimiters with multiple characters?

My question is similar to this:
SPLIT function in Google Spreadsheets with OR statement

but has the following difference:

I want to use the delimiter "Apple"and the limiter","within the SPLIT function.

Since the limiter Apple has several characters, @parkydr answer here does not work.

Example:

At this entrance on A2:

I ate an apple on the bus home. Go

I would like it to be divided as follows:

I ate home on the bus

I tried:

= SPLIT (A2, "apple", TRUE)

I / T / N / ON / TH / Bus / Home / Going

and the

= SPLIT (A2, "& # 39; & # 39;", TRUE)

I / T / N / ON / TH / Bus / Home / Going

and the

= SPLIT (A2, "apple", false)

I ate an apple on the bus home. Go

and the

= SPLIT (A2, "apple" ".", False)
#ERROR Error parsing the formula.

and the

= SPLIT (A2, "& # 39; & # 39; & # 39;", False)
I ate an apple on the bus home. Go

How do I make the next split back?

I ate home on the bus

magento2 – When upgrading from Magento 2.2.6 to 2.3.1, the feature to partially refund credits was discontinued

The credit note has a field "Adjustment Refund" at the bottom. Before upgrading to 2.3.1 If I entered a value in this field, there was a Refresh Totals button to update the total. However, after upgrading to 2.3.1, this button will not be displayed. Attach screenshots for more details.

Credit broken[![][1]]2

Attempting to retrieve data from this website using the ImportXML feature on Google Sheet

I'm trying to get the business name and cashback percentage from this site using the Google Sheets Import XML feature.

Put the following commands to no avail. please help

= importxml ("https://www.shopback.com.au/all-stores", "// div[@class=’store-list col-md-4 col-sm-6′]")

= importxml ("https://www.shopback.com.au/all-stores", "// div[@class=’store-name’]")

= importxml ("https://www.shopback.com.au/all-stores", "// div[@class=’store-cashback-value’]")

jquery – Tips for optimizing the JavaScript For Loop feature

$ (& # 39;. Table__button & # 39;). click (function () {
for (var i = 0; i <$ (& # 39; table.table td & # 39;). length; i ++) {
if (! $ ($ (& # 39; table.table td & # 39;)[i]) .hasClass (& # 39; table__cell - disabled & # 39;)) {
$ ($ (& # 39; table.table td & # 39;)[i]) .css (& # 39; background & # 39 ;, $ ($ (& # 39; table.table td & # 39;)[i]) .attr (& # 39; data color & # 39;));
$ ($ (& # 39; table.table td & # 39;)[i]) .css (& # 39; text-decoration & # 39 ;, & # 39; underline & # 39;);
$ ($ (& # 39; table.table td & # 39;)[i]) .css (& # 39; font-weight & # 39 ;, & # 39; bold & # 39;);
$ ($ (& # 39; table.table td & # 39;)[i]) .css (& # 39; text-align & # 39 ;, & # 39; center & # 39;);
$ ($ (& # 39; table.table td & # 39;)[i]) .addClass (& # 39; is colored & # 39;);
$ ($ (& # 39; table.table td & # 39;)[i]) .html (& # 39; I am now & # 39; + $ ($ (& # 39; table.table td & # 39;)[i]) .attr (& # 39; data color & # 39;));
}
$ (& # 39;. Table__button & # 39;). attr (& # 39; disabled & # 39 ;, & # 39; disabled & # 39; disabled);
}
});
/ * Do not change the CSS * /

Table {
Width: 100%;
Edge-ground: 40px;
}
tr: nth child (odd) {
Background: # f0f0f0;
}
td {
Padding: 10px;
}

 
Make me green Make me yellow
Turn me blue Make me red
leave me alone leave me alone

Feature Programming – Print a Connect 4 raster based on some rules for each cell

In a game by Connect4:

  • we start with an empty grid
  • Two players put the stones X and O on the starting grid
  • the first player to score 4 stones in a row wins!
  • This is a text based console game

Here's the code I wrote to print each cell in the grid:

def asText (grid: Grid) = {

def asText (x: Int, y: Int) = {

val isTop = y == 0 && x! = grid.x + 1 && x! = 0
val newLine = x == grid.x + 1
val isBottom = y == grid.y + 1 && x! = 0
val isLeft = x == 0
val isX = grid.pieces.contains (piece ("X", x, y))
val isY = grid.pieces.contains (piece ("O", x, y))

List (isTop, newLine, isBottom, isLeft, isX, isY) match {
case true :: _ => "-"
case _ :: true :: _ => "|  n"
case _ :: _ :: true :: _ => "-"
case _ :: _ :: _ :: true :: _ => "|"
case _ :: _ :: _ :: _ :: true :: _ => "X"
case _ :: _ :: _ :: _ :: _ :: true :: _ => "O"
case _ => "."
}
}

val v = for {
y <- 0 to grid.y + 1
x <- 0 to grid.x + 1
text = asText (x, y)
} Text result

v.mkString ("")
}

I do not like that _::_::_::_::_::true::_ but I can not imagine a way to improve it. Can this style be improved? Is there a more typical Scala style for this?

Example output:

| ------ |
| XO .... |
| ...... |
| ...... |
| ...... |
| ...... |
| ...... |
| ...... |
| ------ |

dnd 5e – Is this alternative feature of Draconian descent (the flight granted) a balanced substitute for the characteristic of the dragon's breath weapon?

A player with a Dragonborn PC has recently requested that he grow wings in our game and reach a flying speed. I did not like any of the alternative Dragonborn options that allow for flight, and here's my current idea. Is this option balanced with respect to the Dragonborn as in PHB, with the following feature replacing respiratory function? (Leave the resistor intact.)

Balic Descent (Alternate): Because of your heritage, your character sprouts wings and a tail that grows slowly throughout your life. If you choose Wings in the first level, you will lose your normal breathing abilities as your magical bloodline slowly increases your flight and agility instead.

Stage 1: Wings and tail sprout from the buds of your body and grow slowly with age. No flight is possible at this point as the wings and tail are small and frail (easy to hide under normal clothing).

3rd Level: Your wings are as long as your arms have grown, your tail is half as long as your arm and must be free to balance and maneuver in flight. Your wings and tail are no longer concealable and you have to spend + 20% basic cost to change your clothes or armor. You gain airspeed equal to your normal walking speed. Flying is extremely exhausting at this time. You are only allowed to fly a number of rounds that equals 1 plus your constitutional modifier (min 0) for each short or long break. If you are still in the air when you reach this limit, you immediately fall to the ground and have disadvantages in attacks or skill checks made during this round.
You receive "Wrym's Charge": Your wings drive you faster when you attack an opponent. Your landing speed when using this ability is x1.5 of your base, but you must move in a straight line. Charging at least 20 minutes this way will give you an edge on your next attack roll. This ability recharges after a long break.

Level 6: Your wings have grown to suit your size, and your tail is 1/2 of your size. Your airspeed will increase to x1,5 of your ground speed. You can fly a number of rounds equal to half your CON score (rounded up) per short or long break.
Wrym's batch is usable 2 times per long break.

Level 11: Your wings grow to 1.5 times your size and your tail is your size. Your airspeed will increase to x2 of your ground speed. You can fly several rounds that match your CON score per short or long break.
Wrym's batch is usable 3 times per long break.
You gain the ability to "fly by" (do not provoke a casual attack if you are out of range of an enemy)

Stage 16: Your wings and tail do not get much bigger, but thicker and thicker. The airspeed increases to 3 times your ground speed. You can fly a total of rounds equal to twice your CON score per short or long break.

Implicit feature set – Mathematica Stack Exchange

I think I'm stuck right here:

The exercise is to use implicit differentiation to determine y & # 39; using the following equation:

Enter image description here

I did that with:

eqn = e ^ (ax / y[x]) + e ^ (bx / y[x]) == c;
To solve[D[eqn, x]y[x]]

what leads to the result below, which should be correct …

Enter image description here

The next exercise is to verify the solution with the implicit set of functions, but I have no idea how to do that. Would be glad about every answer: D