What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No signup 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.

Create products with multi  choices and use Freshbooks for invoices and payment
Asked by Jan on December 26, 2013 at 09:20 AMHello 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!

JotForm Support
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.

JotForm Support
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?

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?

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 025m 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 26m50m 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 025m =
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!

JotForm Support
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 MultiOption Form that would then display the correct pricing based on the user's input. That part would have to be done via Conditional Logic.

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!

JotForm Support
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.

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!

is this what i am looking for:
http://www.jotform.com/answers/258767Howtocreatecustompricingforproductsinapaymentintegration
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!

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 ENDIFfor 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 ENDIFSo 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?

JotForm Support
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 HowToAddOptionsInThePaymentForm
You can have multiple options in the in the payment field, and it will also do the calculations for subtotals accordingly.
Inform us if this will still not do on what you need.
Thanks.

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!

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!

JotForm Support
@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!
