I am trying to change thing (field in database) when inputs value is changed.
On the video you can see that condition “when inputs value change” only works when changed by user and not by calculation.
Is there any way to work around it?
I don’t know the answer to your question specifically, but you could put condition on the input that is being changed by the user?
Thankx for the reply. Unfortunately the inputs based on which is the main input calculated are also calculations on sum of database cells.
Sure. But I am curious to know why are you not in a position to put condition on the main things that are changing.
I am making an inventory tracking app.
Input 1 in the cell is sum of all the products sold (view from database product sold).
Input 2 in the cell is sum of all the products created (view from database product created).
Input 3 (MAIN) = INPUT 2 - INPUT 1.
When products is sold, it is created in database product sold, which update the Input 3.
I need to bind the input 3 into the current cells database whenever the input is changed.
Where are you storing Input 3 value?
You don’t even need to use these as Input 1, 2 and 3 I think if they are not going to be stored anywhere. Just write as normal text expressions?
This topic was automatically closed after 70 days. New replies are no longer allowed.