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 Support Team Lead
    Replied 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:

    How can I have a calculation in the form based on the time and location? Image 1 Screenshot 20

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

     

  • FRESHWAYS
    Replied on January 3, 2017 at 5: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 -
    visit our website @ http://www.freshways.it
    Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
    Timocom: 91886
    Visita il nostro sito Web
    [RINNOVO PER MAIL]
    Da: JotForm [mailto:noreply@jotform.com]
    Inviato: venerdì 23 dicembre 2016 17:35
    A: Andrea Cerchia
    Oggetto: Re: form che sappia calcolare... è possibile ???
    A new response has been received:
    [JOTFORM]
    Answered by Welvin
    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.
    View this thread on browser » Unsubscribe Thread
    1482510892
    ...
  • Welvin Support Team Lead
    Replied on January 3, 2017 at 7: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:

    How can I have a calculation in the form based on the time and location? Image 1 Screenshot 20

    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.

  • FRESHWAYS
    Replied on January 3, 2017 at 8: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 -
    visit our website @ http://www.freshways.it
    Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
    Timocom: 91886
    Visita il nostro sito Web
    [RINNOVO PER MAIL]
    Da: JotForm [mailto:noreply@jotform.com]
    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]
    Answered by Welvin
    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.
    View this thread on browser » Unsubscribe Thread
    1483445077
    ...
  • Chriistian Jotform Support
    Replied on January 3, 2017 at 9: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.

    How can I have a calculation in the form based on the time and location? Image 1 Screenshot 30 

    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.

    How can I have a calculation in the form based on the time and location? Image 2 Screenshot 41

     

    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
    Replied on January 4, 2017 at 5:45 AM

    I try to import ur form but i can t
    This one is the answer
    [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 -
    visit our website @ http://www.freshways.it
    Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
    Timocom: 91886
    Visita il nostro sito Web
    [RINNOVO PER MAIL]
    Da: JotForm [mailto:noreply@jotform.com]
    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]
    Answered by Chriistian
    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.
    [https://www.jotform.com/uploads/forum/guest_70023390455045/14834532682017-01-03_2220.png]
    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.
    [https://www.jotform.com/uploads/forum/Chriistian/14834539962017-01-03_2233.png]
    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.
    View this thread on browser » Unsubscribe Thread
    1483454046
    ...
  • FRESHWAYS
    Replied on January 4, 2017 at 5: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 -
    visit our website @ http://www.freshways.it
    Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
    Timocom: 91886
    Visita il nostro sito Web
    [RINNOVO PER MAIL]
    Da: JotForm [mailto:noreply@jotform.com]
    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]
    Answered by Chriistian
    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.
    [https://www.jotform.com/uploads/forum/guest_70023390455045/14834532682017-01-03_2220.png]
    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.
    [https://www.jotform.com/uploads/forum/Chriistian/14834539962017-01-03_2233.png]
    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.
    View this thread on browser » Unsubscribe Thread
    1483454046
    ...
  • FRESHWAYS
    Replied on January 4, 2017 at 5: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 -
    visit our website @ http://www.freshways.it
    Tel: +39 039 63.589.1 – Fax: +39 039 63.589.224
    Timocom: 91886
    Visita il nostro sito Web
    [RINNOVO PER MAIL]
    Da: JotForm [mailto:noreply@jotform.com]
    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]
    Answered by Chriistian
    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.
    [https://www.jotform.com/uploads/forum/guest_70023390455045/14834532682017-01-03_2220.png]
    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.
    [https://www.jotform.com/uploads/forum/Chriistian/14834539962017-01-03_2233.png]
    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.
    View this thread on browser » Unsubscribe Thread
    1483454046
    ...
  • amy
    Replied on January 4, 2017 at 6: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?

    How can I have a calculation in the form based on the time and location? Image 1 Screenshot 20

    You can follow these steps, if you want to add screenshot in your message. 

    Also another point I'd like to remark that, I cloned the forms which are created by my colleagues Welvin and Christian to your account. You can see the both cloned forms and their details on "My Forms" section. 

    Please would you check them and if you need further assistance, could you please inform us?

    Kind Regards.