Value: free input or computed according to condition?

[Igor-just-igor]

Hi,

I have a table where, in some cases, I want a given cell value to be freely inputed by the user, and in other situations I want it being computed according to a given formula. This is conditional on the value of another cell in the same form.

Is this possible? The only solution I've come to so far is to have 3 columns: one for computed values, a second for non-constrained values and a third column which shows the value of either one of these columns according to the situation.

This is far from elegant or practical. Any workarounds I might be missing?

Thanks.

[Heriberto_Ayala · Accepted solution]

You can put the formula in "Initial Value", so that you will have a computed data or you can edit the information manually.

[Igor-just-igor]

Thanks!