How do I modify your configurable list to a 3 column table?

  • Roy_McCallum
    Asked on June 11, 2016 at 8:08 AM

    The current issue is how to configure the data collection table.

    See https://www.jotform.com/?formID=61622529852863

    Column 1 is text that cannot be overwritten.

    Column 2 is Numeric data entry  

    Column 3 is Numeric data entry.

    This is an element of a 28 item questionnaire to be sent by email with the data collect via your system for each individual farmer Subscribing.

    I plan to email this data form to our clients subsequent to a request for the service. Early client base perhaps 100 per annum expanding to 1000 in time

    Thank you if you can direct me on constructing your sheet

    Regards

     

    Roy McCallum

     

    Period Kg/DM /Day Est. MJME
    1/6 - 14/6 22 10.5
    15/6 - 28/6 21 10.5
    29/6 - 12/7 18 10.5
    13/7 - 26/7 17 10.5
    27/7 - 9/8 15 10.5
    10/8 - 23/8 17 10.5
    24/8 - 6/9 25 10.5
    7/9 - 20/9 33 10.5
    21/9 - 4/10 38 10.5
    5/10 - 18/10 45 10.5
    19/10 - 1/11 48 10.5
    2/11 - 15/11 53 10.5
    16/11 - 29/11 60 10.5
    30/11 - 13/12 63 10.5
    14/12 - 27/12 60 10.5
    28/12 - 10/1 55 10.5
    11/1 - 24/1 53 10.5
    25/1 - 7/2 51 10.5
    8/2 - 21/2 45 10.5
    22/2 - 7/3 42 10.5
    8/3 - 21/3 35 10.5
    22/3 - 4/4 38 10.5
    5/4 - 18/4 42 10.5
    19/4 - 2/5 43 10.5
    3/5 - 16/5 38 10.5
    17/5 - 31/5 25 10.5
    Two weekly period estimated Kg dry matter / ha /day grown.
    If you have any MJME feed quality figures, please add these.
    Page URL: https://www.jotform.com/?formID=61622529852863
  • Boris
    Replied on June 11, 2016 at 10:21 AM

    Please take a look at the following guide on how to set up the Configurable List widget:

    https://www.jotform.com/help/282-How-to-Set-Up-the-Configurable-List-Widget

    As described in that guide, if you are looking to have static text and two number fields per row, then you will have to set up your configurable list widget with Static and Number fields.

    However, based on what you are describing, it seems like you will always have a fixed amount of questions per form - 28. Configurable List widget is meant for instances when you do not know how many entries you will be receiving, so that your customers can create as many rows as they need (and you allow them to).

    Since you are using a questionnaire with the same 28 questions for every customer, you may want  to use a regular Matrix field instead, which is found under Survey Tools:

    How do I modify your configurable list to a 3 column table? Image 1 Screenshot 50

    Simply use the Rows, Columns, and Input Type buttons to set its "Periods", questions at the top of 2nd and 3rd column, and Numeric field types respectively.

    How do I modify your configurable list to a 3 column table? Image 2 Screenshot 61

    How do I modify your configurable list to a 3 column table? Image 3 Screenshot 72

    How do I modify your configurable list to a 3 column table? Image 4 Screenshot 83

    If you need further assistance in setting it up, please let us know. Thank you.