Programa de Gestion de Taller

[Naota]

Buenas:
soy nuevo en esto y la verdad lo encuentro bastante útil el uso de Mit App.
deseo hacer un programa de gestión y mis conocimientos son bastante reducidos en lo que respecta a programación.
así que uso IA para hacer código e implementarlo vía web.

hasta le momento mi codigo va asi:

var ssId = "HOJA ASIGNADA";

function doGet(e) {
  if (!e || !e.parameter) {
    return ContentService.createTextOutput("").setMimeType(ContentService.MimeType.TEXT);
  }

  var accion = e.parameter.accion; 
  var placa = e.parameter.placa;

  if (!accion || accion !== "consultar" || !placa) {
    return ContentService.createTextOutput("").setMimeType(ContentService.MimeType.TEXT);
  }

  var datos = buscar(accion, placa); 
  if (datos.length === 0) {
    return ContentService.createTextOutput("").setMimeType(ContentService.MimeType.TEXT);
  }

  var respostaJSON = JSON.stringify(datos);
  return ContentService.createTextOutput(respostaJSON).setMimeType(ContentService.MimeType.JSON);
}

function buscar(accion, placa) {
  var sh = SpreadsheetApp.openById(ssId);
  var hoja = sh.getSheetByName('Respuestas'); // Accedemos a la hoja llamada 'Respuestas'

  if (!hoja) {
    return [];
  }

  if (accion === "consultar") {
    var datos = hoja.getDataRange().getValues();
    var resultados = [];

    for (var i = 0; i < datos.length; i++) {
      var fila = datos[i];
      var valorColumnaD = fila[3]; // Índice 3 corresponde a la columna D (PLACA)

      if (valorColumnaD == placa) {
        resultados.push({
          "OT": fila[1],             // Columna B
          "FECHA": fila[2],          // Columna C
          "PLACA": fila[3],          // Columna D
          "TECNICO": fila[4],        // Columna E
          "MODELO": fila[6],         // Columna G
          "TRABAJO": fila[7],        // Columna H
          "MANTENIMIENTO": fila[8],  // Columna I
          "ESTADO": fila[9]          // Columna J
        });
      }
    }

    return resultados;
  }

  return [];
}

Logrando a devolver mas de un solo valor en caso de encontrar mas de una coincidencia en placa.
el problema surge cuando quiero visualizar el resultado

arrojándome lo siguiente

no se en que estoy fallando

cualquier ayuda es bienvenida, gracias

[TIMAI2]

Show your complete response content in a label and report back with it here

[Naota]

Buenas, gracias por tu aporte pero el problema continua a pesar de usar una etiqueta para mostrar el resultado.

En si la aplicación web cumple lo que se espera, pero aún no logro mostrar ello en una etiqueta o lista (lo cual fuera ideal).

Dejo un ejemplo respecto a lo que se obtiene por medio de la aplicación web.

[TIMAI2]

The error message shows that you are receiving html back in your response

not a fully formatted json string

We need to see the full html being returned, which will hopefully indicate the error being generated by the google apps script.

[TIMAI2]

@Naota

use AI to make code and deploy it via the web

You cannot rely on AI to be completely accurate when providing instructions for AppInventor / Google Apps Script. It would be better to consult tutorials for both!

[Naota]

https://script.googleusercontent.com/macros/echo?user_content_key=l179U4iuN1048WmLeUljdxknrnpRk1DhOEj4soFWoWeBFpda-u_i3HotjFWeDKvUIDNB0wGWNnIg1ftQfD5dWXmymd7P3vpHOJmA1Yb3SEsKFZqtv3DaNYcMrmhZHmUMWojr9NvTBuBLhyHCd5hHaySl3VmcE6PimAScoypP3jJKjCflLVOgGMd08oc5IZgLtLiLZsPhDEt6JsMi3xt9UscQ-4vZhlInuu1Lp760tRk5hu-MRFPpxLtt5KlkUDl4-VpqExZPZAs0Ve5jl97pz6ioI9ws62ahk-OpaQv_pU8&lib=MbEdZp-TiluD4azkog41LNxY_38wU5Na4

