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

  • tallerservimanpa
    Asked on October 24, 2019 at 1: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.

    Jotform Thread 2013810 Screenshot
  • Kevin Support Team Lead
    Replied on October 24, 2019 at 3: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.