how to use the Input Table Form?

  • Profile Image
    formmaker55
    Asked on August 30, 2020 at 03:31 AM

    Is there a video tutorial explaining how to use the Input Table Form?

  • Profile Image
    Sam_G
    Answered on August 30, 2020 at 05:55 AM

    Hi Formmaker55,

    Thank you for contacting Support.

    You can check this guide: https://www.jotform.com/help/567-Input-Table-s-New-Type-Multi-Type-Columns

    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Input-Table-Field

    May we ask what you're trying to achieve by using the input table?

    We will wait for your response.

  • Profile Image
    formmaker55
    Answered on August 30, 2020 at 04:28 PM
    Hi,Thank you for your response and information.I am trying to set up a check off / decision table on my enrollment form. I would then like to calculate a total cost basedon the choices made. The calculation would be based on a percentage of the employee membership cost. I just can't figure outhow to do this.
    I have included a previous response from your co-worker.  Thank you.
    Answered by Patrick_R
    Hello Bob! I cloned your form and used 'Input Table' field instead on 'Configurable list' widget. I think this should solve your purpose.
    This is the form that I prepared: https://form.jotform.com/202345467734963
    Following is a short demonstration on its working:
    If this solves your purpose, then you can simply clone it into your account and start using it by making any further adjustments as per your requirement.
    You can use these instructions to clone this form: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
    If this form doesn't solve your purpose or if you have any further queries, then let us know, we'll be glad to assist you further.
    Thank you!
    On Sunday, August 30, 2020, 02:55:58 AM PDT, Jotform wrote:

    A new response has been received: Answered by Sam_G

    Hi Formmaker55,
    Thank you for contacting Support.
    You can check this guide: https://www.jotform.com/help/567-Input-Table-s-New-Type-Multi-Type-Columns
    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Input-Table-Field
    May we ask what you're trying to achieve by using the input table?
    We will wait for your response.
    View this thread on browser » Unsubscribe Thread 1598781353
    ...
  • Profile Image
    gerardw
    Answered on August 30, 2020 at 09:56 PM

    Based on the solution, provided by our colleague Patrick on your other ticket, it is possible to calculate the total cost.

    What you need to do is to assign value to each radio button on the input table on the form https://form.jotform.com/202345467734963. Then use a Form Calculation widget to calculate the total.

    Here is a useful guide: How-to-Perform-Form-Calculation-in-the-Input-Table-Field 

    However, if you can clarify this sentence - "The calculation would be based on a percentage of the employee membership cost." - we can come up with a demo video and form to suit your requirement.

    From where do you get the employee membership cost. Is it added by default on the form (do you show that amount on the form) or entered by the user?

  • Profile Image
    formmaker55
    Answered on August 30, 2020 at 11:28 PM
    Gerard, Thank you for your input.I will try to summarize my goals for this form. I have decided to simplify it by only including the Employeeas a choice for selection. The percentage refers to the cost of membership, which I have not yet included on the form. I knowthat it needs to be included on the form to be use as a part of a formula for calculations.The Employee Membership is $360 annually. I want to be able to allow the Employer to calculate or do some "what ifs"about his cost of subsidizing memberships (what percent he would be willing to contribute, for instance). There should also be aplace for the employer to enter the total number of employees involved (this field would be used in the calculation of total cost).
    Based on the number of Employees, the annual cost of the membership and the percentage chosen by the Employer, I wouldlike the form to calculate the Total Cost to the Employer both monthly and annually.
    Some of the features I would like in the form are:  - To have the table only appear if the Employer chooses to subsidize his employees memberships  - The ability to clear the percentage choices radial buttons that were clicked on (for what-if scenarios)  - To have the calculations clear (clear button?) or be replaced by new calculations
    Generally,  I would also like to know how to:  - Reposition an element on the form horizontally, if it is possible. That way there could be to smaller elements on the same line.  - How to adjust the element boxes to be closer vertically, if possible. I know I can shrink them, but that only seems to apply    to the width.I sincerely appreciate your assistance.

    Bob  
    On Sunday, August 30, 2020, 06:56:58 PM PDT, Jotform wrote:

    A new response has been received: Answered by gerardw

    Based on the solution, provided by our colleaguePatrick on your other ticket, it is possible to calculate the total cost.
    What you need to do is to assign value to each radio button on the inputtable on the form https://form.jotform.com/202345467734963.Then use a Form Calculation widget to calculate the total.
    Here is a useful guide: How-to-Perform-Form-Calculation-in-the-Input-Table-Field 
    However, if you can clarify this sentence - "The calculation would bebased on a percentage of the employee membership cost." - we can come upwith a demo video and form to suit your requirement.
    From where do you get the employee membership cost. Is it added by default onthe form (do you show that amount on the form) or entered by the user?
    View this thread on browser » Unsubscribe Thread 1598839015
    ...
  • Profile Image
    gerardw
    Answered on August 31, 2020 at 12:48 AM

    Let me check your requirement and revert.

    Meanwhile, I have moved the last part of your query to a new ticket link.

    Here is the new link: https://www.jotform.com/answers/2546335 

  • Profile Image
    gerardw
    Answered on August 31, 2020 at 01:39 AM

    Please check this demo form if it suits your requirement: https://form.jotform.com/202430826763959 

    The details will only show on the form if the subsidized option is chosen.

    In order to clear the values on the radial buttons, you will need to manually edit the form and revise the table.

    If this form works out, you may clone it into your account: How-to-Clone-an-Existing-Form-from-a-URL 

  • Profile Image
    formmaker55
    Answered on August 31, 2020 at 02:28 AM
    Hi Gerard,The demo this will simplify the form.  Can you modify it for me accordingly?
    I appreciate your help. How can I see the actual form builder version so that I can learn how to do this myself and see how theform was built? I would love to understand how you were able to put elements side by side and how to locate them on the page.Also, I would like to understand how the calculations were set up. Lastly, how is the bottom half hidden until the radial button osclicked on?
    Lastly, when you clone a form to put it into an account, are you using the URL  of the form?  
    Thanks,Bob
    On Sunday, August 30, 2020, 10:39:55 PM PDT, Jotform wrote:

    A new response has been received: Answered by gerardw

    Please check this demo form if it suits yourrequirement: https://form.jotform.com/202430826763959 
    The details will only show on the form if the subsidized option ischosen.
    In order to clear the values on the radial buttons, you will need to manuallyedit the form and revise the table.
    If this form works out, you may clone it into your account: How-to-Clone-an-Existing-Form-from-a-URL 
    View this thread on browser » Unsubscribe Thread 1598852393
    ...
  • Profile Image
    Sam_G
    Answered on August 31, 2020 at 03:52 AM

    Hello,

    You can clone the form that was created by my colleague.

    15988598248.31 clone.png

    Once cloned, you would be able to see the form builder.

    All the conditions and calculations would be visible. 

    15988600748.31 clone2.gif

    For the bottom half, it was set up as a show/hide condition:

    15988601838.31 clone3.png

    Kindly clone the form and check the demo form and let us know what revisions are needed.

    We will wait for your response.