Tag: script

How to run the Google Code script on all tabs

I used the script from this tutorial (https://developers.google.com/apps-script/articles/removing_duplicates) to remove duplicates from my Google spreadsheet, but this only works for the first tab (active). The scripts I found on the Internet to make it work on multiple tabs don't seem to be working, so I hope someone could help me with this:

/**
 * Removes duplicate rows from the current sheet.
 */

function removeDuplicates() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var newData = ();
  for (var i in data) {
    var row = data(i);
    var duplicate = false;
    for (var j in newData) {
      if (row.join() == newData(j).join()) {
        duplicate = true;
      }
    }
    if (!duplicate) {
      newData.push(row);
    }
  }
  sheet.clearContents();
  sheet.getRange(1, 1, newData.length, newData(0).length).setValues(newData);
}

/**
 * @OnlyCurrentDoc
 */

What is the most feature-rich and reliable alpha master reseller script?

I'm looking for a secure, feature-rich alpha master reseller script, currently I'm eyeing WHMAMP and Whmreseller.

Which of the two … | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1802427&goto=newpost

Google Sheets – Search for a script that automatically capitalizes all cells in a specified column

Looking around, I found different things, but I never found the place where you could specify the range, and I don't know this script.

Can someone show me a script for this? For example, all I need is to automatically capitalize each cell in column C.

I would appreciate any help. Thank you

Google Sheets – Search for a script that automatically capitalizes all cells in a specified column

Looking around, I found different things, but I never found the place where you could specify the range, and I don't know this script.

Can someone show me a script for this? For example, all I need is to automatically capitalize each cell in column C.

I would appreciate any help. Thank you

python – Is there any server side flask script to split into multiple files anyway?

I am running a flask server to develop a product, but as it gets bigger, I have to split the script in half, because a lot of data arrives per second on my server and because of this it becomes overloaded which makes it difficult to d & # 39; Other features to work properly.

7 – How to add the "onload" attribute to a script tag?

If you want to make sure your javascript is loaded in the header:

For drupal 7

/sites/default/themes/yourtheme/template.php

function theme_preprocess_html(&$var) {
      $path = $GLOBALS('base_url') . "https://drupal.stackexchange.com/" . path_to_theme() . '/js/yourscript-min.js';
      $script = array(
        '#tag' => 'script',
        '#attributes' => array(
            'type' => 'text/javascript',
            'src' => $path
        ),
        '#value' => '',
       );
       drupal_add_html_head($script, 'script');  
    }

or if you want to load it in the page:

function theme_preprocess_html(&$var) {
      $script = array(
        '#tag' => 'script',
        '#attributes' => array('type' => 'text/javascript'),
        '#value' => 'Add your javascript here',
       );
       drupal_add_html_head($script, 'script');  
    }

For drupal 8

In the yourtheme.libraries.yml file, you need to create a library like this:

yourtheme.libraries.yml

library-name:
  header: true
  js:
    js/yourSrctipForTheHeader.js: {}

Also in the theme.info.yml you need to add this library, then it will be automatically provided in the head tag and will be available before the page loads, if you delete header:true the script will be loaded after the page loads.

theme.info.yml

libraries:
  - yourtheme/library-name

Alternatively, you can use this module:
https://www.drupal.org/project/header_and_footer_scripts and place the scipts manually in the desired position. But to be honest, I think the first solution is the most elegant way.

WISECP has released version 2.1 of its web hosting billing script.

The WISECP.com team has released version 2.1 with many new features and improvements. Take a look at the changelog for this rel … | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1802224&goto=newpost

php – Execute a script on a remote server when there is a new entry in MySQL

For security reasons, I have 2 servers. In one, the website with all the user interface and the MySQL database is hosted, and in another, the application that will execute the script from the request of the application ; user is hosted. I need that, when the user makes a request via the website, this request is sent to the database on server 1 and sends the information to server 2 which will execute a script to the user inside the application with the information sent by the server 1. Here, I designed the structure to improve understanding: The structure

Is there a way to do it? Each new MySQL entry on server 1, server 2 runs a script?

setUnprotectedRanges () – Google Sheet – Script

I have a problem with the .setUnprotectedRanges script
I want the next tracks to be added in the loop. If the cell is not empty, another unlocked range must be added, which is in column 3. For example: in column 3, lines 5, 8 and 10 are not empty
the code below works but is not flexible

protection.setUnprotectedRanges (
                 (
                 spreadsheet.getRange ("A5: F5")
                 spreadsheet.getRange ("A8: F8")
                 spreadsheet.getRange ("A8: F8")
                 ))

Here is my code:

function xx(){
var app = SpreadsheetApp;
var as = app.getActiveSpreadsheet().getActiveSheet()
var sr = 6
var lr = as.getRange(4,2).getValue()
var spreadsheet = SpreadsheetApp.getActive();
var aa = ''

  for (var i=sr;i

How can I have different ranges added after a certain condition?

protection.setUnprotectedRanges (
                 (
                 spreadsheet.getRange ("A" + i + ": B" + i)
                 ))

Google Sheets – Application Script Help Please

I have multiple tabs that should run the script below, some tabs do not need to run the script. The script should only run if a salesperson from the corresponding tab makes a change. 

function addTimestamp(e){
  //variables
  var startRow = 2;
  var targetColumn = 3;

  //get modified row and column
  var row = e.range.getRow(); 
  var col = e.range.getColumn();   

  if(col === targetColumn && row >= startRow && e.source.getActiveSheet ().getName() === ws){

     e.source.getActiveSheet().getRange(row,6).setValue(new Date());
     e.source.getActiveSheet().getRange(row,13).setValue(new Date());

  if(e.source.getActiveSheet().getRange(row,3).getValue()==""){
     e.source.getActiveSheet().getRange(row,6).setValue("");
     e.source.getActiveSheet().getRange(row,13).setValue("");

}
} // END function addTimestamp
}

https://docs.google.com/spreadsheets/d/1XH7LmVBRyMgzotkEHfMYmPuq6Zse3M0sg_UAlsJOANI/edit#gid=0