Because of the referencing system that Notes uses for hide-when formulas, what
seems like a innocuous change can have devastating effects on the rest of the
To prevent this, make sure that all of the string literals for hide-when
formulas are unique. Notes only stores references for hide-when formulas that
have identical string literals to those above it. While this forces Notes to
calculate each hide-when individually, it also prevents referenced hide-whens
from affecting the rest of the form.
Given the following -
Line A hide-when: '@True'
Line B hide-when: '@False'
Line C hide-when: '@True'
To prevent C's hide-when from changing when A's hide-when changes, use-
Line A hide-when: '@True | "DDIL-4GJM95" '
Line B hide-when: '@False | "DDIL-4GJM9P" '
Line C hide-when: '@True | "DDIL-4GJM9Z" '
(The code at the end is generated using the @Unique function in a separate