Ese es la full url que devuelve en respuesta

[Naota]

Si lo sé, pero no soy muy partidario del uso de tutoriales en inglés.
Además de no encontrar personas que tienen este tipo de problemas y que estén en la disposición de ayudar.
Es por ello que aprecio el feedback.

[TIMAI2]

You have provided a url, not the html output being generated by the script in your response content

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

[Naota]

Primeramente
Gracias por compartir tu hilo.

Segundo.
Lo que me genera en "teoría" es una linea de comando jSon dónde están todos los datos de la fila.
(Datos en fila y encabezado).

[TIMAI2]

"theory" is no good, we need in practice....

You could also show the call you are making to your google apps script

[Naota]

La llamada está estructurada así.

Francamente no entiendo porque sigue el error.

[TIMAI2]

Should have asked for the call earlier

Looking at your script, you need to be sending at least two parameters to it, you only seem to be "trying to send" the contents of a textbox.

Url structure should be:

https://<scriptUrl -  ending with - /exec>?accion=<value>&placa=<value>

[Naota]

vaya, no me habia percatado que el campo de accion debia ser definidio, gracias por hacermelo notar.

redefino el scrip:]

var ssId = "HOJA DE CALCULO";

function doGet(e) {
  if (!e || !e.parameter) {
    return ContentService.createTextOutput("")
      .setMimeType(ContentService.MimeType.TEXT);
  }

  var placa = e.parameter.placa;

  if (!placa) {
    return ContentService.createTextOutput("")
      .setMimeType(ContentService.MimeType.TEXT);
  }

  var datos = buscar(placa); 

  var respostaJSON = JSON.stringify(datos);
  return ContentService.createTextOutput(respostaJSON)
    .setMimeType(ContentService.MimeType.JSON);
}

function buscar(placa) {
  var sh = SpreadsheetApp.openById(ssId);
  var hoja = sh.getSheetByName('Respuestas'); // Accedemos a la hoja llamada 'Respuestas'

  if (!hoja) {
    return [];
  }

  var datos = hoja.getDataRange().getValues();
  var resultados = [];

  // Recorrer todas las filas para buscar coincidencias en la columna D (PLACA)
  for (var i = 0; i < datos.length; i++) {
    var fila = datos[i];
    var valorColumnaD = fila[3]; // Índice 3 corresponde a la columna D (PLACA)

    if (valorColumnaD == placa) {
      resultados.push({
        "OT": fila[1],             // Columna B
        "FECHA": fila[2],          // Columna C
        "PLACA": fila[3],          // Columna D
        "TECNICO": fila[4],        // Columna E
        "MODELO": fila[6],         // Columna G
        "TRABAJO": fila[7],        // Columna H
        "MANTENIMIENTO": fila[8],  // Columna I
        "ESTADO": fila[9]          // Columna J
      });
    }
  }

  return resultados;
}

Ahora si acepta el tipo de respuesta pero aun sigo teniendo problemas para visualizarlo.

https://script.google.com/macros/s/AKfycbxKZ4zZWS9pMlJ8F7UsDKmliS_iYelYBfttE6w4VshAXgWMHredBTq78j7eIZjPf1Cs1Q/exec?placa=[placa]

[TIMAI2]

At Last

This, but all of it, is what we need to see:

[Naota]

Pero no es necesario usar el decodificador de textojson para poder sacar lo que deseamos mostrar?

Porque hasta donde yo veo es una dirección httml lo UE se muestra en la etiqueta.
O como hago para solo mostrar los datos de modelo correspondiente a la búsqueda en la etiqueta?

[Taifun]

@Naota

Pero no es necesario usar el decodificador de textojson para poder sacar lo que deseamos mostrar?

