Announcement

Collapse
No announcement yet.

Cancel the formula after editing the field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cancel the formula after editing the field

    Hi,

    how to cancel the calculation of a formula when I manually write something in the field where the result is to be displayed?


    Please.

    My formula -

    field1 = field2 * field3;
    Last edited by sumservis; 10-03-2021, 02:49 PM.

  • #2
    Don't think you can. Only way I think of would be using an "If" statement,

    For example, (written in theory, not actual formula)

    If Field1 = isempty, then field2*field 3; field1=field1.

    I'm not even sure if this will work as I type this. Usually I would use the "If" function to make thing blank or use a secondary formula.

    Comment


    • #3

      Hi, I figured it out ...

      PHP Code:
      ifThen(
      field1 == null,
      field1 field2 1.21;
      ); 
      and

      PHP Code:
      ifThen(
      field2 == null,
      field2 field1 1.21;
      ); 
      This will cause me to eventually use both fields for counting.

      Respectively, always one field to calculate the difference for the other.

      Comment


      • espcrm
        espcrm commented
        Editing a comment
        Cool, so that how you do it, using a ==null

        Thank for posting solution, I will I think adopt it
    Working...
    X