I want the excel spreadsheet to ready numbers instead of agree

  • StaffdevelopmentTTH
    Asked on October 29, 2019 at 11:40 AM

    The input table lets you check agree, strongly etc. On excel side I want it to report back a number. ie Strongly Disagree should be  the number 1 and Disagree 2 and neither should be 3 etc


    I also need the question column wider. How do I do that?

    Jotform Thread 2019133 Screenshot
  • stevenmarshall
    Replied on October 29, 2019 at 2:16 PM

    Hi @StaffdevelopmentTTH,

    One thing you can do is to change the checkbox options in the input table to dropdown option and to assign number 1 and number 2 to the dropdown options.

    1572372735Screen Shot 2019 10 29 at 11 Screenshot 10

    1572372756Screen Shot 2019 10 29 at 11 Screenshot 21

    1572372776Screen Shot 2019 10 29 at 11 Screenshot 32

    As far as making the columns wider in the input table I see you have a duplicate thread that one of my colleagues is working on a response for you. You will be able to view the response here: https://www.jotform.com/answers/2019090-how-can-I-make-the-input-column-wider

    Please let us know if you have any further questions.

    Thank you