yes, but currently you get an error message back...
first you have to understand the error message before fixing the issue and get a correct result back...
unfortunately you are truncating the error message, so we still do not know, what the error is about

Taifun

[Naota]

Mis disculpas.
Selecciono y copio todo tal y como aparece.

<!doctype html>c-wiz{contain:style}c-wiz>c-data{display:none}c-wiz.rETSD{contain:none}c-wiz.Ubi8Z{contain:layout style}@-webkit-keyframes quantumWizBoxInkSpread{0%{-webkit-transform:translate(-50%,-50%) scale(0.2);-webkit-transform:translate(-50%,-50%) scale(0.2);-ms-transform:translate(-50%,-50%) scale(0.2);-o-transform:translate(-50%,-50%) scale(0.2);transform:translate(-50%,-50%) scale(0.2)}to{-webkit-transform:translate(-50%,-50%) scale(2.2);-webkit-transform:translate(-50%,-50%) scale(2.2);-ms-transform:translate(-50%,-50%) scale(2.2);-o-transform:translate(-50%,-50%) scale(2.2);transform:translate(-50%,-50%) scale(2.2)}}@keyframes quantumWizBoxInkSpread{0%{-webkit-transform:translate(-50%,-50%) scale(0.2);-webkit-transform:translate(-50%,-50%) scale(0.2);-ms-transform:translate(-50%,-50%) scale(0.2);-o-transform:translate(-50%,-50%) scale(0.2);transform:translate(-50%,-50%) scale(0.2)}to{-webkit-transform:translate(-50%,-50%) scale(2.2);-webkit-transform:translate(-50%,-50%) scale(2.2);-ms-transform:translate(-50%,-50%) scale(2.2);-o-transform:translate(-50%,-50%) scale(2.2);transform:translate(-50%,-50%) scale(2.2)}}@-webkit-keyframes quantumWizIconFocusPulse{0%{-webkit-transform:translate(-50%,-50%) scale(1.5);-webkit-transform:translate(-50%,-50%) scale(1.5);-ms-transform:translate(-50%,-50%) scale(1.5);-o-transform:translate(-50%,-50%) scale(1.5);transform:translate(-50%,-50%) scale(1.5);opacity:0}to{-webkit-transform:translate(-50%,-50%) scale(2);-webkit-transform:translate(-50%,-50%) scale(2);-ms-transform:translate(-50%,-50%) scale(2);-o-transform:translate(-50%,-50%) scale(2);transform:translate(-50%,-50%) scale(2);opacity:1}}@keyframes quantumWizIconFocusPulse{0%{-webkit-transform:translate(-50%,-50%) scale(1.5);-webkit-transform:translate(-50%,-50%) scale(1.5);-ms-transform:translate(-50%,-50%) scale(1.5);-o-transform:translate(-50%,-50%) scale(1.5);transform:translate(-50%,-50%) scale(1.5);opacity:0}to{-webkit-transform:translate(-50%,-50%) scale(2);-webkit-transform:translate(-50%,-50%) scale(2);-ms-transform:translate(-50%,-50%) scale(2);-o-transform:translate(-50%,-50%) scale(2);transform:translate(-50%,-50%) scale(2);opacity:1}}@-webkit-keyframes quantumWizRadialInkSpread{0%{-webkit-transform:scale(1.5);-webkit-transform:scale(1.5);-ms-transform:scale(1.5);-o-transform:scale(1.5);transform:scale(1.5);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}@keyframes quantumWizRadialInkSpread{0%{-webkit-transform:scale(1.5);-webkit-transform:scale(1.5);-ms-transform:scale(1.5);-o-transform:scale(1.5);transform:scale(1.5);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}@-webkit-keyframes quantumWizRadialInkFocusPulse{0%{-webkit-transform:scale(2);-webkit-transform:scale(2);-ms-transform:scale(2);-o-transform:scale(2);transform:scale(2);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}@keyframes quantumWizRadialInkFocusPulse{0%{-webkit-transform:scale(2);-webkit-transform:scale(2);-ms-transform:scale(2);-o-transform:scale(2);transform:scale(2);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}.JnOM6e{background-color:transparent;border:none;border-radius:4px;-webkit-box-sizing:border-box;box-sizing:border-box;display:inline-block;font-size:14px;height:36px;letter-spacing:.15px;line-height:34px;padding:0 24px;position:relative;text-align:center}.JnOM6e:focus-visible{outline:none;position:relative}.JnOM6e:focus-visible::after{border:2px solid rgb(24,90,188);border-radius:6px;bottom:-4px;-webkit-box-shadow:0 0 0 2px rgb(232,240,254);box-shadow:0 0 0 2px rgb(232,240,254);content:"";left:-4px;position:absolute;right:-4px;top:-4px}.rDisVe:focus:not(:focus-visible),.GjFdVe:focus:not(:focus-visible){-webkit-box-shadow:0 1px 1px 0 rgba(66,133,244,.3),0 1px 3px 1px rgba(66,133,244,.15);box-shadow:0 1px 1px 0 rgba(66,133,244,.3),0 1px 3px 1px rgba(66,133,244,.15)}.rDisVe:hover:not(:focus-visible),.GjFdVe:hover:not(:focus-visible){-webkit-box-shadow:0 1px 1px 0 rgba(66,133,244,.45),0 1px 3px 1px rgba(66,133,244,.3);box-shadow:0 1px 1px 0 rgba(66,133,244,.45),0 1px 3px 1px rgba(66,133,244,.3)}.JnOM6e:disabled{pointer-events:none}.JnOM6e:hover{cursor:pointer}.JnOM6e.kTeh9{line-he

[TIMAI2]

Don't know where you got that from, but it is not the same as the one you show in the screenshot, it is not the error message coming back from the google apps script.

[Naota]

Verdad.
Verifico y vuelvo a enviar.

[Naota]

Ok ahora creo que engo lo correcto.
Use la IA para saber ue está pasando y me indica que es un problema de acceso.

Quedé desconcertado
Una mano, por acá?

PD agrego screen de pantalla, por alguna razón se modifica el post.

<!doctype html>c-wiz{contain:style}c-wiz>c-data{display:none}c-wiz.rETSD{contain:none}c-wiz.Ubi8Z{contain:layout style}@-webkit-keyframes quantumWizBoxInkSpread{0%{-webkit-transform:translate(-50%,-50%) scale(0.2);-webkit-transform:translate(-50%,-50%) scale(0.2);-ms-transform:translate(-50%,-50%) scale(0.2);-o-transform:translate(-50%,-50%) scale(0.2);transform:translate(-50%,-50%) scale(0.2)}to{-webkit-transform:translate(-50%,-50%) scale(2.2);-webkit-transform:translate(-50%,-50%) scale(2.2);-ms-transform:translate(-50%,-50%) scale(2.2);-o-transform:translate(-50%,-50%) scale(2.2);transform:translate(-50%,-50%) scale(2.2)}}@keyframes quantumWizBoxInkSpread{0%{-webkit-transform:translate(-50%,-50%) scale(0.2);-webkit-transform:translate(-50%,-50%) scale(0.2);-ms-transform:translate(-50%,-50%) scale(0.2);-o-transform:translate(-50%,-50%) scale(0.2);transform:translate(-50%,-50%) scale(0.2)}to{-webkit-transform:translate(-50%,-50%) scale(2.2);-webkit-transform:translate(-50%,-50%) scale(2.2);-ms-transform:translate(-50%,-50%) scale(2.2);-o-transform:translate(-50%,-50%) scale(2.2);transform:translate(-50%,-50%) scale(2.2)}}@-webkit-keyframes quantumWizIconFocusPulse{0%{-webkit-transform:translate(-50%,-50%) scale(1.5);-webkit-transform:translate(-50%,-50%) scale(1.5);-ms-transform:translate(-50%,-50%) scale(1.5);-o-transform:translate(-50%,-50%) scale(1.5);transform:translate(-50%,-50%) scale(1.5);opacity:0}to{-webkit-transform:translate(-50%,-50%) scale(2);-webkit-transform:translate(-50%,-50%) scale(2);-ms-transform:translate(-50%,-50%) scale(2);-o-transform:translate(-50%,-50%) scale(2);transform:translate(-50%,-50%) scale(2);opacity:1}}@keyframes quantumWizIconFocusPulse{0%{-webkit-transform:translate(-50%,-50%) scale(1.5);-webkit-transform:translate(-50%,-50%) scale(1.5);-ms-transform:translate(-50%,-50%) scale(1.5);-o-transform:translate(-50%,-50%) scale(1.5);transform:translate(-50%,-50%) scale(1.5);opacity:0}to{-webkit-transform:translate(-50%,-50%) scale(2);-webkit-transform:translate(-50%,-50%) scale(2);-ms-transform:translate(-50%,-50%) scale(2);-o-transform:translate(-50%,-50%) scale(2);transform:translate(-50%,-50%) scale(2);opacity:1}}@-webkit-keyframes quantumWizRadialInkSpread{0%{-webkit-transform:scale(1.5);-webkit-transform:scale(1.5);-ms-transform:scale(1.5);-o-transform:scale(1.5);transform:scale(1.5);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}@keyframes quantumWizRadialInkSpread{0%{-webkit-transform:scale(1.5);-webkit-transform:scale(1.5);-ms-transform:scale(1.5);-o-transform:scale(1.5);transform:scale(1.5);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}@-webkit-keyframes quantumWizRadialInkFocusPulse{0%{-webkit-transform:scale(2);-webkit-transform:scale(2);-ms-transform:scale(2);-o-transform:scale(2);transform:scale(2);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}@keyframes quantumWizRadialInkFocusPulse{0%{-webkit-transform:scale(2);-webkit-transform:scale(2);-ms-transform:scale(2);-o-transform:scale(2);transform:scale(2);opacity:0}to{-webkit-transform:scale(2.5);-webkit-transform:scale(2.5);-ms-transform:scale(2.5);-o-transform:scale(2.5);transform:scale(2.5);opacity:1}}.JnOM6e{background-color:transparent;border:none;border-radius:4px;-webkit-box-sizing:border-box;box-sizing:border-box;display:inline-block;font-size:14px;height:36px;letter-spacing:.15px;line-height:34px;padding:0 24px;position:relative;text-align:center}.JnOM6e:focus-visible{outline:none;position:relative}.JnOM6e:focus-visible::after{border:2px solid rgb(24,90,188);border-radius:6px;bottom:-4px;-webkit-box-shadow:0 0 0 2px rgb(232,240,254);box-shadow:0 0 0 2px rgb(232,240,254);content:"";left:-4px;position:absolute;right:-4px;top:-4px}.rDisVe:focus:not(:focus-visible),.GjFdVe:focus:not(:focus-visible){-webkit-box-shadow:0 1px 1px 0 rgba(66,133,244,.3),0 1px 3px 1px rgba(66,133,244,.15);box-shadow:0 1px 1px 0 rgba(66,133,244,.3),0 1px 3px 1px rgba(66,133,244,.15)}.rDisVe:hover:not(:focus-visible),.GjFdVe:hover:not(:focus-visible){-webkit-box-shadow:0 1px 1px 0 rgba(66,133,244,.45),0 1px 3px 1px rgba(66,133,244,.3);box-shadow:0 1px 1px 0 rgba(66,133,244,.45),0 1px 3px 1px rgba(66,133,244,.3)}.JnOM6e:disabled{pointer-events:none}.JnOM6e:hover{cursor:pointer}.JnOM6e.kTeh9{line-he