Can you add the data to tables and integrate it with a form?

  • Profile Image
    NYCADVANCE
    Asked on November 17, 2020 at 05:42 AM

    Can you add the data to tables and integrate it with a form? If headers match fields in Form will it auto populate?



    This is a re-post of a comment on How to Import Data in Jotform Tables

  • Profile Image
    Jed_C
    Answered on November 17, 2020 at 05:48 AM

    It is the opposite of what you are trying to accomplish. Instead of it sending the data from Tables to Form, it pulls data from the submitted form and post it on the tables page.

    I'm not sure what your workflow is, but if you can provide us with more details of what you are trying to achieve, we might be able to help and provide you a solution or suggestions.

    Looking forward for your response.

  • Profile Image
    Eduard Stach 
    Answered on November 19, 2020 at 11:47 AM

    Maybe we had the same requirement

    Use Case:

    We wanted to give collegues a form.
    And on the top is a search field where they can search for customer number which is already in the table.
    After entereing the customer number the rest of the form is filled with found information in the table about this customer.

    Do you have an idea for a solution?


  • Profile Image
    Anita_K
    Answered on November 19, 2020 at 01:56 PM

    Hi,

    for this, you are able to use our Spreadsheet to Form Widget.

    Please refer to this guide for more information:

    https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    Let us know if you have any questions.