1. does anyone know of a good post for conditional formatting when entering information on a form? based on a boolean value for example?
2. is there a way to calculate and display the length of a field as a user is entering the information?
My situation connects the two questions:
Users are required to enter a 11 digit customer number which may contain zeroes at the front, so I want to show them as they are typing how many characters they have entered. My experience when collecting the data via spreadsheets is they often submit 10 digits either intentionally or unintentionally omitting the zero, so my manager wants to draw it to their attention this way.
I've used a calculated value control with the formula:
Recalculate formula on view mode: Yes
Recalculate formula on new mode: Yes
Recalculate formula on edit mode: Yes
However when I go into the form,
@emha this is an example of the "does it calculate now / when does it calculate?" question I was alluding to on the other post which you answered (and I'm still working my way through to answer properly, so please don't think i've not appreciated the time taken to answer my question).
It is not clear for someone coming from an excel background like me 'when stuff happens' which i know is terribly vague but just trying to get a handle so i stop pestering everyone.