# How can I have a calculation in the form based on the time and location?

• FRESHWAYS
Asked on December 23, 2016 at 10:11 AM

devo creare un form sull' esempio di quello che ho link( che ho creato io stesso ) che però sappia anche calcolare i tempi di consegna della merce sapendo quando parte e ovviamente " legandosi " alla tabella dei tempi di attesa in base alla località di dove va la merce che ho io .... è fattibile ?  https://eu.jotform.com//?formID=62993291386368

• Welvin
Answered on December 23, 2016 at 11:34 AM

If you mean to calculate the total based on the dates entered and location, I think you can do this with conditional calculation. Here's our guide for condition calculation:

https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic

When adding the condition, you could do the following:

Please try it and let us know if you need help.

• FRESHWAYS
Answered on January 03, 2017 at 05:45 AM
For example a form in wich i can chose the departure day (ex Sunday) from Italy to London;
so i need the possibility taht the form computes the day in wich the goods arrive in london ; of course for computing, i have a table in wich are available departure days and arrive dates ;
how can i do ?
best regards
Andrea Cerchia
Fresh Ways S.r.l.
-----------------------------------------------------------------------------------------------------------
Via Enrico Fermi 10 - 20875 Burago di Molgora (MB) - Italia -
Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
Timocom: 91886
Visita il nostro sito Web
[RINNOVO PER MAIL]
Inviato: venerdì 23 dicembre 2016 17:35
A: Andrea Cerchia
Oggetto: Re: form che sappia calcolare... è possibile ???
A new response has been received:
[JOTFORM]
If you mean to calculate the total based on the dates entered and location, I think you can do this with conditional calculation. Here's our guide for condition calculation:
https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic
When adding the condition, you could do the following:
[https://shots.jotform.com/welvin/jot/2016-12-24-002-002.png]
Please try it and let us know if you need help.
1482510892
...
• Welvin
Answered on January 03, 2017 at 07:04 AM

Are the cities based on the user input or can this be predefined? I need to know this so I can determine whether this is possible in the form or not. I have one in my mind to get the total based on the following:

1. The number of days of the delivery based on the user selections on dates.

2. The miles/kilometers between two locations entered by the user on the form.

This is just to simplify the process, to get it done with just a few calculations in the form.

Here's my test form: https://www.jotform.com/70023050610940. Do the following to get the total:

1. Make sure that the Number of Days is greater than 3.

2. Make sure that the Distance (Miles/KM) is greater than 5.

Here's a screenshot of the total:

You can then pass the total to the payment field for payment:

Let us know if you need further assistance.

• FRESHWAYS
Answered on January 03, 2017 at 08:45 AM
[cid:image001.png@01D265C8.DB43E490]
This one is my form created ;
the user with “calcola” have t0 know when his goods arrive to destination;
we have in our society fixed departures day (from italy ) and fixed arrive days (in uk, france, germany…)
for example:
goods leave from milan on tuesaday -----> destination : london -----> arrive in uk on same tuesday so the result when submit “calcola” is TUESDAY
BELOW OUR DEPARTURES AND ARRIVES SCHEDULE :
DESTINAZIONE
GIORNI DI CONSEGNA A DESTINAZIONE
GIORNO DI ARRIVO IN FRESH WAYS (entro h.12)
REPARTO COMPETENTE
@
INGHILTERRA
Martedì
Venerdì
Martedì
Venerdì
gb@freshways.it
FRANCIA
Martedì
Mercoledì
Venerdì
Venerdì
Venerdì
Martedì
fr@freshways.it
BELGIO
Martedì
Mercoledì
Venerdì
Venerdì
Venerdì
Martedì
fr@freshways.it
OLANDA
Martedì
Mercoledì
Venerdì
Martedì
Mercoledì
Venerdì
fr@freshways.it
SPAGNA
Venerdì
Venerdì
es@freshways.it
PORTOGALLO
Venerdì
Venerdì
es@freshways.it
GERMANIA
Venerdì
Mercoledì
de@freshways.it
IRLANDA
Venerdì
Martedì/Mercoledì
irl@freshways.it
ITALIA
Tutti i giorni
Venerdì
operativo@freshways.it
ESTONIA
Venerdì
Venerdì
operativo@freshways.it
LETTONIA
Venerdì
Venerdì
operativo@freshways.it
LITUANIA
Venerdì
Venerdì
operativo@freshways.it
POLONIA
Venerdì
Venerdì
operativo@freshways.it
CROAZIA
Giovedì
Mercoledì
operativo@freshways.it
MALTA
Giovedì
Giovedì (h.10)
operativo@freshways.it
UNGHERIA
Giovedì
Mercoledì
operativo@freshways.it
GRECIA
Giovedì
Martedì
operativo@freshways.it
BULGARIA
Giovedì
Martedì
operativo@freshways.it
ROMANIA
Giovedì
Mercoledì
operativo@freshways.it
REPUBBLICA CECA
Giovedì
Mercoledì
operativo@freshways.it
SVEZIA
Lunedì/Giovedì (merce fresca)
Giovedì (merce surgelata)
Mercoledì
Lunedì
operativo@freshways.it
DANIMARCA
Lunedì
Giovedì
Venerdì
Martedì
operativo@freshways.it
UNGHERIA
Venerdì
Venerdì
operativo@freshways.it
AUSTRIA
Lunedì
Venerdì
Giovedì
Martedì
operativo@freshways.it
THKS 4 UR HELP !
Andrea Cerchia
Fresh Ways S.r.l.
-----------------------------------------------------------------------------------------------------------
Via Enrico Fermi 10 - 20875 Burago di Molgora (MB) - Italia -
Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
Timocom: 91886
Visita il nostro sito Web
[RINNOVO PER MAIL]
Inviato: martedì 3 gennaio 2017 13:05
A: Andrea Cerchia
Oggetto: Re: How can I have a calculation in the form based on the time and location?
A new response has been received:
[JOTFORM]
Are the cities based on the user input or can this be predefined? I need to know this so I can determine whether this is possible in the form or not. I have one in my mind to get the total based on the following:
1. The number of days of the delivery based on the user selections on dates.
2. The miles/kilometers between two locations entered by the user on the form.
This is just to simplify the process, to get it done with just a few calculations in the form.
Here's my test form: https://www.jotform.com/70023050610940. Do the following to get the total:
1. Make sure that the Number of Days is greater than 3.
2. Make sure that the Distance (Miles/KM) is greater than 5.
Here's a screenshot of the total:
[https://shots.jotform.com/welvin/jot/2017-01-03-003-003.png]
You can then pass the total to the payment field for payment:
https://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field
Let us know if you need further assistance.
1483445077
...
• Chriistian
Answered on January 03, 2017 at 09:34 AM

If I understand your concern correctly, you want to calculate the date of arrival from a given location and display it on your form. As per checking the form you mentioned (http://www.jotformeu.com/form/62993291386368), it seems that the departure and arrival location is based from user input since you are using the Address field for the location fileds. Unfortunately, the use of address fields in condition is limited only. You can only use the value of the Country selected in the address field in the conditions.

But if you use a predefined location, just what my colleague Welvin used in his demo form (https://www.jotform.com/70023050610940) we can use condition and calculate the date of arrival. I have created a sample cloned form where I have implemented sample logic you want on your form using predefined locations. You can check the cloned form here: https://form.jotform.com/70023462059954.

You can clone the form to have a closer look on the setup. To clone a form, just follow the instructions provided in this article: How to Clone an Existing Form from a URL.

Do let us know if you need further assistance.
Regards.

• FRESHWAYS
Answered on January 04, 2017 at 05:45 AM

I try to import ur form but i can t
[cid:image001.png@01D26678.A922BB20]
How can i do ?
Best regards
Andrea Cerchia
Fresh Ways S.r.l.
-----------------------------------------------------------------------------------------------------------
Via Enrico Fermi 10 - 20875 Burago di Molgora (MB) - Italia -
Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
Timocom: 91886
Visita il nostro sito Web
[RINNOVO PER MAIL]
Inviato: martedì 3 gennaio 2017 15:34
A: Andrea Cerchia
Oggetto: Re: How can I have a calculation in the form based on the time and location?
A new response has been received:
[JOTFORM]
If I understand your concern correctly, you want to calculate the date of arrival from a given location and display it on your form. As per checking the form you mentioned (http://www.jotformeu.com/form/62993291386368), it seems that the departure and arrival location is based from user input since you are using the Address field for the location fileds. Unfortunately, the use of address fields in condition is limited only. You can only use the value of the Country selected in the address field in the conditions.
But if you use a predefined location, just what my colleague Welvin used in his demo form (https://www.jotform.com/70023050610940) we can use condition and calculate the date of arrival. I have created a sample cloned form where I have implemented sample logic you want on your form using predefined locations. You can check the cloned form here: https://form.jotform.com/70023462059954.
You can clone the form to have a closer look on the setup. To clone a form, just follow the instructions provided in this article: How to Clone an Existing Form from a URL.
Do let us know if you need further assistance.
Regards.
1483454046
...
• FRESHWAYS
Answered on January 04, 2017 at 05:45 AM
AND CAN U WRITE ME PLEASE THE CALCULATE FIELD TAHT U HAVE USED?
THKS
Andrea Cerchia
Fresh Ways S.r.l.
-----------------------------------------------------------------------------------------------------------
Via Enrico Fermi 10 - 20875 Burago di Molgora (MB) - Italia -
Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
Timocom: 91886
Visita il nostro sito Web
[RINNOVO PER MAIL]
Inviato: martedì 3 gennaio 2017 15:34
A: Andrea Cerchia
Oggetto: Re: How can I have a calculation in the form based on the time and location?
A new response has been received:
[JOTFORM]
If I understand your concern correctly, you want to calculate the date of arrival from a given location and display it on your form. As per checking the form you mentioned (http://www.jotformeu.com/form/62993291386368), it seems that the departure and arrival location is based from user input since you are using the Address field for the location fileds. Unfortunately, the use of address fields in condition is limited only. You can only use the value of the Country selected in the address field in the conditions.
But if you use a predefined location, just what my colleague Welvin used in his demo form (https://www.jotform.com/70023050610940) we can use condition and calculate the date of arrival. I have created a sample cloned form where I have implemented sample logic you want on your form using predefined locations. You can check the cloned form here: https://form.jotform.com/70023462059954.
You can clone the form to have a closer look on the setup. To clone a form, just follow the instructions provided in this article: How to Clone an Existing Form from a URL.
Do let us know if you need further assistance.
Regards.
1483454046
...
• FRESHWAYS
Answered on January 04, 2017 at 05:45 AM
SORRY , CAN U HELP ME TO INSERT THE CALCULATE FIELD FORM MY FORM https://eu.jotform.com//?formID=62993291386368
THKS
BEST REGARDS
Andrea Cerchia
Fresh Ways S.r.l.
-----------------------------------------------------------------------------------------------------------
Via Enrico Fermi 10 - 20875 Burago di Molgora (MB) - Italia -
Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
Timocom: 91886
Visita il nostro sito Web
[RINNOVO PER MAIL]
Inviato: martedì 3 gennaio 2017 15:34
A: Andrea Cerchia
Oggetto: Re: How can I have a calculation in the form based on the time and location?
A new response has been received:
[JOTFORM]
If I understand your concern correctly, you want to calculate the date of arrival from a given location and display it on your form. As per checking the form you mentioned (http://www.jotformeu.com/form/62993291386368), it seems that the departure and arrival location is based from user input since you are using the Address field for the location fileds. Unfortunately, the use of address fields in condition is limited only. You can only use the value of the Country selected in the address field in the conditions.
But if you use a predefined location, just what my colleague Welvin used in his demo form (https://www.jotform.com/70023050610940) we can use condition and calculate the date of arrival. I have created a sample cloned form where I have implemented sample logic you want on your form using predefined locations. You can check the cloned form here: https://form.jotform.com/70023462059954.
You can clone the form to have a closer look on the setup. To clone a form, just follow the instructions provided in this article: How to Clone an Existing Form from a URL.
Do let us know if you need further assistance.
Regards.
1483454046
...
• amy
Answered on January 04, 2017 at 06:32 AM

Hi Andrea,

We cannot display the screenshots via our forum which you added as e-mail attachment. So we can't view the error message which you get when you want to clone the forms.

Would you please click to the "View this thread on browser"  link that you can see on the right side of the e-mail layout?