Skip to main content
BOOK A DEMO

Search

Visible Fields Expression

Sydney Berkowitz
  • Discussion Created

Hi,

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?

Thanks!

Sydney

0

Comments

1 comment

Date Votes
  • Henning

    I would try something like "=!![[MLPM1.OriginalValue]] || [[MLPM1.IsChanged]]", so that the field would show up either if it has an original value or it is changed.

    0

Please sign in to leave a comment.