Hi, can I read the values ​​in a spreadsheet from Google sheets ins

  • Profile Image
    TalkNet
    Asked on June 10, 2017 at 03:29 AM

    Hi, can I read the values ​​in a spreadsheet from Google sheets instead of writing them in text form? So that they can be filled and modified automatically.

    Similarly: can I link a form text to a cell in a Google sheet spreadsheet to show a result based on what is completed in the form?

    Thank you

    Hola, puedo leer los valores de una hoja de calculo de Google sheets en lugar de escribirlos en forma de texto? De modo que se puedan llenar y modificar automáticamente.

    Del mismo modo: puedo vincular un texto del formulario a una celda de una hoja de calculo de Google sheet para mostrar un resultado en base a lo que se completo en el formulario?

    Gracias



    This is a re-post of a comment on How to Assign Calculation Value



    This is a re-post of a comment on How to Assign Calculation Value

  • Profile Image
    ashwin_d
    Answered on June 10, 2017 at 06:07 AM

    Hello,

    Unfortunately it is currenlty not possible to populate form fields from any external source or previous submission data of your form. The only option is to download your form's full source code and write you own code to read the values from your google spreadsheet and populate fields.

    I have moved your second question to a new thread so that we can address it separately. You will be answered in the following thread:  https://www.jotform.com/answers/1169370

    Thank you!