How do I edit input table with my own information?

  • Profile Image
    JEAN PAULEMON
    Asked on January 19, 2020 at 01:47 PM
    How do I edit input table with my own information
    Sincerely, Jean Paulemon
  • Profile Image
    Mike_G
    Answered on January 19, 2020 at 02: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.png

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

  • Profile Image
    JEAN PAULEMON
    Answered on January 20, 2020 at 07: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
    ...
  • Profile Image
    JEAN PAULEMON
    Answered on January 20, 2020 at 07: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
    ...
  • Profile Image
    BDAVID
    Answered 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.

  • Profile Image
    OrganicTouch
    Answered on January 21, 2020 at 12:38 AM

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

  • Profile Image
    Kiran
    Answered on January 21, 2020 at 06: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.png

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

  • Profile Image
    JEAN PAULEMON
    Answered on January 21, 2020 at 08:50 AM
    You guys customer service is great!!!
    Is there anyway I can make it tally up more than 5 items?
    Sincerely, Jean Paulemon
    ...
  • Profile Image
    JEAN PAULEMON
    Answered on January 21, 2020 at 08:50 AM
    I tried plugging in $ and it doesn't seem to like it 😬
    Sincerely, Jean Paulemon
    ...
  • Profile Image
    JEAN PAULEMON
    Answered on January 21, 2020 at 08: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
    ...
  • Profile Image
    JEAN PAULEMON
    Answered on January 21, 2020 at 08: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
    ...
  • Profile Image
    Kiran
    Answered 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! 

  • Profile Image
    JEAN PAULEMON
    Answered on January 21, 2020 at 10:50 AM
    Jotform.com/build/200198380085152
    Sincerely, Jean Paulemon
    ...
  • Profile Image
    JEAN PAULEMON
    Answered 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
    ...
  • Profile Image
    KrisLei
    Answered 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.png

    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.gif

    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. 


  • Profile Image
    JEAN PAULEMON
    Answered on January 22, 2020 at 07: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
    .
    ..
  • Profile Image
    Kiran
    Answered on January 22, 2020 at 09: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!