0

A formula which is static once calculated

Hello, I'm looking for to do something on my database made with Ninox. I guess that is something really easy but, i cannot find. 

I would like to make a bill calculated with some value that i have entered in other table. 

Everything's is fine i got the right result but if I'm changing a value which I'm using for the calcul it will change the result. I would like to make it static. I dont want this move if i change any value. 

Would you have any idea of how i should do that ? 

I can provide an simple UML Shema to explain better if needed 

I would thanks you so much guys if you have any answer ! ✅

2 replies

null
    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    Trigger after update that first checks for null value; something like this:

    let v := NumberFieldA + NumberFieldB;
    if Total = null then Total := v end

    • Wwwphiltexshop
    • 3 yrs ago
    • Reported - view

    Thanks you really much, I'll try asap and let you know

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 532Views