Form calculation and conditions

  • Profile Image
    Angusnorriss
    Asked on July 27, 2020 at 02:32 PM

    Hi

    I am trying to develop a form whereby a drop-down or slider is dragged to calculate property marketing options.

    Is there any way to make the price form for each service change automatically when  after a "square foot" size is chosen?

    I attach the prices and structure of the price modelling.

    Please advise.


    thank you,


    Angus

    Screenshot
  • Profile Image
    Welvin
    Answered on July 27, 2020 at 07:09 PM

    Hello Angus,

    I'll think of a better way to do this. However, considering the pricing structure, I believe this needs a conditional logic. I also think this is better to be a short text entry rather than a dropdown or a slider.

    But just to clarify, is the price per item or group? 0 to 1999 x 149, for the Photos Only, for example. So, if someone enters 100, that's 14900? 

    Thanks

  • Profile Image
    Angusnorriss
    Answered on July 30, 2020 at 07:26 AM

    thanks - yes short text entry would be fine. Price is per group. 

    For example, if property is 1500 sqft then 'Photos' are a total of $149. How would I build that?



  • Profile Image
    BJoanna
    Answered on July 30, 2020 at 09:38 AM

    I created a demo form with the Service/Size and Photos Only fields. I set the conditions to calculate the price for the Phots Only field based on the entered value inside of the Service/Size filed. I used the Number field, not the Short Text Entry field, for the Service/Size because the Greater Than and Less Than conditional states can be used with the Number field and cannot be used with the Short Text Entry field. 

    How to Insert Text or Calculation into a Field Using Conditional Logic

    Here is my demo form - https://form.jotform.com/202113409148042

    Feel free to test it and clone it

    You can use the same approach to calculate prices for the other fields.

  • Profile Image
    Angusnorriss
    Answered on July 30, 2020 at 10:33 AM

    FANTASTIC THANK YOU!

  • Profile Image
    Angusnorriss
    Answered on July 30, 2020 at 10:46 AM

    I can't see how to duplicate the Photos field forumulas so I can adapt them for other services. It won't let me duplicate the field.


    Also the user then needs to select the services they want (Photos + Matterport Only) and see a total to submit.


    is there a way to do this?

  • Profile Image
    Lorenz_A
    Answered on July 30, 2020 at 12:07 PM

    I assume you are referring to this field right? see the image below. 

    15961247255d78368b-fb43-407f-a62d-de7fac

    I checked the field's property and there's a duplicate option there.

    1596125048d3ada028-a4e7-43c0-b219-4b6230

    If I have misunderstood the form you are referring to, kindly provide here your form so that we can check.

    We will wait for your response. 

  • Profile Image
    Angusnorriss
    Answered on July 30, 2020 at 12:31 PM

    Yes I have now actually cloned it. Please refer to this one.

    https://form.jotformeu.com/202114655535349

    The form calculates correctly, I am fine with developing it further but O have one question.

     

    I want user to select the services they wish actually buy. Some may just want Matterport only. Is there any way to select and submit just that service?

     

    And how to add $ dollar currency symbol in each calculation?

  • Profile Image
    BJoanna
    Answered on July 30, 2020 at 01:48 PM

    You can use the Multiple Choice field, to add the list of Add-ons to the form. You can then create a separate field (e.g. Short Text Entry) to which you will pass the price, for each add-on option. You can then show the Add-on (Short Text Entry) fields with the conditional logic based on the selected options in the Multiple Choice field. 

    How to Show or Hide Fields Base on User's Answer

    You can add $ dollar currency symbol in each calculation before price. 

    1596131130dollar.gif

  • Profile Image
    Angus Norriss 
    Answered on July 30, 2020 at 03:32 PM

    Hi, I understand the currency option thanks. But the previous bit I do not. I can’t follow how that works or is even set up. Can you a demo video or assist?

  • Profile Image
    Welvin
    Answered on July 30, 2020 at 05:03 PM

    Here's a demo of that multiple choice selection:

    https://form.jotform.com/202116341188953

    The conditional logic for calculation remains the same.

    It's the show/hide multiple fields at once: https://www.jotform.com/help/196-Hide-or-Show-Multiple-Fields-at-Once.

    You only need to do the same for the other fields. 

    I'll see if I can update the form to include the addons, so you can just repeat it later. I'll let you know.

    Thanks

  • Profile Image
    Angus Norriss 
    Answered on July 30, 2020 at 05:35 PM

    Thank you so much.

    I understand. 

    What I really would like develop is like this:

    Step1: the client enters their size of space.

    Step 2. Prices are calculated for all services. The client must select a service or several services (photos/matterport/Zillow), they they wish to buy.

    They select and it calculates total.

    Submit.

    Is this possible?



  • Profile Image
    Welvin
    Answered on July 30, 2020 at 06:52 PM

    I'm sorry, but I believe that is how we set up the form. The table seems to be very straightforward. 

    Now, with the description you have provided, do you want it this way:

    1. The client chose Services such as Photos, Matterport, and Zillow.

    2. The client enters 1500 in the Size box. So, that's $149 x 3 (services) = $447?

    The way how I understand the table is that you want clients to be able to select multiple services and allow them to enter sizes for each service, and then calculate the total.

    Thanks 

  • Profile Image
    Angus Norriss 
    Answered on July 31, 2020 at 03:34 AM

    Not quite.

    Client enters size of property. For example sqft.

    Form calculates price for each service and provides total for all services.

    Client ticks which Service they wish to buy

    Submit.


    This way they can see price of each service before purchasing. Please advise.

  • Profile Image
    Angus Norriss 
    Answered on July 31, 2020 at 03:43 AM

    The client only enters size of property once.

    They do not need to enter size for each service.



  • Profile Image
    roneet
    Answered on July 31, 2020 at 04:49 AM

    Please allow me some time to take a look at your requirement and get back to you.

    Thanks.

  • Profile Image
    roneet
    Answered on July 31, 2020 at 11:32 AM

    Could you please check this demo form if this suffices your requirement:

    https://form.jotform.com/202123176786961

    1596208861888888888.gif

    I have added 3 multiple Choices and in its label I have used the Unique names to populate the values from the text fields that populate the price.

    15962094691.PNG

    The user can select these options if they like.

    Let us know how it goes.

    Thanks.


  • Profile Image
    Angus Norriss 
    Answered on August 01, 2020 at 05:16 AM

    this is great and much closer to what I want. However, can the area highlighted in yellow be hidden? The client really only needs to see price Per service once.

    15962733576D019257-06A3-4307-9491-4F5943

    csn it also calculate total of all ticked services?


    much appreciated for your help.


    angus 

  • Profile Image
    Johann_A
    Answered on August 01, 2020 at 07:07 AM

    Greetings, 

    To hide those fields you can click on each field go to Properties > Advanced > Hide fields > ON

    You can see the result below: 

    1596277311hide fields.gif

     

    2. I'm not sure if I understand correctly the data that you want to calculate. But if you want to calculate the total of the data that is appearing after the @ 

    1596279429Screenshot 2020-08-01_11-56-29

    You can do that by adding a Form Calculation Widget.

     

    1596279524Screen Shot 2020-08-01 at 11.5

    Once it is added you can change the title of the calculation by: "Total of all ticked service" for example. 

     1596279736Screen Shot 2020-08-01 at 12.0

    You can then add this calculation to get the total: 

    Here is the formula

    1596279846Screen Shot 2020-08-01 at 12.0

    You can check the demo link that I've made: https://eu.jotform.com/build/202132362223944#preview

     

    Let us know if you have more question!

    Have a good day, 

    Johann. 



  • Profile Image
    roneet
    Answered on August 01, 2020 at 07:59 AM

    As my colleague suggested that all the extra fields that you do not want to keep on the form could be hidden.

    I'll explain it to you further. The form would be a complex one so to calculate the total you need to follow another workaround.

    1. Since we cannot assign the value into the Multiple Choice directly as it would be a dynamic one to generate the price based on the size selection so you cannot directly calculate the total.

    1596283141888888888.gif

    2. You have to copy the price into another field based on the Multiple Choice selection. Once the prices are copied into another field, it would only copy those price that was selection into the Option which the user would like to purchase.

    15962831151.PNG

    3. Add the total into the Form Calculation widget:

    15962830641.PNG

    Here is the Demo Form:

    https://form.jotform.com/202123176786961

    Please clone the form and feel free to test the form.

    Thanks.

  • Profile Image
    roneet
    Answered on August 01, 2020 at 07:59 AM

    As my colleague suggested that all the extra fields that you do not want to keep on the form could be hidden.

    I'll explain it to you further. The form would be a complex one so to calculate the total you need to follow another workaround.

    1. Since we cannot assign the value into the Multiple Choice directly as it would be a dynamic one to generate the price based on the size selection so you cannot directly calculate the total.

    1596283141888888888.gif

    2. You have to copy the price into another field based on the Multiple Choice selection. Once the prices are copied into another field, it would only copy those price that was selection into the Option which the user would like to purchase.

    15962831151.PNG

    3. Add the total into the Form Calculation widget:

    15962830641.PNG

    Here is the Demo Form:

    https://form.jotform.com/202123176786961

    Please clone the form and feel free to test the form.

    Thanks.

  • Profile Image
    Angusnorriss
    Answered on August 01, 2020 at 02:37 PM

    this looks good thanks.


    But what are these fields for? Can they be hidden?


    1596306885Screenshot 2020-08-01 at 19.33


    And can these be hidden?

    1596306951Screenshot 2020-08-01 at 19.35


    I only need client to enter size.


    Then client ticks services that have been calculated.

    Then submit.


  • Profile Image
    Flavio_A
    Answered on August 01, 2020 at 05:39 PM

    Hi @Angusnorriss

    Those fields are only used for calculation purposes. You can hide them all by selecting each field in the form builder, then clicking on Properties > Advanced > Hide fields > On.

    Please see below:

    1596317915hidefields.gif

  • Profile Image
    Angus Norriss 
    Answered on August 02, 2020 at 06:24 AM

    Ok thank you.

  • Profile Image
    Angusnorriss
    Answered on August 08, 2020 at 09:50 AM

    Hi - final question as completely stuck.


    Why does calculation not appear here, like the other fields? See attachment.


    https://eu.jotform.com/build/202203506235340#preview


    thanks for helping so far!


    Angus


    15968946280001 2.jpg

  • Profile Image
    Patrick_R
    Answered on August 08, 2020 at 10:40 AM

    Hello Angus! There is a typo in the field name being used due to which this dynamic field placeholder isn't working. Following is how you an fix this:

    1596897596Screencast 2020-08-08 20-05-40

    For further queries, feel free to write back to us.

    Thank you!

  • Profile Image
    Angusnorriss
    Answered on August 12, 2020 at 11:56 AM

    Thank you for all your help on this so far - however I think I may need to pay a jotform expert to do this as there is more conditional logic now involved.

    Please see this video for explanation into the requirement and let me know if possible to work with someone to do it and a price to complete it.


    I attach video brief and the Lookup price table.

    https://imagineerconsulting.io/wp-content/uploads/2020/08/Virual-Realty-Pricing-Lookup-Table-Sheet1.pdf

    https://youtu.be/tcbuVGOlP8k

    Please advise thank you,


    Angus

  • Profile Image
    BJoanna
    Answered on August 12, 2020 at 01:16 PM

    Please note that we cannot create you a form. We can only assist you if you have any questions or issues while creating a form. 

    If you want to hire someone to create the form, I can only suggest you to try to find a Jotform expert on Upwork - https://www.upwork.com/ 

    I think that there is another way to create the form, that would require fewer conditions.

    You can add a site property field at the top of the form, create a separate Muiltuple Chose field with the same options for each property size, and assign different calculation values to the field options. You can then show the correct Multiple Choice field based on the size and perform a calculation with the form calculation widget. 

    How to Assign Calculation Value

    How to Perform Form Calculation Using a Widget

    Please allow me some time to create a demo form with a few form fields. 

  • Profile Image
    BJoanna
    Answered on August 12, 2020 at 01:30 PM

    I created a demo form for Sizes (0-1999, 2000-2999 and 3000-3999) and for Services (Photos Only, Matterport Only and Premium Video Only). 

    Here is the form - https://form.jotform.com/202245621330946 

    Feel free to test it and clone it

    You can update the form and add all the other options.

  • Profile Image
    Angusnorriss
    Answered on August 12, 2020 at 01:36 PM

    Thanks - but the issue is that if client wants Matterport + Photos then the Lookup price is $299 because they are being bought as 2 items. It calculates then as add-ons and not as Only rates.

  • Profile Image
    BJoanna
    Answered on August 13, 2020 at 03:43 AM

    In that case, you can simply add a new option "Matterport + Photo". 

    I updated my form - https://form.jotform.com/202245621330946