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


  • Profile Image

    floor() function in Calculation Widget converts to text when saved

    Asked by okemeki on July 01, 2014 at 12:43 AM

    Calculation widget: floor() function not working in formula. please help ? thank you.

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Welvin on July 01, 2014 at 04:05 AM

    Hi,

    Allow me to forward this thread to our developers so they can further check the cause of this. Adding field calculations should be allowed inside the floor function. But it turns our that when you saved, open again the calculation, the formula transforms into a text format:

     

    For now, you may consider using the Advance Option > Decimal Places to Zero:

    I think this option should work the same like the Floor Function. 

    Thanks

  • Profile Image

    Answered by okemeki on July 01, 2014 at 07:40 PM

    thank you for your reply.

    however, suggestion will not work in my case, as I need to use the result(number rounded down) of this field (which still has the value with the decimal places) to calculate the output of another field.

     

    Please note: Same thing happens with all other of math functions.
  • Profile Image
    JotForm Support

    Answered by jonathan on July 01, 2014 at 08:02 PM

    Hi,

    Our colleague had already submitted a bug ticket report about this issue. The ticket is now assigned to our developer and being look at. 

    We will notify you when update status is available.

    I also created a separate post regarding the other math function issue you mentioned here

    http://www.jotform.com/answers/398530

    We will reply to you on that thread separately.

    Thanks!

     

  • Profile Image

    Answered by okemeki on July 03, 2014 at 08:17 PM

    Great Thanks!