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

  • Profile Image
    Roy_McCallum
    Asked on June 11, 2016 at 08: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.
  • Profile Image
    Boris
    Answered 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:

    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.

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