Making a template/form like an Excel?

  • freedonx
    Asked on November 4, 2020 at 7:02 PM

    Hi, I recently see that Jotform now supports spreadsheet (excel type).
    But I'm not able to make a form like I have my local Excel file.

    Maybe I'm not looking into the same way or it's not what I think the new function can work like I think.

    Going to add 2 Excel screenshots of the files as a reference .

    It's much easier to fill out this information in an Excel than a new form on Jotform (which I already tried).
    What suggestions or orienation would you recommend?

    thanks!

    Jotform Thread 2680616 Screenshot
  • Lorenz JotForm Support
    Replied on November 4, 2020 at 10:10 PM

    Thank you for contacting us.

    Based on your screenshots, do you mean to change the look of the Spreadsheet view of the JotForm table to that layout? If so, altering the layout of the table is not possible.

    What you can do is download the submissions to excel, and separately make some changes to the excel file.

    Guide: https://www.jotform.com/help/73-how-to-download-form-submissions-as-excel-csv-pdf

    If you are referring to something else, please do let us know and provide more details.

  • freedonx
    Replied on November 7, 2020 at 1:18 AM

    Yeah what I would wish is for my end-user be able to fill out the jotform-spreadsheet-form like I have my excel files.


    Opposed to a traditonal jotform that I've used before, where I need to create every "line" and options, fill in the text, etc.

    Which is a brother for my end-user because it takes longer than compared to a simple Excel that you write each row with the same info and it's way faster than the form (using the keyboard for example to move between rows).


    Is that even possible even in some degree with jotforms (traditional or the spreadsheet types.


    thanks!

  • Kenneth JotForm Support
    Replied on November 7, 2020 at 2:03 AM

    Hi there,

    Unfortunately, the way JotForm works is for every field on the form corresponds to the columns of the spreadsheet, any changes made to the form like adding new fields will add a column in the spreadsheet to represent it.

    Let us know if you have any further questions.

    Best.