I would like to build an expression to hide the visibility of a field until the previous field has been selected. Once a selection occurs for the first field, the second field would pop up for the user to select.
Specifically, we have a "Jobs" list that includes the following contact card -
We would like "ML PM #2" to be hidden in the Display, New, and Edit forms until "ML PM #1" has been selected. The same goes for "ML Foreman #2" and "ML Foreman #3" - we would like "ML Foreman #2" to be hidden until "ML Foreman #1" has been selected, and "ML Foreman #3" to be hidden until "ML Foreman #2" has been selected. All of these fields are a cross-site lookup to a Contacts List.
I have tried using the formula "=[[MLPM1.IsChanged]]" (and similar for the Foreman fields), but we have come across a few issues with it in the Display and Edit forms. For example, if there is already a saved selection in the "ML PM #1" field, the edit form will not show the "ML PM #2" field unless you select and save a different choice in the "ML PM #1" field.
Is there a formula to put in the Visible Expressions configuration for the Display, New, and Edit forms for this issue?
Please sign in to leave a comment.