Convert min/sec/milliseconds to sec/milliseconds using form source code

  • Profile Image
    Asked on April 26, 2014 at 03:47 AM

    In terms of being able to convert min/sec/milliseconds to sec/milliseconds with source code I say yes let's do it! But I don't know a lick about source code. (That's why I'm doing forms with you guys and making my website with squarespace, I don't know much about website backbones) Can you show me a path to at least learning this if it is outside your jurisdiction?

    And I was thinking of expanding out my BCR Test 2 to 100 laps or more should I wait and get the source code working first? And if I am to work on expanding it is there a quicker way than duplicating and modifying? And is there a cap to amount of items or conditions in a form?

  • Profile Image
    Answered on April 26, 2014 at 08:24 AM


    Please refer to this guide on how to get the form's full source code

    When using the form's source code embed, you will need to have a website where you can embed source code and also add your own custom functions using javascript or PHP.

    Do you have a website already where you can embed using source code?

    Can you confirm if this is the form you want to apply this full customization?

    We will wait for your response.


  • Profile Image
    Answered on April 27, 2014 at 05:22 PM

    I'm building the website on Squarespace. Now I have gotten it to work on there.(using a modified iframe) But I'm not sure what limitations squarespace will bring when I try and do this conversion. (I know Squarespace has issues with java) Not sure if this answers any of your questions.

    And yes that is the form I wish to use for the customization.

  • Profile Image
    Answered on April 27, 2014 at 07:10 PM


    Please correct me if I have misunderstood your question. Upon checking your form, it seems like it is already doing the conversion? What particular part you need assistance with conversion? You can do all the conversions/calculations using the Calculation Wizard.

    Regarding on form embedding, its either you embed the form source code as iframe or source code as long as the form calculation and validation work properly on the page. However, we usually recommend iframe to prevent script conflict since the form loads in an iframe container. Source code is usually exposed to script conflict so this causes issues with the form functionality specially the calculation function.

    Let us know if you have further questions. Thanks!

  • Profile Image
    Answered on April 30, 2014 at 12:22 AM

    (FYI) The question about conversion was brought up in a previous post before this got it's own thread.

    My users will be entering time like this: ex. 1:20.505 (minutes:seconds.milliseconds)

    But in order for my formulas to work in my form I need the format to be seconds.milliseconds ex. 80.505 seconds. So this is the conversion I am trying to accomplish.

  • Profile Image
    Answered on April 30, 2014 at 01:08 AM

    You can build the calculation directly on the calculation wizard. Please review the example form:

    As you can see typing 1:20:505 above outputs 80:505 below. Do note wou would still need to add the additional lap time fields as this is just a basic mock up for proof of concept.

    Do let us know if you need further assistance. 

  • Profile Image
    Answered on May 13, 2014 at 01:31 AM

    Yes this is great, now I don't have to use source code. But...

    This only partly works. This gives a semi-colon before the Milliseconds space in the calculation field. I need a decimal for my various other fields to work properly. I've tried imputing a decimal in place of the semi-colon and it breaks the calculation.

    Your solution outputs {result 1}:{result 2} but with the decimal replacing the semicolon it outputs {result 1}. I need {result 1}.{result 2}(notice the decimal replacement)


    And the other problem I stumbled upon is more of a glitch. lets say I imput 1:20.050, the answer in the calculation box is 80.50 It cannot seem to imput the zeroes from the preceding decimals places. This makes the users data inaccurate. Try this yourself and you'll understand.

  • Profile Image
    Answered on May 13, 2014 at 09:06 AM


    Check and clone this form

    Instead of typing dot as the separator, you can try copying dot somewhere else and paste it on the formula just like what I did on the above form. 

    About the zero being omitted, insert the field as "Text" so the starting zero will not be removed.

    Hope this helps!