Form Calculator

  • Profile Image
    html5
    Asked on September 18, 2018 at 07:16 AM

    Hi I am trying to make a simple petty cash form. I can do these steps

    1. Cash Today

    2. Top Up

    3. Total

     

    That works great, but when i created a field for cash out, that should calculate from the (3.total) I cannot get it to work, and leave me a final figure for end figure.

    So the other fields (ie)

    4. Cash out

    5. End Figure

     

    Can you help

     

    thanks

     

    Peter

     

  • Profile Image
    ivy
    Answered on September 18, 2018 at 08:13 AM

    I cloned your form in order to tested on my side. You should use more than one "Form Calculation Widget " to calculate this values. Please follow these steps:

    1.Change existing calculation wizard field like this to see the calculation datas.

    1537271658Screen Shot 2018-09-18 at 14.5

    2. You should delete New Total text entry and add new Form Calculation widget as "New Total" field. Enter the fields like that. Then, save it.

    1537272208Screen Shot 2018-09-18 at 15.0


    3. You should delete End Balance text entry and add new Form Calculation widget as "End Balance" field. Enter the fields like that. Then, save it.

    1537272584Screen Shot 2018-09-18 at 15.0

    As you can see it works successfully. 

    1537272713Screen Shot 2018-09-18 at 15.1


    I hope it would be helped. 

    Please let us know if you need further assistance.

  • Profile Image
    html5
    Answered on September 19, 2018 at 08:55 AM
    Hi I managed to do it, I think its slightly different thatn yours but wors ok, thanks for helping though
    Pete
    ________________________________
    ...
  • Profile Image
    ivy
    Answered on September 19, 2018 at 09:50 AM

    You're welcome! Please feel free to reach out if you have further questions.