App formula and user fill in

[Marcel1]

Hello,

I want to do something of which I think it is not possible? Its like this:

Calculate the value of field B using CONDITIONAL FORMULA else LET THE USER FILL IN A VALUE.
The condition is the value of field A (a Yes/No)

The app formula should be something like this? : IF field A = Yes THEN Calculate the value, ELSE Let user fill in the value.
However as far as I can figure out it cant be done using IF or IFS.

I tried using INITIAL VALUE. This works but it fails if THIS CONDITION changes afterwords.

Any ideas would be very welcome.

P.S. I have a plan B, but if I can make it work as described its the cleanest solution.

Kind regards,
Marcel

[MultiTech]

Marcel:

I tried using INITIAL VALUE. This works but it fails if THIS CONDITION changes afterwords.

Indeed it would, initial value is only calculated when the record is created - and there’s further restrictions as well; during the creation, if the field is visible and editable, and a user makes an edit to the field, then the initial value formula stops working and it’s forever after a manual field that users can change.

If you want something to be calculated automatically, all the time, you have to use the app formula.

For a hybrid scenario, like you’re wanting, you’ll need two columns:

1. an input column
2. the actual column to hold the end value.

Things get a little more complicated here, but basically you have the [Actual Value] column watch the [Input Value] column, and if there is something there use that - otherwise it can default back to a formula. Something like this:

if(isnotblank([Input Value]), [Input Value], enter_formula_here)

This way you’ve got a field that people can enter things into whenever they want, but you’ve always got the formula for the field to fall back on.

[Marcel1]

Thanks for your quick reply and solution.
I will try this in the next few day.

Kind regards,
Marcel