Input Table: I need to make several columns with fixed info.

  • Mustang2
    Asked on September 19, 2020 at 7:50 PM

    I am trying to do a form for inventory at our concession operations

    i have been using configurable list and input table. i need to make several columns with fixed info.

    product name              Number to keep(PAR)      number on hand 


    the first two would have info in them the name and a number

    i can only figure out how to put one colum with words or numbers. can  you help?

  • Ariel JotForm Support
    Replied on September 19, 2020 at 8:49 PM

    Greetings,

    Thank you for your message.

    Just to be clear, are you referring to this form, https://www.jotform.com/form/202627316462149?

    Since you're using Input Table, you can set its Input Type to Multi Type Columns.

    16005624192020 09 20 08 39 26 Screenshot 10

    You can then create your "Fixed Info" column, set its field type to Dropdown, and add the options.

    16005625092020 09 20 08 41 06 Screenshot 21

    That way, the form filler can only select predefined options for that column.

    Let us know if this fits your requirements.

  • Mustang2
    Replied on September 19, 2020 at 9:28 PM
    Yes that is the form.
    I will try your suggestion. I want the par to remain constant so I m not sure. It is the number in with name right now.
    Jean
    Sent from my Verizon, Samsung Galaxy smartphone
    ...
  • Flavio_A
    Replied on September 19, 2020 at 10:05 PM

    Hi, Jean

    Please have a try and let us know how it goes. If that does not match your requirements, you can describe what other changes you will need and we can try to find a new solution for you. Let us know if you need any further assistance.

  • Mustang2
    Replied on September 19, 2020 at 10:19 PM

    I tried it but to many choice. Is there anything that gives you two columns you can make permanent and one that we can add numbers too?

  • Mustang2
    Replied on September 19, 2020 at 10:28 PM
    This is not going to work. Is there another form that I can use that will give me two set columns and one they can add infor (number) to? thanks
    Sent from Mail for Windows 10
    ...
  • Carlos_C
    Replied on September 19, 2020 at 11:35 PM

    Hello,

    Thank you for your message.

    You can also try with the widget "Spreadsheet" here: https://www.jotform.com/widgets/spreadsheet and the demo form is https://form.jotform.com/61441655557965.

    Please feel free to reach out if you have other questions or need some more help. I will be happy to help!