Run a script in multiple google spreadsheets

See also questions close to this topic

• Accessing jasmine with testRunner set to jest-circus results in: ReferenceError: jasmine is not defined

  On default jest allows you to simply access jasmine globally. But as soon as you switch the testRunner to jest-circus, jasmine is undefined. Following is a minimal, reproducible example:

  babel.config.js

  module.exports = {
    presets: [["@babel/preset-env", { targets: { node: "current" } }]],
  };
  

  jasmine.spec.js

  it("check jasmine", () => {
    console.log(jasmine);
  });
  

  jest.config.js

  module.exports = {
    rootDir: ".",
    testRunner: "jest-circus/runner",
  };
  

  package.json

  {
    "name": "test-jest",
    "version": "1.0.0",
    "description": "",
    "main": "index.js",
    "scripts": {
      "test": "jest"
    },
    "author": "",
    "license": "ISC",
    "dependencies": {
      "@babel/core": "^7.12.10",
      "@babel/preset-env": "^7.12.11",
      "babel-jest": "^26.6.3",
      "jest": "^26.6.3",
      "jest-circus": "^26.6.3"
    }
  }
  

  Running this test will cause following output:

  $ npm test
  
  > test-jest@1.0.0 test /Users/yusufaran/Projects/test/test-jest
  > jest
  
   FAIL  ./jasmine.spec.js
    ✕ check jasmine (1 ms)
  
    ● check jasmine
  
      ReferenceError: jasmine is not defined
  
        1 | it("check jasmine", () => {
      > 2 |   console.log(jasmine);
          |               ^
        3 | });
        4 | 
  
        at Object.<anonymous> (jasmine.spec.js:2:15)
  
  Test Suites: 1 failed, 1 total
  Tests:       1 failed, 1 total
  Snapshots:   0 total
  Time:        1.01 s
  Ran all test suites.
  npm ERR! Test failed.  See above for more details.
  

  If you remove/comment the testRunner line in jest.config.js (so it fallbacks to the default runner) it works as expected.

  Question

  How can I access global jasmine object with testRunner set to jest-circus/runner? If I can't, why?
• Generate EV certificate to nodeJS server

  Hello everybody I have an angularJS project that hosted on GoDaddy, also I have server side using nodeJS by Gen4 VPS Linux from GoDaddy... I have a problem in my project that when I send request to the server I get reject because the server is self signed certificate and I need to accept the browser to log in to the server, Can somebody help me to get an certificate that will allow me to send request to the server without accepting it by the browser?

  const express = require('express');
  const cors = require('cors');
  var sql = require("mssql");
  const app = express();
  const bodyParser = require("body-parser");
  const https = require("https");
  const path = require("path");
  const fs = require("fs")
  
  app.use(cors())
  app.use(express.json()) 
  
  app.use(bodyParser.json({
      limit: '50mb'
    }));
    
    app.use(bodyParser.urlencoded({
      limit: '50mb',
      parameterLimit: 1000000,
      extended: true 
    }));
  
  ....
  
  
  const sslServer = https.createServer({
      key: fs.readFileSync(path.join(__dirname, 'cert', 'generated-private-key.pem.txt')),
      ca: [
          fs.readFileSync(path.join(__dirname, 'cert', '422f9963d338e48.crt')),
          fs.readFileSync(path.join(__dirname, 'cert', 'gd_bundle-g2-g1.crt'))
      ],
      cert: fs.readFileSync(path.join(__dirname, 'cert', 'generated-csr.pem.txt'))
  }, app)
  sslServer.listen(3443, () => console.log('Secure server is running on port 3443'))
  ....
  
