How do I edit input table with my own information?

  • JEAN PAULEMON
    Asked on January 19, 2020 at 1:47 PM
    How do I edit input table with my own information
    Sincerely, Jean Paulemon
  • Mike_G JotForm Support
    Replied on January 19, 2020 at 2:35 PM

    On the builder page of your form, select the Input Table field and click the cogwheel icon on the right to open the Input Table fields properties. Under the FIELDS tab, you can select a field type and you can edit the Rows and Columns header.

    1579462487zt14 31 36 Screenshot 10

    Feel free to let us know if you need any further assistance.

  • JEAN PAULEMON
    Replied on January 20, 2020 at 7:50 AM
    Thank you so much for that information. Unfortunately it did not work.
    Here's is what I'm attempting to do. I posted a few pictures to show you.
    I'm creating a order form for my customers and have it give them a total
    cost for the items they are purchasing.
    I attempted to use the "Purchase Order" widget but it doesn't allow me to
    keep each category seperate.
    I attempted to use the chart u helped me with but I don't know how to
    set it up. I am willing to pay and work with someone 1 on 1 for I need this
    done as soon as possible.
    Can you help me with this?
    Sincerely, Jean Paulemon
    ...
  • JEAN PAULEMON
    Replied on January 20, 2020 at 7:50 AM
    Maybe if you can help me code a condition that allows me to do the math.
    See pictures below.
    If we can create condition:
    A+B=C and sum it all up at bottom (D)
    Sincerely, Jean Paulemon
    ...
  • David JotForm Support Manager
    Replied on January 20, 2020 at 12:00 PM

    "Here's is what I'm attempting to do. I posted a few pictures to show you."

    Unfortunately, your pictures did not post on this forum thread correctly, please make sure to open this forum thread in your browser first, link: https://www.jotform.com/answers/2123020

    Then, follow this guide from step 2 in order to post the pictures: https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum


    "I attempted to use the "Purchase Order" widget but it doesn't allow me to

    keep each category seperate."

    There is a way to add sub-categories on a Purchase Order field, please follow this guide: https://www.jotform.com/help/178-How-to-Have-Sub-Category-or-Sub-Labels-on-an-Order-Form

    "Maybe if you can help me code a condition that allows me to do the math."

    Performing calculations is possible, you could do it through the Form Calculation widget: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    As well through conditions: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    Let us know if you need more help.

  • AtlantaBeautyDepot2
    Replied on January 21, 2020 at 12:38 AM

    Great .Thank you for this .Now how do I put $ in Numbers widget???

  • Kiran Support Team Lead
    Replied on January 21, 2020 at 6:22 AM

    how do I put $ in Numbers widget???

    I believe that you are referring to the form calculation widget. You may type the $ symbol directly in calculation widget.

    157960571620200121 165129 Screenshot 10

    Hope this information helps! Let us know if you are referring something different. We will be happy to help. 

  • JEAN PAULEMON
    Replied on January 21, 2020 at 8:50 AM
    You guys customer service is great!!!
    Is there anyway I can make it tally up more than 5 items?
    Sincerely, Jean Paulemon
    ...
  • JEAN PAULEMON
    Replied on January 21, 2020 at 8:50 AM
    I tried plugging in $ and it doesn't seem to like it 😬
    Sincerely, Jean Paulemon
    ...
  • JEAN PAULEMON
    Replied on January 21, 2020 at 8:50 AM
    Can you help me! Here is what I'm attempting to do
    I'm creating order form.
    Ex:
    500mg Tinctures $35 each x 2 = $70
    1000mg Tinctures $50 each x 5 = $250
    2000mg Tinctures $70 each x 3 = $210
    Total cost $530
    ...
  • JEAN PAULEMON
    Replied on January 21, 2020 at 8:50 AM
    I forgot to mention I have 10 different items and need for them to be in
    their own category please.
    Sincerely, Jean Paulemon
    ...
  • Kiran Support Team Lead
    Replied on January 21, 2020 at 10:01 AM

    Could you provide us with the form ID/URL that you are working so that we can take a look and assist you further?

    We will wait for your response. Thank you! 

  • JEAN PAULEMON
    Replied on January 21, 2020 at 10:50 AM
    Jotform.com/build/200198380085152
    Sincerely, Jean Paulemon
    ...
  • JEAN PAULEMON
    Replied on January 21, 2020 at 10:50 AM
    Trying to add a total cost at bottom of this form. So my customers can know
    the price of what they have ordered.
    Jotform.com/build/200198380085152
    Sincerely, Jean Paulemon
    ...
  • KrisLei Jotform Support
    Replied on January 21, 2020 at 11:51 AM

    Hi Jean,

    I checked and cloned your form to take a closer look.

    Kindly use the Form Calculation widget instead of the Number Properties to add the total price of the items.

    10 28 2017 1509179477 Screenshot 10

    Then use the Add Field button to add all the fields for the products: How-to-Perform-Form-Calculation-Using-a-Widget

    Here's a screencast:

    1579625280form calculation Screenshot 21

    Please note that there's no need to add the '+' sign, just the fields that you want to add and it will automatically add the values.

    Also, make sure to click on the Save button to make the changes.

    I hope this helps. 


  • JEAN PAULEMON
    Replied on January 22, 2020 at 7:50 AM
    Hello, is there anyway I can create seperate category when using the
    purchase widget?
    Example:
    •Apparel (1 category)
    Shirts
    Pants
    Sweater
    •Foot Wear ( 2 category)
    Slippers
    Sneakers
    Boots
    •Outer Wear (3 category)
    Coat
    Hats
    Jackets
    Sincerely, Jean Paulemon
    .
    ..
  • Kiran Support Team Lead
    Replied on January 22, 2020 at 9:55 AM

    The other question related to categories in the purchase order field is moved to a separate thread and shall be addressed there shortly.

    https://www.jotform.com/answers/2127240-

    Thanks!