Home / user-264174

ZCH's questions

Martin Hope
ZCH
Asked: 2022-08-20 11:05:33 +0800 CST
  • 0

I'm learning node.js and I made a server that receives a get request, but is blocked by Cors policy. I am working with express and axios. I greatly appreciate your help.

I add my code below:

index.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <script src="https://cdn.jsdelivr.net/npm/axios/dist/axios.min.js"></script>
    <script>
        const puerto = 5555
        document.addEventListener('DOMContentLoaded', getData)
        async function getData() {
            let res = await axios.get(`http://localhost:${puerto}/jugadores`)
            json = await res.data;
            console.log(json)
        }
    </script>
</body>
</html>

servidor.js

const express = require('express')
const { jugadores } = require('./base-datos')
const app = express()

app.get('/jugadores',(req, res)=>{
    res.send(jugadores)
})
puerto = 5555
app.listen(puerto, () => {
    console.log(`Puerto ${puerto}. Escuchando ...`)
});

base-datos.js

let jugadores = [
    {
        "id": 1,
        "nombre": "Jugador1"

    },
    {
        "id": 2,
        "nombre": "Jugador2"

    }

]

module.exports.jugadores = jugadores

And these are the errors that I get in the console:

Access to XMLHttpRequest at 'http://localhost:5555/jugadores' from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.

Failed to load resource: net::ERR_FAILED

Uncaught (in promise) ocode: "ERR_NETWORK"config: {transitional: {…}, transformRequest: Array(1), transformResponse: Array(1), timeout: 0, adapter: ƒ, …}message: "Network Error"name : "AxiosError"request: XMLHttpRequest {data: undefined, onreadystatechange: null, readyState: 4, timeout: 0, withCredentials: false, …}response: XMLHttpRequest {data: undefined, onreadystatechange: null, readyState: 4, timeout: 0, withCredentials: false, …}[[Prototype]]: Error

javascript
Martin Hope
ZCH
Asked: 2022-08-02 20:44:22 +0800 CST
  • 2

I am making a Webapp and I collect the data from a form, I write it in a Sheets and there I process it with an array formula. The problem is that a row is increased at the end of the sheet, instead of being written to the first empty row. I can delete all the empty rows, but I need another way to do it without having to delete the rows. I add the code of a very simplified version of the Webapp:

//G.S.
function doGet () {
    return HtmlService.createTemplateFromFile('index').evaluate();};
function escribir (array){
  var ss = SpreadsheetApp.openById('').getSheetByName('Hoja 1');
  ss.getRange(ss.getLastRow()+1,1,1,array[0].length).setValues(array);};

indexHTML

<body> 
    <input type="number" id="numero1" value="">
    <input type="number" id="numero2" value="">
    <input type="button" id="btn" value="boton">
    <script type="text/javascript">
        btn.addEventListener('click',escribirPartida)
        function escribirPartida() {
           array = [[numero1.value, numero2.value]]
           console.log(array)
           google.script.run.escribir(array)}
    </script>  
  </body>

This is the result, instead of writing the data in the yellow row, it is written at the bottom of the sheet.

data is written to the bottom of the sheet and not to the first empty row

I tried to put a condition in the array function to make all the cells below it empty. This is the array function:=ArrayFormula(SI(A2:A+B2:B =0;"";A2:A+B2:B))

I need a way to limit the ArrayFormula so that the data is not written at the end. (I know that it can be done from the Script, but I need to do it from the sheets)

google-apps-script
Martin Hope
ZCH
Asked: 2022-07-27 14:49:16 +0800 CST
  • 0

I want to change the color of a radio button and a checkbox that have Materialize css styles. I want to change the green color to another color. I add the code:

 <!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title></title>
  </head>
  <body>
    
    <label>
         <input type="checkbox" />
         <span>Red</span>
    </label>
     <label>
        <input name="group1" type="radio" checked />
        <span>Red</span>
    </label>
    
         <!-- Compiled and minified CSS -->
         <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/css/materialize.min.css">

         <!-- Compiled and minified JavaScript -->
         <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/js/materialize.min.js"></script>
  </body>
</html>

This is the result: green checkbox radio button green

html
Martin Hope
ZCH
Asked: 2022-07-06 12:28:12 +0800 CST
  • 0

I'm making an HTML form with Materialize css, but I don't know how to make the checkboxand the remain on the same line. <input tipe="text">I add my HTML:

HTML
<div class="row section z-depth-2 ">
  <div class="col s3">
    <input type="checkbox" id='producto1'>
    <label for="producto1">Producto 1</label>
  </div>
  <div class="input-field col s9">
    <input type="number"  id="item" class="validate active">
    <label for="item" class="active">Cantidad</label>
  </div>
  <div class="col s3">
    <input type="checkbox" id='producto2'>
    <label for="producto2">Producto 2</label>
  </div>
  <div class="input-field col s9">
    <input type="number"  id="item2" class="validate active">
    <label for="item2" class="active">Cantidad</label>
  </div>
</div>

And this is the result, where you can see the checkbox above instead of being on the same line as the <input tipe="text">: enter image description here

html
Martin Hope
ZCH
Asked: 2022-06-13 20:05:29 +0800 CST
  • 0

I need to write several formulas in google sheets, through google apps script. So that the script is not very slow, I used setValues() and wrote the formulas (which are SUM and SUM.IF) as a string, but although they are written correctly in the sheets, it does not read them correctly and I get an error #¿NAME? ? I add a simplified example.

function escribirFormulas(){
  var ssHoja5 = SpreadsheetApp.openById('xxxx').getSheetByName('Hoja 5')
   var array = [['=SUMA(25+25)','=SUMA(2+2)'],['=SUMA(25+25)','=SUMA(2+2)']]
   ssHoja5.getRange('A1:B2').setValues(array)
}

show error in spreadsheet

google-apps-script