Skip to main content

How to set Day, Month and Year in a DatePicker Field in custom HTML forms - Apps Script

I don't know how to populate a Datepicker. I have a function "Edit data", when the user clicks on this button, a custom HTML form is opened and all the data of a spreadsheet is showing there. The part of the TextField was easy, was just TextField.value = data[1], but for type Date, I don't know how to do this, my code is that:

function pesquisarContrato(){

var dashboard = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Dashboard');
var planContrato = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Contratos');
var contrato = dashboard.getRange("G3").getValue();
if(contrato == ""){return false;}
var dados = planContrato.getRange(3,1, planContrato.getLastRow(), 27).getValues();

for(var linha = 0; linha<dados.length; linha++) {

  if(dados[linha][0] == contrato) {

      var dados_completos = {}

      dados_completos.id_contrato = dados[linha][0];
      dados_completos.licitacao = dados[linha][1];
      dados_completos.nsipac = dados[linha][2];
      dados_completos.objetivo = dados[linha][3];
      dados_completos.empresa = dados[linha][4];
      dados_completos.cnpj = dados[linha][5];

      //here, I get the day of data with custom function ToDate()
      dados_completos.inicioVigencia = toDate(linha,6)[0];
   
      return ([dados_completos.id_contrato, dados_completos.licitacao,
          dados_completos.nsipac, dados_completos.objetivo, 
          dados_completos.empresa, dados_completos.cnpj, 
          dados_completos.inicioVigencia])
    }

function toDate(linha, coluna){

    var planContrato = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Contratos');

    var dados = planContrato.getRange(3,1, planContrato.getLastRow(), 27).getValues();

    var d = Utilities.formatDate(new Date(dados[linha][coluna]), Session.getScriptTimeZone, "dd/MM/yyyy");
    var split = d.split('/');

    // Month is zero-indexed so subtract one from the month inside the constructor
    var date = new Date(split[2], split[1]-1,split[0]); //Y M D 
    var day = date.getDate();;
    var month = date.getMonth()+1;
    var year = date.getFullYear();

    var date_completa = {};

    date_completa.day = day;
    date_completa.month = month;
    date_completa.year = year;


    return ([date_completa.day, date_completa.month, date_completa.year])
}

HTML part:

<div class="row">
    <div class="input-field col s3">
        <input id="iniciogarantia" type="date" class="validate">
        <label for="iniciogarantia">Início da garantia</label>
    </div>
</div>

<script>

    google.script.run.withSuccessHandler(pesquisar).pesquisarContrato();

    var campoContrato = document.getElementById("contrato");
    var campoLicitacao = document.getElementById("licitacao");
    var campoSipac = document.getElementById("sipac");
    var campoObjetivo = document.getElementById("objetivo");
    var campoEmpresa = document.getElementById("empresa");
    var campoCnpj = document.getElementById("cnpj");
    var campoIniciovigencia = document.getElementById("iniciovigencia");

    function pesquisar(atualizar){

        campoContrato.value = atualizar[0];
        campoLicitacao.value = atualizar[1];
        campoSipac.value = atualizar[2];
        campoObjetivo.value = atualizar[3];
        campoEmpresa.value = atualizar[4];
        campoCnpj.value = atualizar[5]; 

        // this part have an issue, .value don't works for datepicker,
        // so how can I populate this field?
        //campoIniciovigencia.? = atualizar[6];

        M.updateTextFields();       
    }
</script>   

 
Via Active questions tagged javascript - Stack Overflow https://ift.tt/2FdjaAW

Comments

Popular posts from this blog

Why is my reports service not connecting?

I am trying to pull some data from a Postgres database using Node.js and node-postures but I can't figure out why my service isn't connecting. my routes/index.js file: const express = require('express'); const router = express.Router(); const ordersCountController = require('../controllers/ordersCountController'); const ordersController = require('../controllers/ordersController'); const weeklyReportsController = require('../controllers/weeklyReportsController'); router.get('/orders_count', ordersCountController); router.get('/orders', ordersController); router.get('/weekly_reports', weeklyReportsController); module.exports = router; My controllers/weeklyReportsController.js file: const weeklyReportsService = require('../services/weeklyReportsService'); const weeklyReportsController = async (req, res) => { try { const data = await weeklyReportsService; res.json({data}) console...

How to show number of registered users in Laravel based on usertype?

i'm trying to display data from the database in the admin dashboard i used this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count(); echo $users; ?> and i have successfully get the correct data from the database but what if i want to display a specific data for example in this user table there is "usertype" that specify if the user is normal user or admin i want to user the same code above but to display a specific usertype i tried this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count()->WHERE usertype =admin; echo $users; ?> but it didn't work, what am i doing wrong? source https://stackoverflow.com/questions/68199726/how-to-show-number-of-registered-users-in-laravel-based-on-usertype

The number of nodes and edges I calculated manually and by a method provided by networkx library dont match

I am trying to analyse a graph using networkx library in Python. I have implemented a function that returns the nodes and edges of that graph. After that I counted the number of nodes and edges by implementing the len() function for nodes and edges, which gave me 17 for both nodes and edges. However, when I used the method graph.number_of_nodes() of networkx library it gave me 53. My code: import pandas as pd import networkx as nx import matplotlib.pyplot as plt header_list = ["a","b","w"] E =pd.read_csv("aves-barn-swallow-contact-network.edges",sep=" ",header= None,names=header_list) # print(E.head()) # prints first few rows of the csv file G = nx.from_pandas_edgelist(E,"a","b",["w"]) nx.draw(G) plt.show() class GraphAnalyse: #finding nodes and edges def nodeEdge(self,Graph): nodes = Graph.nodes() edges = Graph.edges() ...