Google Sheets onEdit – Run two scripts

I'm trying to run two scripts in a worksheet. However, only the last one will be executed. I am sure that I miss something small, but no ideas.

/ **
* Moves a line from one sheet to another when a magic value is entered in a column.
* The name of the sheet to move the line to is indicated by the magic value.
*
* To use this script:
*
* - Make a backup copy of your spreadsheet via File> Create Copy
* - Select all the text in this script, starting with the first "/ **" line and ending with the last "}".
* - copy the script with Ctrl + C to the clipboard (on a Mac, ⌘C)
* - Open the table in which you want to use the function
* - select Tools> Script Editor> Empty (this opens a new tab in the browser)
* - If you only use the wildcard & # 39; function myFunction () {} & # 39; see, press Ctrl + A (on a Mac ⌘A)
* followed by Ctrl + V (⌘V) to insert the script
* - Otherwise, choose File> New> Script File and press Ctrl + A (on Mac ⌘A) followed by
* Ctrl + V (⌘V) to insert the script
* - If you have an existing onEdit (e) function, add the following line as the first line after that
* initial & # 39; & # 39; in this onEdit (e) function:
* moveRowsFromSheetToSheet_ (e);
* ... and then delete the function onEdit (e) below (5 comment lines, 3 lines of code)
* - Press Ctrl + S (⌘S) to save the script
* - Name the project 'moveRowsFromSheetToSheet & # 39; when prompted.
* - Close the Script Editor tab and return to the Spreadsheet tab
* - The script runs automatically when you edit a cell in the column that is being monitored
*
* See https://productforums.google.com/d/topic/docs/icrZ3WPMRoU/discussion
* /


/ **
* Simple trigger that runs every time the user edits the table.
*
* @param {Object} e The event object onEdit ().
* /
Function onEdit (e) {
moveRowsFromSheetToSheet_ ();
moveRowsFromSheetToSheet1_ ();
}


