Is it possible to pull data from external resource and insert it into the Data Grid widget?

  • Profile Image
    tallerservimanpa
    Asked on October 24, 2019 at 01:41 PM

    Hola

    Necesito filtrar una hoja de datos por cliente para poder agregar datos al campo Horómetro de el cliente seleccionado.

    Como pueden orientarme con esto?

    Saludos.

  • Profile Image
    Kevin_G
    Answered on October 24, 2019 at 03:37 PM

    It's possible to pull data from a spreadsheet using our Spreadsheet to Form widget, here is a guide with more details about it: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    However, only few form fields are supported on this widget and the one you're using on your question "Datos de Equipos" is not supported. 

    An alternative would be to switch to using fields that are supported by the widget, I think you may create the table using a Text element and add the fields for each "Horómetro" as hidden, fill them with the data from the spreadsheet and then pass the fields to the table in the text field. 

    Here's a guide that will help you passing data from fields to a text element: https://www.jotform.com/help/418-Pass-an-Input-Field-to-a-Text-Element

    I hope this helps.