I just realized that I have multiple fields in my main data entry table that get values carried over from the Users table that will never be changed.
I’ve been using an expression like this in the Initial Value field:
LOOKUP(USEREMAIL(), “Users”, “USER_EMAIL”, "FAMILY_GROUP”)
Those values will always be what was entered in the Users table. So my question is, should I move the expression to the AppFormula and simply hide the column? I need them in this data entry table for ease of calculating various Required If, Show If, etc.
Does my question make sense?