Stuggling to find the formula expression that allows me to ‘do nothing’ based on a flag.
Use should be able to enter data in the [Lectura] field. But, if he/she can’t enter the data, they should select the [Estimado?] flag to estimate the value of [Lectura]. But, if later, they get the actual data to enter, we need them to be able to deselect the [Estimado?] flag and enter normally.
I thought the following would work, but once the flag is ‘switched’, it doesn’t allow any entry into the [Lectura] field:
Formula Expresion: IF([Estimado?]=True, ([LecturaAnterior].[Lectura]+[LecturaAnterior].[Consumo]),[Lectura])
The view looks like this: [Lectura] doesn’t even show up on view initiation:
I can’t find anything online to help…