Hello! I am trying to solve the following problem:
I have a YES/NO field and that field causes other fields to be displayed based on what I select there. What I need is that if I select any of them, for example YES, and editable fields are displayed to which I add values, these values โโare cleared if I decide to choose โNOโ. Because I have noticed that if I select โNOโ and then touch YES again, the value is still there, it has not been cleared. It happens that these values โโare sometimes present and not shown, the problem is that these values โโare sometimes used for calculations.
I guess it would be something like a reset value but referred to the YES/NO column
Does anyone know how this is done?
I believe your expressions need to check for the YES/NO value using IF()
in order to determine what calculations to make and how.
Dos opciones.
IF()
para que los valores sean considerados solo cuando la columna YN estรก en YOscar, quisiera usar โReestablecer al editarโ pero ocurre que el valor que quiero reestablecer depende de otra celda. Creo que usarรฉ la segunda opciรณn. Intento y te cuento! Saludos. Muchas gracias.
Oscar, Iโm trying to solve the problem but I canโt.
I have a YES/NO column.
If you select YES, a number of editable fields are enabled and i can edit.
If I select NO, these editable fields are not reset but are left with the previously loaded values.
What I need is that when I choose one or the other option, the values โโare reset to the initial value automatically.
What Iโve tried to do is tell it to reset on edit:
Reset on edit:
OR(
[Column]=AND,
[Column]<>AND
)
Getting absolutely nothing. The values โโare still there.
Have you any idea?
Thanks!!!
You want a column to reset, if the value of your YES/NO column changes, is that correct?
Try this as reset_if:
[_THISROW_BEFORE].[yes/no column] <> [yes/no column]
Hola Marc, intentรฉ lo que dices. Quizรกs lo estaba haciendo mal. La soluciรณn que adoptรฉ es crear 4 columnas virtuales y seleccionar el valor que corresponde en funciรณn del valor SI independientemente de que si se reestablece o no!
Agradezco tu respuesta
We canโt know what you may have done wrong if you donโt show us what you did.
I donโt understand exactly what you did here, but adding virtual columns seems very unnecessary and a bad idea.
It would also help if you could confirm or deny my guess at your intention here.
User | Count |
---|---|
41 | |
25 | |
25 | |
16 | |
12 |