FORMULA SETTING FOR TIME IN CONDITIONS ( Update a form field value )

  • Profile Image
    meidi01
    Asked on August 13, 2015 at 01:55 AM

    IN CONDITIONS, HOW DO I FORMULATE FOR TIME?

    EXAMPLE:

     

    FLIGHT DEPARTURE TIME : 1500HRS

     

    PICK UP TIME : ( AUTO CALCULATED FROM flight departure time @ -3hours )

  • Profile Image
    EltonCris
    Answered on August 13, 2015 at 04:24 AM

    Sorry but time field can't be used as an output value on the calculation wizard.

    You may however use a text box field instead as an output value like on the following form but I still don't have clue on how to convert it into time though. I think it's just not possible but if anyone from the team has an idea, I will let you know. http://form.jotformpro.com/form/52241517853959?

    You may however consider using your form source code http://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form so you can further add custom functions on your form by using custom scripts.

    Thanks!

  • Profile Image
    meidi01
    Answered on August 13, 2015 at 04:48 AM

    Hi Elton,

    Your form has done what i am trying to do, but i can't find the formula that you used to copy into my form.  i have cloned your form to locate the code.

  • Profile Image
    EltonCris
    Answered on August 13, 2015 at 04:51 AM

    Thanks. You'll find it on the saved conditions. Just click the Conditions button while on the form builder. 

    Here's how:

    Click each of the condition to view the formula