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
-
Trigger after update that first checks for null value; something like this:
let v := NumberFieldA + NumberFieldB;if Total = null then Total := v end -
Thanks you really much, I'll try asap and let you know
Content aside
- 4 yrs agoLast active
- 2Replies
- 532Views