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

    jotform with spreadsheet options

    Asked by dothanby on September 18, 2014 at 12:57 PM

    On this form http://form.jotform.us/form/42574300558151

    at very bottom is a spread sheet. How can I change the column letters to text and also on row from numbers to test?

    Instead of "A" I want Creditors as an example

    Page URL:
    http://form.jotform.us/form/42574300558151

    JotForm spreadsheet jotform spreadsheet jotform excel excel
  • Profile Image

    Answered by Ben on September 18, 2014 at 02:11 PM

    Hi,

    The spreadsheet widget can unfortunately not be used in that manner. The column and row headers are pre-set and can not be changed, but there might be other ways to do this.

    Can you please tell me few more details?

    Are you looking to have this widget populated by others or just to show it to them instead?

    If you are looking to just show them data in a spreadsheet like manner then 'Data Grid' widget would be a preferred option. You can see it here http://widgets.jotform.com/widget/data_grid or you can add it to your form through Widgets menu on the left

    You can see it on the right already filled out (a wizard screen will show as soon as you place it on your jotform).

    Now if you are looking to be able to set headers and be able to add values in the fields I would recommend taking a look at the 'Matrix Dynamic' widget http://widgets.jotform.com/widget/matrix_dynamique

    Do let us know if any of these would work for you or if you need any assistance with them.

    Best Regards,
    Ben