• Using a variable for a createDrawerNavigation

  I am working on a simple React Native e-commerce app and i ran into a issue. I am trying to add the option to change the language, and it has worked so far with the Redux but now i need to dynamically change the sidebar menu and I cant because it is hardcoded as a prop.The code for the menu is this.

  const ShopNavigator = createDrawerNavigator(
    { 
      Produktetee: ProductsNavigator,
      Rezervimet: OrdersNavigator,
      Postoni: AdminNavigator},
    {
      contentOptions: {
        activeTintColor: MyColors.primary
      },
      contentComponent: props => {
        const {log_out} = useSelector(state =>  state.language)
     
        const dispatch = useDispatch();
        return (
          <View style={{ flex: 1, paddingTop: 50 }}>
            <SafeAreaView forceInset={{ top: "always", horizontal: "never" }}>
              <DrawerItems {...props} />
              <Button
                title={log_out}
                color={MyColors.primary}
                onPress={() => {
                  dispatch(authActions.logOut());
                  // props.navigation.navigate("Auth");
                }}
              />
               <View style={{flexDirection: 'row'}}>
   <View style={{flex:1 , marginRight:10, marginTop: 5,}} >
              <Button
                title="English"
                type="outline"
              
                color={MyColors.primary}
                onPress={()=>{
                  dispatch(index.selectLanguage(languages.english))
                }}
              />
              </View>
              <View style={{flex:1, marginTop: 5,}} >
              <Button
                title="Shqip"
                type="outline"
       
                color={MyColors.primary}
                onPress={()=>{
                  dispatch(index.selectLanguage(languages.albanian))
                }}
              />
              </View>
   </View>
            </SafeAreaView>
          </View>
        );
      }
    }
  );
  

  I am trying to use the hook, but I can't. If somebody could help me I would be very grateful.
• The salinity of soil and trace elements

  How coul I describe the salinity of soil and estimate the trace element as an affected factor on hydrological properties.
• Google Sheets converting Conditional Formatting to Apps Scripts

  I'm sure that there's not an easy way to do this, but I figured I would ask. I have a sheet that has a decent amount of conditional formatting on it, however, people that I share the sheet with have been copy/pasting and moving rows which aggravatingly disrupts the formatting. I am trying to convert to Scripting for them. The main thing is background colors based on other cell information.

  ie: if Any cell from row 4 from column A-D has information in it then the K4 will be red. Once K4 has information inside it then the background will be white.

  The conditional formatting I have is: =AND(OR(ISBLANK(A4)=FALSE,ISBLANK(B4)=FALSE,ISBLANK(C4)=FALSE,ISBLANK(D4)=FALSE),ISBLANK(K4)=TRUE).

  The other is that when any cell has a certain term "LWOS" then the whole row has a purple background and strikethrough.

  Thanks in advance.
• URL Fetch App doesn´t fetch the desired URL

  I´m trying to import data from Facebook mkt api into google sheets, however, there are some URL that seem to be working properly but there are others in which it returns the error of "Exception: Invalid argument:"

  The URL that works is this one: https://graph.facebook.com/v9.0/act_57968134*****?access_token=***********

  The URL that doesnt work is this one: https://graph.facebook.com/v9.0/act_57968134****?fields=campaigns{name}&access_token=***********

  enter image description here

  Does anybody know why this is happening? I tried other codes that I found in github but it´s the same, there is a problem with that specific URL...

  Thank you a lot
• Filling Google Forms with Google Sheets

  I have an HTML form which saves its responses to a Google Sheet. The form contains the following fields:

  Name:
  Email:
  Subject:
  Message:
  

  Now, what I want is I want to automate sending a thank you email to a recipient as soon as he/she fills the form to the address mentioned in the "Email" field. I don't want to use Google Forms as the backend as it is hard to bypass the "Response Recorded" Confirmation page. Also, avoiding PHP would be better for me!

  Is there a way to send these e-mails automatically? The format of the email is as follows:

  From: <my email address>
  To: <email address from the "Email" field in the spreadsheet>
  Subject: Re: Submission Received
  
  Hey <name from the "Name" field in the spreadsheet>!
  
  Body of the mail
  

  If there is a way to bypass the confirmation page of Google Forms, please let me know! That would also do!