What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Create products with multi - choices and use Freshbooks for invoices and payment

    Asked by Jan on December 26, 2013 at 09:20 AM

    Hello JotForm,

    i want to use JotForm with this features:

    - i have 3 products but there are many mulkti choice to chosse for ma customers

    So the question is:

    A - can i calculate the total price with radiobutton options and placeholdes and the calculation wizard

    and then use show/hide function to show only the rigtht price in the paymentarea?

    or

    Is it only possible to use the product - options in the payment Area?-

    For example:

    Product A - costs = 37€ - for max 2 days and max. 25m

    Product B - costs = 43€ - for max 2 days and max. 25m

    Product C - costs = 47€ - for max 2 days and max. 25m

    Option is now for all of the 3 products = how many meters the customer want to have-,

    = every extra 25m the price should get xx€ higher

    = evey extra day the price should get xx€ higher

     

    Now the customer can choose another option-,

    = with option 1 the price is up to xx€ higher

    = option 2 is no more costs for him

    I also need a calculation to calculate how many days are between day of fill out the formular and the first startdate of my service to work for the customer- for example: if it s  under 7 days he has to pay xx€ more!- This is diffucult i ll think - maybe it is the way the time ranges works  of JotForm - but i didn t find the same fuction for the dates?!-

    So one way is the customer fill out the order - formular and the the formular calculate the total price automaticly but then the problem is can i send it to the payment area like freshbooks?-

     

    or is the better way to make all options with prices over the Paypment functions - like directly with freshbooks?-

     

    I ll think when a customer fill ou the order - formular of me it is easier for him when the formular calculte the total price autamaticly and he just can only use one price - options as when he can chooce more diffrents price options in the payment area!?-

    So i want to send the clinet automaticly the invoice when he fill out the formular and buy services from me - so send JotForm the totalprice and productname to freshbooks and freshbooks to the customer?-

     

    So this is what i need and i hope this can be possible with JotForm!-

     

     

     

    create choices and JotForm problem total price prices
  • Profile Image
    JotForm Support

    Answered by KadeJM on December 26, 2013 at 10:21 AM

    What you are requesting is something that seems to be a bit complex. I'm not entirely sure how to do this just yet but if you'll allow me some time I will work on thinking about how to do this on a form if I am able to come up with something as a possibility for doing this per your request.

  • Profile Image
    JotForm Support

    Answered by KadeJM on December 26, 2013 at 10:43 AM

    Okay so I started thinking about this more and I realized that I've reached a slight complication. I know that you had the following (see below). But what is the actual pricing value per additional 25m that gets added should they go longer than the 2 days default you set?

     

    Product A - costs = 37€ - for max 2 days and max. 25m

    Product B - costs = 43€ - for max 2 days and max. 25m

    Product C - costs = 47€ - for max 2 days and max. 25m

     

    For instance the above only changes in price but the max 25m stays the same along with the days you have so this is a bit confusing. Additionally, I'm aware that you want it to go by Price * Meter Quantity but is there any value limitations to that which you have set or is it going to be whatever Meter Amount and however many days they need?

  • Profile Image

    Answered by JLTransporte on December 26, 2013 at 10:46 AM

    i am not fit in programming this is while i want to use JotForm - i used formdesk.com there i am a little bit fit because some one shows me some calculations in this formular so i can handle it and push it in my ways;-

    In formdesk there is no payment - options and the design is not very modern and other things!-

    Can you please tell me what is possible from my questions and what is only possible with work in the sourcecode - so i can give it to a person who s fit in writing sourcecode?-

    In formdek all calculations are with hide/show and java math and placeholders; - So you have in formdesk for each field a placeholder and can give commands for each field like:

     

    [datum_von4]  - [datum_von5]  -0

    i can give you examples for that and the formular still runs but is very complex and overload and cost me much of time to work with it;-

    maybe  i wrote my first question above a little bit too complicated but i mean this:

    A -

    work with placeholders and calculate them together to a totalprice as the customer choose the options and products in the formular - is there an option to make one field to the totalprice field and this field is send to the payment and send invoice with freshbooks?-

    When it s not possible how can i do the same job with another diffrent way?-

    this is important for me:

    - calculate the products options and fix it to a totalprice

    - customer can pay with paypal and other payment options

    - the customer will get automaticly an invoice after his order

    - i ll need an backend to see in which adress i ll have to do my service for the customer - like a list or something like this

    - to see if the client has payd or not

    - JotForm has to send me some filled fields, not all but some i ll have to choose from the filled out formular from each customer automatcly from the customer because i ll have to send this dates to another adress to ordered there something for the customer

     

    So please ask me anything you need to know maybe you can go to my formular which i still used to see what i mean?-

  • Profile Image

    Answered by JLTransporte on December 26, 2013 at 11:56 AM

    Here is my answer:

     

    Product A - costs = 37€ - for max 2 days and max. 25m

    Product B - costs = 43€ - for max 2 days and max. 25m

    Product C - costs = 47€ - for max 2 days and max. 25m

     

    So the calculation should be like this:

    if its maybe 0-25m the customer choose and 3 days = +10€ for each produkt= a or b or c/ for example product b = ground price is 43€ + 10€ for the extra day = 53€ total price

     

    if its -26m-50m the customer choose and maybe 3 days = +10€ more for the extra day and +10€ more for the extra meters!- this is guilty for each produkt on top = a or b or c/ for example product a =37€ ground price + 10€ for the extra day + 10€ for the extra meters = 57€ total price

    So i want to make discount and scale distribution;- if a customer ordered a longer time the price get s lower as if he ordered a shorter time!-

    Maybe for JotForm it is better to take one price for each day more- and at the end i make the discount with % -when it s possible?-

    Or i saved all possible prices for the the scale distribution in a hidden calculation  field  - what did you think!?-

     

    The scale distribution / discount should like that - only an example:

    Ground price for product A / B / C - with 0-25m =

    day 3 to 4 = + 10€ extra per day / example: 3 days are = 10€ or if it s 4 days = + 20€

    day 5 to 8 = 20€ for day 3 and 4 + 7,5€ for each day more / example: 6 days ordered = Groundprice + 20€ for day 3 and 4 + 15€ for day 5 and 6

    There are more dicounts after this and if he ordered a longer time  ill do not shown here but in the way above;-

    Until day 55 - after that each day costs the same low price, so if the customer ordered 200 days he should shown the price for that.

     

    So the total price fixed from:

    Ground price for product a or b or c  + days after 2 with scale distribution + meters every 25 meters with scale distribution too  + one option - if it s choosen = + 39€on top of each product if not no more extra costs;-

     

    The last important function shoulf be if options with 39€ choosen and it s shorter than 9 day left from the date the customer filles out the order to the first starting date i am have to work for them it should be 10€ more each day!- 

    example: the customer filled out the order today this is thursday now - and he wants my service on the next monday - so JotForm shoud calculate / range the days between order date = today- and Serviceday = Monday the day  i work for for the customer;-

    If he choose the options in the order for 39€ on top and 9 or more days are left it is the normal price-, if it 8 or less day each day costs +10€ more!-

    If he didn t choose the options in the order for 39€ on top and 7 or more days are left it is the normal price-, if it 6 or less days each day costs +10€ more!-


  • Profile Image
    JotForm Support

    Answered by KadeJM on December 26, 2013 at 01:13 PM

    I apologize if I gave you the wrong impression. It's very possible to use workarounds on the form using the form's sourcecode. However, I had gotten confused because I was trying to think and understand more about the math involved for the calculations that would be needed. Perhaps I just didn't ask the question to you properly. Our forms do support a Calculation Feature but its just a matter of configuring it to work the way you need.

    What I meant by that was in example if a customer purchases say " Product A at a cost of 37€ " is that only for the 25m for 2 days then?

    Where I'm confused is all of those match in your example so I seem to be misunderstanding that part. I asked that because what if someone wants say 75m then I would need to know what the cost is per Meter that you have set to sell at or 25 meters if thats the increment you are using? Unless you are intending for this to go unspecified for various prices but that would make the math and calculation ability much harder to figure out other than to try to just create an example for you. 

    What I was thinking of so far is to have this be calculated with a Sum amount that could then show based on the triggered response a hidden Multi-Option Form that would then display the correct pricing based on the user's input. That part would have to be done via Conditional Logic.

  • Profile Image

    Answered by JLTransporte on December 26, 2013 at 02:35 PM

    What I meant by that was in example if a customer purchases say " Product A at a cost of 37€ " is that only for the 25m for 2 days then? Yes the groundprice is max. for 1 until 2 days and max. until 25 Meters

    Where I'm confused is all of those match in your example so I seem to be misunderstanding that part. I asked that because what if someone wants say 75m then I would need to know what the cost is per Meter that you have set to sell at or 25 meters if thats the increment you are using? Unless you are intending for this to go unspecified for various prices but that would make the math and calculation ability much harder to figure out other than to try to just create an example for you.  Every 25 Meter the price is higher;- If a customer choose 75 meters it is two price stairs up-, cause 0 until 25 meters a inclusive in  the groundprice - the next step is 26 meters until 50 meters - the next step is 51 meters until 75 meters and so on;-

    So the total price is: Groundprice A / B / C + days + meters + option 39€ if choosen + extra - costs if the order is too shortly - orderday until startdate i wrote it in the last massage = total price

    So you need more informations i ll send you soon and if you have an sreenshot of a comparable problem or a same formular post it it please!-

  • Profile Image
    JotForm Support

    Answered by Mike_T on December 26, 2013 at 03:47 PM

    The Freshbooks integration and other payment tools are based on our Payment Wizard tool (where you add products), but you can not apply formulas and do complex math there.

    On the other side, you can do simple calculations on other fields using 'Calculated Field' option, but you will not be able to forward calculated value to the payment processing service.

    I do not think that we have any ready solution that will work for your case.

    Possible workaround is probably to hire a javascript programmer who will write calculation script, and populate the Total field on the form PayPal/Purchase Order tool.

    Also, our Development Team can take feature requests related to the product, and implement them based on their priority. For example, you can ask for requests that can help with your task:

    - Add integration between calculated field and Product Total field.

    - Improve calculated field option to accept hidden values on dropdowns/checkboxes/radiobuttons.

    etc.

    However, we will not be able to provide any ETA for when the features will be implemented. If you would like to attach any feature request to this thread please let us know. Note, that we can attach only one feature request ticket to the thread. If you want to rise multiple feature requests, you will need to create a thread for each request.

  • Profile Image

    Answered by JLTransporte on December 26, 2013 at 04:04 PM

    so it is possible to do my function with JotForm math calculation but it is not possible to combinate it with the payment function, right?-

    i see many examples in the forum that will be like that what i  want to do and thought you can show me the best example for that - so i can try to do it for my way?!

    So when you have examples for me so please post it so i can see if it s usable for me or not!-

     

    Thanks!-

  • Profile Image

    Answered by JLTransporte on December 26, 2013 at 04:14 PM

    is this what i am looking for:

    http://www.jotform.com/answers/258767-How-to-create-custom-pricing-for-products-in-a-payment-integration

     

    I cannot believe that it is not possible to do it with JotForm - maybe only the calculation between order - day until startdate of my services - can be too difficult for JotForm but the rest should be work with JotForm!-

     

    So it will be really help if you show me some good example from the forum i didn t see all postings cause i use JotForm for 2 days!

     

    many thanks!-

  • Profile Image

    Answered by JLTransporte on December 26, 2013 at 05:09 PM

    so maybe this is a way:

    i create some hidden calculating fields with math - codes like this:

    for meters = IF [anzahl_meter1] <= 20 THEN 1 ENDIF +
    IF [anzahl_meter1] >= 20 AND [anzahl_meter1] <= 30 THEN 5 ENDIF +
    IF [anzahl_meter1] >= 30 AND [anzahl_meter1] <= 45 THEN 10 ENDIF +
    IF [anzahl_meter1] >= 45 AND [anzahl_meter1] <= 60 THEN 15 ENDIF

    for days and meters =

    IF ( [anzahl_tage_ber] = 1 ) AND ( [anzahl_meter] >= 0 AND [anzahl_meter] <= 20) THEN 0 ENDIF +
    IF ( [anzahl_tage_ber] = 1 ) AND ( [anzahl_meter] >= 21 AND [anzahl_meter] <= 30 ) THEN 5 ENDIF +
    IF ( [anzahl_tage_ber] = 1 ) AND ( [anzahl_meter] >= 31 AND [anzahl_meter] <= 45 ) THEN 10 ENDIF +
    IF ( [anzahl_tage_ber] = 1 ) AND ( [anzahl_meter] >= 46 AND [anzahl_meter] <= 60 ) THEN 15 ENDIF +

    IF ( [anzahl_tage_ber] = 2 ) AND ( [anzahl_meter] >= 0 AND [anzahl_meter] <= 20 ) THEN 10 ENDIF +
    IF ( [anzahl_tage_ber] = 2 ) AND ( [anzahl_meter] >= 21 AND [anzahl_meter] <= 30 ) THEN 20 ENDIF +
    IF ( [anzahl_tage_ber] = 2 ) AND ( [anzahl_meter] >= 31 AND [anzahl_meter] <= 45 ) THEN 30 ENDIF +
    IF ( [anzahl_tage_ber] = 2 ) AND ( [anzahl_meter] >= 46 AND [anzahl_meter] <= 60 ) THEN 40 ENDIF +

    IF ( [anzahl_tage_ber] = 3 ) AND ( [anzahl_meter] >= 0 AND [anzahl_meter] <= 20 ) THEN 15 ENDIF +
    IF ( [anzahl_tage_ber] = 3 ) AND ( [anzahl_meter] >= 21 AND [anzahl_meter] <= 30 ) THEN 27.5 ENDIF +
    IF ( [anzahl_tage_ber] = 3 ) AND ( [anzahl_meter] >= 31 AND [anzahl_meter] <= 45 ) THEN 40 ENDIF +
    IF ( [anzahl_tage_ber] = 3 ) AND ( [anzahl_meter] >= 46 AND [anzahl_meter] <= 60 ) THEN 52.5 ENDIF +

    IF ( [anzahl_tage_ber] = 4 ) AND ( [anzahl_meter] >= 0 AND [anzahl_meter] <= 20 ) THEN 20 ENDIF +
    IF ( [anzahl_tage_ber] = 4 ) AND ( [anzahl_meter] >= 21 AND [anzahl_meter] <= 30 ) THEN 35 ENDIF +
    IF ( [anzahl_tage_ber] = 4 ) AND ( [anzahl_meter] >= 31 AND [anzahl_meter] <= 45 ) THEN 50 ENDIF +
    IF ( [anzahl_tage_ber] = 4 ) AND ( [anzahl_meter] >= 46 AND [anzahl_meter] <= 60 ) THEN 65 ENDIF

     

    So the way is to create hidden math fields in which  calculate the price for: meters  days etc.

     

    Than i can add it together with the placeholder function to a total price; so if a customer choose 30 meters and 4 days etc. the calculating is be able to show the right total price cause i add the placeholders for: meters-, days etc.

     

    This must be able in JotForm, right?-

  • Profile Image
    JotForm Support

    Answered by jonathan on December 26, 2013 at 06:33 PM

    Hi Jan,

    I have checked your form http://www.jotform.co/form/33574267291864 

    With regards to options in your Payment form, please check this guide on  -How-To-Add-Options-In-The-Payment-Form

    You can have multiple options in the in the payment field, and it will also do the calculations for sub-totals accordingly. 

    Inform us if this will still not do on what you need.

    Thanks.

  • Profile Image

    Answered by JLTransporte on December 27, 2013 at 01:14 AM

    it is possible that a customer can choose two or more  groundproducts?-

     

    I mean i need my formular but the customer can order the service i sell twice or more - than the problem is that for every order can be other choices and also total prices and at the end they have to be added!-

     

    Mean:

    Customer get on my formular and ordered my service and fill out the form - than he ordered my service but for an other adress and with other options - the form should add both diffrent options to a total price ,-

     

    i ll think it should be working and i ll will be testing it at the weekend but may be you have worry that this doesn t work so i can choose an other way?-

     

    Thanks!-

  • Profile Image

    Answered by JLTransporte on December 27, 2013 at 01:18 AM

    last question for that:

     

    how is it possible to calculate the days in numbers between  day of fill out the formular until first startdate the customer ordered me - is that possible how ever?-

     

    Many Thanks!-

  • Profile Image
    JotForm Support

    Answered by EltonCris on December 27, 2013 at 04:14 AM

    @JLTransporte

    Yes you can enable quantity options for each of your products so your customers can purchase products with a number of quantities.

    Example:

    Please refer to the guides provided by my colleagues on the previous message about how to add options in the payment form. It would be much easier if you could try it out and let us know if you have any difficulties.

    ---

    Regarding on the calculation for the number of days, unfortunately that's not possible in the form builder. We do not have such tool, however, this can be achieved when you take your form source code and inject custom scripts that perform the date calculation. This is possible with you have 2 calendars fields in your form then use javascript to get the difference between the two selected dates. If you need further assistance about this, please let us know your final form with the mentioned calendar fields so we can provide you the javascript code.

    Thanks!