Matrix calculation with multiple answers.

  • lansingparty
    Asked on March 2, 2017 at 5:12 AM

    How can a matrix with multiple limos listed vertically with different hourly values deliver more than one answer?  I feel like I am doing something very wrong and it is very simple. 

  • Ashwin JotForm Support
    Replied on March 2, 2017 at 8:54 AM

    Hello lansingparty,

    I am not sure if I have understood your question correctly. I did check your form #70578782717167  and did not find any matrix field added. You seems to have added "Multiple Choice" question.

    I would suggest you to please explain your calculation requirement a bit more in detail and we will surely help you achieve it. You may also like to share a screenshot as well for us to better understand your requirement. The following guide should help you how to upload image in forum post:  http://www.jotform.com/answers/277033

    We will wait for your response.

    Thank you!

  • lansingparty
    Replied on March 3, 2017 at 8:22 PM

    I think I may have not explained correctly.  Let me try again.  What I am attempting to accomplish is a complex quote form for customers for limos quotes.  These final calculations are determined by:

    1.  Day of the week

    2.  Number of rental hours

    3.  Limo Selection which is conditionally priced based on day of the week and number of hours

     

    Now I think I understand how to accomplish this if the customer wanted to only select 1 limo however I had hoped to list all limos and let them select the units they wanted to have responses sent for.  

     

    Does this make more sense on what I am attempting to accomplish?

  • Ashwin JotForm Support
    Replied on March 4, 2017 at 5:00 AM

    Hello lansingparty,

    Okay now I have understood your requirement. What the calculations and how you need the price the limo based on day of week and number of hours.

    Do get back to us on this and we will create a demo form for you.

    We will wait for your response.

    Thank you!

  • lansingparty
    Replied on March 9, 2017 at 9:18 AM
    Thank you and I may very well be just frustrated.
    Overall we have 20 limos and each has a differently hourly price.
    Additionally each of those prices are different for Sat, Fri, weekday, wedding.
    Client chooses a number that represents the hours rented, then the day of the week, and finally a selection of however many limos they would like a quote on.
    Does make sense?
    -Chris-
    www.lansingparty.com
    517-258-2409
    ...
  • lansingparty
    Replied on March 9, 2017 at 10:11 AM
    VEHICLE OPTIONS Saturday Friday Weekday
    12 PARTY VAN 75 65 65
    12 PARTY LIMO 110 99 90
    14 LUXURY LIMO 120 120 110
    16 PARTY LIMO 125 115 105
    17 PARTY LIMO 130 120 110
    16 RANGE ROVER 150 140 130
    20 LUXURY BUS 140 130 115
    22 LUXURY BUS 149 140 120
    30 LUXURY BUS 220 205 145
    30 EXECUTIVE BUS*Bathroom 185 120 100
    52 PARTY BUS *Bathroom 275 200 150
    54 LUXURY BUS *Bathroom 400 250 165
    56 PASSENGER CHARTER BUS*Bathroom 175 150 120
    ...
  • lansingparty
    Replied on March 9, 2017 at 10:11 AM
    This is what I came up with however it was very labor intensive. If you think there is a more effective way to do this I would be happy to hear.
    https://form.jotform.com/70578782717167
    ...
  • Ashwin JotForm Support
    Replied on March 9, 2017 at 1:34 PM

    Hello lansingparty,

    I did check your form and it seems to be a very complicated form with calculation. Is your form working as expected? Can you please let us know if any of your requirement is still pending and you want to achieve?

    We will wait for your response.

    Thank you!

  • lansingparty
    Replied on March 9, 2017 at 4:46 PM
    Thank you. For the moment it is working as expected.
    ...