/ **
* Moves a line from one sheet to another when a magic value is entered in a column.
* The name of the sheet to move the line to is indicated by the magic value.
*
* @param {Object} e The event object onEdit ().
* /
Function moveRowsFromSheetToSheet_ (e) {
// Version 1.1, written by --Hyde, October 29, 2018
// - deletes the cell in column F of the row that was moved to a new sheet for the array formula to work
// - Move lines only if they are in the non-frozen area of ​​the sheet
// - changed from spreadsheetApp.getActiveSpreadsheet () to e.source, and so on
// Version 1.0, written by --Hyde, July 14, 2015

///////////////////
// Adapt the following variables to your needs
var columnNumberToWatch = 13; // column A = 1, B = 2 etc.
var sheetNamesToWatch =          ['REVIEW','LIVE', 'WON', 'LOST'];
var valuesToWatch =              ['REVIEW','LIVE', 'WON', 'LOST'];
var targetSheetsToMoveTheRowTo = ['REVIEW','LIVE', 'WON', 'LOST'];
///////////////////

var sheet = e.range.getSheet ();
if (sheetNamesToWatch.indexOf (sheet.getName ()) == -1
|| valuesToWatch.indexOf (e.range.getValue ()) == -1
|| e.range.getColumn ()! = columnNumberToWatch
|| e.range.getRow () <= sheet.getFrozenRows ()) {
Return;
}
var targetSheet = e.source.getSheetByName (targetSheetsToMoveTheRowTo[valuesToWatch.indexOf(e.range.getValue())]);
var targetSheetColumnAValues ​​= targetSheet.getRange (
/ * row * / 1,
/ * column * / 1,
/ * numRows * / targetSheet.getLastRow (),
/ * numColumns * / 2) .getDisplayValues ​​();
var row = targetSheetColumnAValues.length - 1;
while (row &&! (targetSheetColumnAValues[row][0], Length || targetSheetColumnAValues[row][1]Length)) {
Line--;
}
Line + = 1;
if (row <targetSheet.getFrozenRows ()) {
var error = & # 39; moveRowsFromSheetToSheet_ () found an incorrectly formatted target column on sheet "+ targetSheet.getName () +" (row = & # 39; + row + & # 39;). & # 39 ;;
SpreadsheetApp.getActive (). Toast (error, & # 39; error & # 39 ;, 20);
throw a new error (error);
}
var targetRange = targetSheet.getRange (line + 1, 1);
sheet.getRange (e.range.getRow (), 1, 1, sheet.getLastColumn ()). moveTo (targetRange);
targetRange.offset (/ * line * / 0, / * column F * / 6 - 1) .clearContent (); // delete the value in column F for the matrix formula to work
sheet.deleteRow (e.range.getRow ());
}


/ **
* Moves a line from one sheet to another when a magic value is entered in a column.
* The name of the sheet to move the line to is indicated by the magic value.
*
* @param {Object} e The event object onEdit ().
* /
Function moveRowsFromSheetToSheet1_ (e) {
// Version 1.1, written by --Hyde, October 29, 2018
// - deletes the cell in column F of the row that was moved to a new sheet for the array formula to work
// - Move lines only if they are in the non-frozen area of ​​the sheet
// - changed from spreadsheetApp.getActiveSpreadsheet () to e.source, and so on
// Version 1.0, written by --Hyde, July 14, 2015

///////////////////
// Adapt the following variables to your needs
var columnNumberToWatch = 9; // column A = 1, B = 2 etc.
var sheetNamesToWatch =          ['Account', 'Prospect', 'Archive'];
var valuesToWatch =              ['Account', 'Prospect', 'Archive'];
var targetSheetsToMoveTheRowTo = ['Account', 'Prospect', 'Archive'];
///////////////////

var sheet = e.range.getSheet ();
if (sheetNamesToWatch.indexOf (sheet.getName ()) == -1
|| valuesToWatch.indexOf (e.range.getValue ()) == -1
|| e.range.getColumn ()! = columnNumberToWatch
|| e.range.getRow () <= sheet.getFrozenRows ()) {
Return;
}
var targetSheet = e.source.getSheetByName (targetSheetsToMoveTheRowTo[valuesToWatch.indexOf(e.range.getValue())]);
var targetSheetColumnAValues ​​= targetSheet.getRange (
/ * row * / 1,
/ * column * / 1,
/ * numRows * / targetSheet.getLastRow (),
/ * numColumns * / 2) .getDisplayValues ​​();
var row = targetSheetColumnAValues.length - 1;
while (row &&! (targetSheetColumnAValues[row][0], Length || targetSheetColumnAValues[row][1]Length)) {
Line--;
}
Line + = 1;
if (row <targetSheet.getFrozenRows ()) {
var error = & # 39; moveRowsFromSheetToSheet_ () found an incorrectly formatted target column on sheet "+ targetSheet.getName () +" (row = & # 39; + row + & # 39;). & # 39 ;;
SpreadsheetApp.getActive (). Toast (error, & # 39; error & # 39 ;, 20);
throw a new error (error);
}
var targetRange = targetSheet.getRange (line + 1, 1);
sheet.getRange (e.range.getRow (), 1, 1, sheet.getLastColumn ()). moveTo (targetRange);
targetRange.offset (/ * line * / 0, / * column F * / 6 - 1) .clearContent (); // delete the value in column F for the matrix formula to work
sheet.deleteRow (e.range.getRow ());
}

[WTS] # 1 Stable Webhosting Plans | DailyRazor.com

Do you need reliable and superfast Linux and Windows web hosting?

DailyRazor.com is a provider of professional web hosting and other web services such as domain names, e-commerce, web design, search engine optimization and marketing, graphics and consulting for small businesses and individuals around the world.

We have more than 15 years of experience in Java, .NET, PHP, Ruby, CGI, network administration, systems integration and related technologies to support mission-critical hosting for applications based on these platforms. In addition, we offer web hosting packages to support popular technologies such as Perl, Python, and Ruby, as well as database support for the ever-growing and popular Microsoft Access, Microsoft SQL Server, MySQL, and PostgreSQL databases.

Our features:

  • Professional support around the clock
  • 30-day money-back guarantee
  • 99.9% availability guarantee
  • Fast and fast server infrastructure
  • 1-Click App Installer (hundreds to choose from)
  • Award Winning Web Hosting
  • Over 15 years experience in Linux and Windows hosting

Our Web Hosting Plans should contribute to the success of your website! We offer an instant installation software called Softaculous, which allows you to automatically install over 276 open source scripts with a mouse click. You can install WordPress, Joomla, OpenCart, PrestaShop, PHPBB, Drupal, SMF, MyBB, Magento, Dolphin, OpenBlog, TextPattern, LifeType, etc. in one click!

NoteEach hosting plan includes: disk space, bandwidth, email accounts, FTP accounts as much as you need + FREE domain name.

Dailyrazor also offers Tomcat hosting, Joomla hosting, OpenCart hosting and vBulletin hosting Solutions!

Use code: SUPER SHARED and get up 60.40% OFF on all hosting plans!

Starter
1 website / domain
10 databases
Free Domain Domain
FREE Website Builder
FREE SSL security
cPanel Control Panel
3.15 USD / month 60.40% DISCOUNT (previously 7.95 USD) – ORDER NOW
Click here for more plans and details: https://www.dailyrazor.com/web-hosting/

Our Superior ASP.NET hosting Plans should contribute to the success of your website!
Use code: SUPER SHARED and get up 60.40% OFF on all hosting plans!

Starter
1 website / domain
10 databases
Free Domain Domain
FREE Website Builder
FREE SSL security
cPanel Control Panel
3.94 USD / month 60.40% DISCOUNT (previously 9.95 USD) – ORDER NOW
Click here for more plans and details: https://www.dailyrazor.com/asp-net-hosting/

Our Ultimate Reseller Hosting Plans should contribute to the success of your website!
Use code: SUPERRESELL and get up 10% REDUCED on all reseller hosting plans!

bronze
Host unlimited domains / websites
25 GB hard disk space
250 GB transfer / bandwidth
WHM / cPanel Control Panel
11.65 USD / month 10.00% DISCOUNT (previously 12.95 USD) – ORDER NOW
Click here for more plans and details: https://www.dailyrazor.com/reseller-hosting/

Our Expert ColdFusion Hosting Plans should contribute to the success of your website!
Use code: CFPRIMO and get up REDUCED BY 50 PERCENT on all ColdFusion hosting plans!

CF-One
1 website / domain
1 MS SQL database
5 MySQL databases
FREE domain name
Plesk Control Panel
7.98 USD / month 50% DISCOUNT (previously $ 15.95) – ORDER NOW
Click here for more plans and details: https://www.dailyrazor.com/coldfusion-hosting/

We also offer a robust one-click application installation software that integrates with our Plesk Control Panel, allowing you to automatically install tons of open source scripts with a mouse click. You can install WordPress, Joomla, OpenCart, PrestaShop, PHPBB, Drupal, SMF, MyBB, Magento, Dolphin, OpenBlog, TextPattern, LifeType, etc. in one click!

Our guarantee:
Try one of our hosting packages FREE for 30 days! We let our quality service speak for us and if you are not satisfied with our service, just contact us to cancel before or on the 30th day. We will refund your deposited amount without further questions!

If you have any questions, please contact Contact our support: Submit ticket

Like DailyRazor FACEBOOK SITE
Follow DailyRazor over TWITTER ACCOUNT

,

Local Scripts for Exchange of Cryptocurrencies – Blockchain App Factory – Corner of Cryptocurrencies

Several advantages of trading in local bitcoins, including trading speed, fiduciary protection and the updated pricing system, led to the creation of the local Bitcoin clone. Local scripts for exchanging cryptocurrencies The app provided by Blockchain App Factory gives you the ability to buy and sell cryptocurrency through P2P trades for profit.

Worksheet function – Excel 2016 (64-bit) Last cell at the very end of the sheet, not enough memory to delete / VBA scripts did not work

I would be very happy if someone could help me to understand what is going on here. The sheet in question contains ~ 15000 rows and ~ 300 columns, and the workbook itself contains ~ 20 sheets, all of which are linked together.

When I press CTRL + END, the last cell in row ~ 1,000,000 and column XFD – basically the bottom right corner of the sheet, will appear.

Unfortunately, this file is maintained for years and it is not possible to revise the whole thing.

I looked around and tried a bunch of solutions that did not work, and I listed them below:

  • It can not be copied and pasted into a new sheet because of complexity issues, so this method is not a problem
  • Changed the size of rows and columns and tried to delete them in this way
  • VBA script used: Activesheet.UsedRange

All that was required to highlight a series of rows / columns and perform an action caused me to make a memory error.

I also made sure to save the file and reopen it to see if the last cell was changed, without success. Does anyone have any ideas?

So you can remove all design styles and scripts or cancel their registration

Maybe this will help you. To attempt

# To delete JavaScripts
Function remove_unnecessary_scripts () {
# pass name of the quoted js.
# dequeue js
wp_dequeue_script (& # 39; toaster-js & # 39;);
# unsubscribe js
wp_deregister_script (& # 39; toaster-js & # 39;);
}
add_action (& # 39; wp_print_scripts & # 39 ;, & # 39; remove_unnecessary_scripts & # 39;);

# Remove for styles from the queue
Function remove_unnecessary_styles () {
# pass Name of the stylesheet in the queue.
# dequeue style
wp_dequeue_style (& # 39; custom-style & # 39;);
Log off # style
wp_deregister_style (& # 39; custom-style & # 39;);
}
add_action (& # 39; wp_print_styles & # 39 ;, & # 39; remove_unnecessary_styles & # 39;);

Let me know if it works or not.

php – Disable third-party composer scripts when using composer.phar.

We have a MediaWiki update process under website | mediawiki-install.txt. MediaWiki requires the use of developer tools such as Composer on a production server. It's a bad idea, but we can not change it.

In step 7, we need to execute composers and update dependencies.

php -d extension = phar.so composer.phar update

When the command is executed, the following error is thrown:

# php -d extension = phar.so composer.phar update
Do not run Composer as root / superuser! For more information, visit https://getcomposer.org/root
> ComposerHookHandler :: onPreUpdate
Load Composer repositories with package information
Update dependencies (including require-dev)
...

According to https://getcomposer.org/root the fix is:

composer install --no-plugins --no-scripts ...
Composer Update --no-Plugins --no scripts ...

I tried to investigate composer.phar However, to see what options we have is binary data:

# grep & # 39; composer & # 39; composer.phar
Binary file composer.phar matches
# File composer.phar
composer.phar: data

My question is how we run composer.phar and make sure the source file does what is recommended?

[WTS] Webhosting in Europe [NL]; cPanel, Softaculous, WebSiteBuilder | starting at $ 1.95 per month

VPSGet has the vision to provide every customer with high quality services at affordable prices.

Our servers are located in the Tier III data center in the Netherlands, Europe.
All our shared webhosting packages are cPanel based +Softaculous + WebSiteBuilder. With Softaculous With just a few clicks you can install many scripts on your website (WordPress, Joomla, OpenCart, phpBB, Drupal, .. and many other ~ 412 scripts).

Properties:• Free Managed Service *
• SSD-based RAID 10 storage
• Xeon E5 processors
• Automatic backups on external storage included.
• Weekly malware and rootkit scan; + ClamAV
• SSH access available
• Softaculous 1click app is being installed
• cPanel
• Website creator
• WHM dealer access [upon request]
• 99.9% availability guarantee
• 30-day money back guarantee
• No contract
• 24×7 support (in-house team)
• LiveChat during the day.
Many payment methods accepted: Bitcoin, Paypal, Credit / Debit Cards, 2checkout, Payza, BankWire. Altcoins are also accepted: Litecoin, Ethereum, Zcash, Monero etc.

SH-1
$ 1.95 per month
2 GB of hard disk space
500 GB bandwidth
5 websites
3 databases
cPanel
Softaculous
30-day money-back guarantee
More info / Compare

SH-2
$ 3.25 per month
10 GB of storage space
1TB bandwidth
Unlimited websites
Unlimited databases
cPanel
Softaculous
SSH access available
30-day money-back guarantee
More info / Compare

SH-3
$ 5.25 per month
20 GB of hard disk space
2 TB bandwidth
Unlimited websites
Unlimited databases
cPanel
Softaculous
SSH access available
Additional ipv4 available
30-day money-back guarantee
More info / Compare

SH-4
$ 15.75 per month
60 GB hard disk space
4 TB bandwidth
Unlimited websites
Unlimited databases
cPanel
Softaculous
SSH access available
1 ipv4 included
Additional ipv4 available
30-day money-back guarantee
More info / Compare

____________________________

If you have questions before buying, please do not hesitate Contact our sales team!

,

★★★ cPanel Hosting ★★★ Hundreds of scripts, Cloudflare, Google's G Suite

$ 8.88 ★ cPanel Hosting Power SPECIAL ★ (16 years in business!)

Host your domain with cPanel Hosting Panel and over 700 freely available scripts like WordPress, Joomla, Blog Scripts, Shopping Carts, Message Boards, Customer Support Panels, Forums, Social Scripts etc. And of course Webmail, Stats, MySQL Databases, a selection of PHP 5.4, 5.5, 5.6 and 7.x and more. SSL certificate included! Data Center locations: USA or GERMANY, your choice! SPECIAL OFFER ONLY HERE (under the login link (s)).

We are a certified Cloudflare partner. In this way, you and your customers (via the cPanel control panel) of each domain can enable the use of Cloudflare, thereby speeding up the loading of your websites by about 5%. 60% while increasing security, protecting against DDoS and reducing SPAM attacks.

L3server also offers VPS and fully managed new SuperMicro servers in Europe, Level (3) Data Center in Hamburg and, alternatively, in the US. Best, most reliable infrastructure and network with excellent connectivity in Europe, Russia, the Middle East and Africa (and definitely the US)!

Take a look at our permanent SPECIAL cPanel domain hosting offers

L3server cPanel multi-domain hosting

Only $ 8.88 / month … with all the bells and whistles the advanced hosting technology has to offer … multiple PHP versions (including PHP 7.x) and over 700 scripts.,

All plans come with two free script installers (Fantastisco & Softaculous), which install hundreds of scripts at the click of a mouse.

Google's "G Suite" Plan can be added and combined with our hosting; Sign up for $ 4.99 on our website with the business apps Calendar, Hangouts, Gmail, Google+, Drive, Documents, Sheets, Forms, Slides, Websites, Safe, Groups, Safe, Keep, and Google Cloud Search.

We have been in business for over 16 years.

We accept credit cards, PayPal, Skrill, Paysafecard, US bank transfer, EU bank transfer (SOFORT / Klarna), Bitcoin and other cryptocurrencies (Ethereum, Ripple, Litecoin etc.), Dotpay, Alipay (支付 支付), UnionPay (中国 中国) ), WeChat Pay (微 信 支付), Faktura.ru (Интернет-банк), Alfa-Click (Альфа-клик), Sberbank (Сбербанка), POLi Payments, Bancomer Mxico, Banamex (Banco Nacional de Mx other local payment methods.

Many Thanks!
John

Search server for outdated scripts

Such scripts are typically loaded as part of an operating system package, CMS, or plug-in / module / extension. Since updating the scripts by themselves would most likely cause problems, it is more common to check and update them with apt at a higher level / yum, tools such as Softaculous, Drush, and so on. These scripts also handle database updates and dependencies.

I'm not aware of any tools that can scan a whole server. This question has already been asked here.