I need help creating complex conditional form

  • Profile Image
    spencerseaside
    Asked on August 28, 2019 at 11:58 AM

    Good Afternoon,

    I am trying to create a screen print and embroidery pricing tool using jotform. Our current tool is built in excel using various formulas such as VLOOKUP+MATCH, IF, AND, OR, (formula of example attached)


    I need to lookup data from a spreadsheet based on multiple criteria from customer selection such as quantity, number of colors on design, number of ink changes, location of design. Each of these selections reference a unique price that the customer would need to see.

    Is this achievable via Jotform? I'd be happy to discuss over the phone or do a screenshare to walk through our current tool and rule sets.

    Thank you

    Screenshot
  • Profile Image
    jherwin
    Answered on August 28, 2019 at 01:16 PM

    Jotform currently has no support over the phone. The best way to reach us is through the support forum. You can also contact us at support@jotform.com, but we do recommend posting your questions through the forum instead.

    It will help us provide you with the appropriate workaround/suggestions if you can elaborate further on what you wanted to do using the form.

    Perhaps, you can create a screencast to explain your requirements and share with us the shareable link so we can watch it on our end?

  • Profile Image
    jherwin
    Answered on August 28, 2019 at 02:17 PM

    Few questions regarding your requirements:

    For certain locations such as sleeve, there is a cost of $0.45 in addition to the base cost.

    - Is your customer the one will provide the location and quantities?

    - Also, do you have a website or layout that we can look at so we can visualize the form you want?

    - Is this the form (92394849700163) you're working on? 

    By the way, I think your requirements will be met using conditional logic because that's what you'll use to check the quantities and location to assign a max number of colors.

    We will wait for your response.

  • Profile Image
    spencerseaside
    Answered on August 28, 2019 at 02:31 PM

    - Is your customer the one will provide the location and quantities?
    -yes, this will be a drop down or check box indicating that they want us to print the design on the shirt sleeve, front, back , etc

    - Also, do you have a website or layout that we can look at so we can visualize the form you want?

    -I am not looking to replicate the layout we currently have, it is more important the the features and pricing are functional. I've attached a screenshot below of what our current excel tool looks like

    1567016914Capture.PNG

    - Is this the form (92394849700163) you're working on?

    yes, this is the form I started to play around with today.


    The difficult part for me is the multiple variables in designs. I have entered the various prices based on color and quantities as a hidden spreadsheet on the form.

  • Profile Image
    spencerseaside
    Answered on August 29, 2019 at 12:49 PM

    Following up....

  • Profile Image
    jherwin
    Answered on August 29, 2019 at 01:08 PM

    Sorry for the delay. I'm inspecting your test form: https://www.jotform.com/92394849700163 and there are many location labels so I don't know which one you are referring to in your explanation before.

    Can you please elaborate on your requirements or give us an example using your test form? You can screencast or screenshot the selection you made and tell us the output you want.

    Looking forward to your response.