0

Prevent the reading of a field or reset it (make it null) if it is not displayed

I would like to know if it is possible that, when a field is not displayed thanks to a condition entered in the "Display this field only if" parameter, its value is not "active" or "taken into account".
I have formula fields containing several "if ... else" conditions which, depending on the fields read, give me such and such answers. Now, among the fields examined, some can be displayed or not according to certain conditions and if they are not displayed I would not like them to be taken into account. (Of course it would be enough to reset its value by hand, but I fear that future users will not think of checking if such or such field is null)

Thanks in advance for your help

Romain

2 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    wouldn't you set the if statement to only use the field if it matches the same condition for the field to be displayed?

     

    One possibility is to use variables in your formula. If field1 is set to only display if field0 != null

     

    then formula1 that uses filed1 would say something like:

     

    let cField1 := if field0 != null then field1

    cField1 + anothervariable

     

    hope this helps.

    • romdvlp
    • 3 yrs ago
    • Reported - view

    Hello Fred,

    Thank you for your response. I understand your idea, but I think it complicate the write of the formula with a lot conditions and it will not solve my problem. I thought there was a better and easier solution, but okay. I think I will descompose my formula in others smaller formulas.

    Romain

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 254Views