Eingabetabelle Prefill

  • Azubiwerk
    Gefragt am 4. Oktober 2023 um 07:32

    You can answer in english:)

    Guten Tag sehr geehrtes Jotform Support Team,

    ich hoffe ihr habt einen angenehmen Mittwoch :)

    Ich habe eine Frage bezüglich des Prefills bei Eingabetabellen. Ich hatte gelesen, dass diese Option noch nicht möglich ist. Gibt es mittlerweile eine andere schlaue Idee die Daten Formular in Jotform Formular "TEST Übergabe Protokoll" in das theoretisch fast identische EIngabetabelle des Formulars "TEST Instandsetzung NICHT VERWENDEN" zu übertragen? Gerne am Beispiel des "Flurs" oder "Zimmer".

    Beste Grüße

    Leo Landowski

  • Lorelie Jotform Support
    Geantwortet am 4. Oktober 2023 um 10:38

    Hi Leo,

    Thanks for reaching out to Jotform Support. Unfortunately, our German Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in German, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. You can do that by using the


    Hello dear Jotform Support Team, I hope you have a pleasant Wednesday :) I have a question about prefilling input tables. I had read that this option is not yet possible. Is there now another clever idea to transfer the data form in the Jotform form “TEST handover protocol” into the theoretically almost identical input table of the “DO NOT USE TEST repair” form? Gladly using the example of the “hallway” or “room”.

    We have a Spreadsheet to form widget widget that you can use to import your data, but it won't populate the Product List field. Let me show you how to use it:

    • Create a spreadsheet that includes your data in the structure you see below. It's important that the column names in the spreadsheet and field names on the form are the same.

    1643012753 61ee6291bccef  Screenshot 40

    • In Form Builder, click on the Add Form Element menu on the left side of the page.
    • Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

    Eingabetabelle Prefill  Image 1 Screenshot 51

    • In the Widget Settings window that opens up, upload your data file and customize the other options. 
    • Then, click on Update Widget.

    Eingabetabelle Prefill  Image 2 Screenshot 62

    • In the final stage, add the fields to view values and name them the same as on the spreadsheet.

    Eingabetabelle Prefill  Image 3 Screenshot 73

    Give it a try and let us know if you need any help.