Is it possible to overwrite a calculated field in an input table?

  • Profile Image
    adamshine
    Asked on May 31, 2018 at 03:34 PM

    I have logic built into my form where the gross weight subtracts tare weight and then returns the net weight.  In some cases I don't have a gross weight and tare weight and want to manually enter the net weight, is this possible?

  • Profile Image
    jonathan
    Answered on May 31, 2018 at 05:26 PM

    As you have found out already, because the net weight data was base on calculated value using condition, the manually inputted data will only will always be overridden by the calculation value.

    The workaround that I found that can work is to add another column/input box in the table. Example, you can add the "manual net" column. It should not be calculated value.

    The user can manually input the data in "manual net" box.

    Then you can create another condition wherein if the "manual net" box is filled, override the value in the net box -- either set it to 0 or empty.

    I hope this help. Let us know if you need further assistance.


  • Profile Image
    adamshine
    Answered on June 14, 2018 at 05:06 PM

    Jonathan,

    I have tried unsuccessfully to create logic where, if the manual net box is filled is will override the value in the net box.  Can you provide details for how I could do that?  Also, is it possible to request an enhancement that would allow a user to overwrite a calculated field with data if one of the fields used in the calculation isn't used?

    Thanks,

    Adam

  • Profile Image
    jonathan
    Answered on June 14, 2018 at 06:44 PM

    Hi Adam,

    Sorry for the delays. The workaround I was suggesting is something like this...

    1529015322zzz 2018-06-15 06.26.20.png

    but unfortunately there is a problem with our condition calculations that was preventing the condition to work properly.

    I have sent a bug ticket report to our higher team support so that they can fix the problem to make the condition work as intended.

    For now, the nearest resolution I can suggest is to just use the alternative 'manual net' input as the input data source in place of "Net" if gross and tare input are empty/blank.

    I hope this help. Let us know your thought on this.

  • Profile Image
    adamshine
    Answered on July 30, 2018 at 10:58 PM

    Jonathan,


    Any updates on this?  i created a clone of my settlement report that can be found here.  i added a new field named Recovered Net.  Gross and Tare are entered i want it to calculate the net and then multiple the net by price for the total.  If Gross and tare aren't selected I want to be able to enter a number in the Recovered Net field and have it calculate by price for the total. How can I accomplish this?

  • Profile Image
    ashwin_d
    Answered on July 31, 2018 at 05:14 AM

    Unfortunately my colleague is currently not available online. Let me send a message to him and he will get back to you as soon as he is available.

  • Profile Image
    adamshine
    Answered on August 02, 2018 at 09:51 AM

    Are there any updates to this?