• Profile Image
    Asked on January 21, 2014 at 01:34 PM

    Please help.  This issue has cost me many hours of frustration.  For some reason, a calculation in a form that once worked now causes a freeze and crash.  I have tried many work arounds like changing entry fields from text to number and back again.  The fields in question are CASH TIPS and CREDIT TIPS.  What's strange is that it worked originally as a text field...

    Below is link...


  • Profile Image
    Answered on January 21, 2014 at 03:25 PM


    Sorry about that, I was able to see what you mean by freezing. 

    You have a calculation script that has gone into an infinite loop in one of the calculation fields (cannot tell where because replicating the problem takes up all of my processing power)

    This points to a wrong field Id for the calculation script, conflicting field id's or similar calculations running at the same time for the same fields.

    To remove the problem, do the following (Its a bit lengthy, but bear with us):

    1. Open the form in the form editor

    2. Rename all the similar-name fields - for instance: 


    3. Check all your calculations and correct the wrong field ID's in the curly brackets - Important

    We would like to help, but we do not know your form's intended functionality. 

    Please let us know if this helps.  

  • Profile Image
    Answered on January 21, 2014 at 04:15 PM

    Hi.  This did not work. It still Freezes.  There is no calculation occuring in the field I am entering data into ie the Cash Tips field.  There are other fields however that do use the data from Cash Tips field to do calculations.  I went through and changed all the fields that used the Cash Tips field data to make sure they did not have similar field names.  Still freezes.  I'm at a loss.

    The forms functionality is to take the total amount of server or bartender tips: CASH TIPS and CREDIT TIPS and divide them up into various pools by percentages.  Runners 20%. Bartenders 12%. Hosts 5%.  The calculation also takes into consideration whether or not there is runner, bartender or host working (Runner? YES=1 / NO=0).  It basically multiplies the Total Cash tips by 0.20 and by either 1 or 0 depending on whether there is a runner on duty. [({totalCash}*0.20)*{RunnerYes}].

    Once the pools are determined, then the form takes the pools and further splits the tips amongst the Runners, Hosts, etc...based on the amount of hours they worked.  Runner 1 Hours Worked/Total Hours Worked = Percentage of Tip Split.  Percentage of Tip Split X Runner Cash Tip Pool = Runner 1 Cash Tip Share.

    Please let me know if you need further clarification.



  • Profile Image
    Answered on January 21, 2014 at 05:52 PM

    Unfortunately, I do not think that we have any easy solution to this issue. You have many calculation fields and it is quite hard to troubleshot it, anything could conflict due to the nature of the Javascript that is the base of the form and calculations. I would like to recommend you to remove every calculation from your fields, then add them back step by step, and do the Clones on successful stages of your work.

    The calculation fields option has been recently added, and I believe that we will improve it with time. Once again we are very sorry for the inconveniences caused.