Form Calculator

  • html5
    Asked on September 18, 2018 at 7: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

     

  • ivy
    Replied on September 18, 2018 at 8: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 Screenshot 10

    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 Screenshot 21


    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 Screenshot 32

    As you can see it works successfully. 

    1537272713Screen Shot 2018 09 18 at 15 Screenshot 43


    I hope it would be helped. 

    Please let us know if you need further assistance.

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

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