What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by TalkNet 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
    JotForm Support

    Answered by ashwin_d 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!