Skip to main content
christinequick
christinequick
Level 3
August 17, 2026
Question

Validation logic for internal lookup field

  • August 17, 2026
  • 6 replies
  • 169 views

I’m trying to create display logic for a field based on the value of a single-select internal lookup field. Does anyone know the validation code I should use? I’ve tried all of these and nothing is working:

IF({DE:Lookup field}=”value1”, true)

IF({DE:Lookup field}.{name}=”value1”, true)

IF(CONTAINS(“value1”,{DE:Lookup field}), true)

IF(CONTAINS(“value1”,{DE:Lookup field}.{name}), true)

 

Thanks!

6 replies

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor
August 18, 2026

Would you mind confirming whether your textmode is using “smart quotes” or unformatted quote marks? The post automatically makes everything formatted so it’s difficult to tell whether you had them to begin with.

 

Also can you post a screenshot of the lookup field so we can see what the configuration on the field looks like?

christinequick
christinequickAuthor
Level 3
August 19, 2026

They are unformatted.  

Below is a screenshot of the configuration of the lookup field. It’s a single-select internal lookup field, looking at tasks on a project. 

The next field should dsiplay if one of the values (tasks) from the internal lookup field is selected. However, that logic isn’t working. The field is displaying at all times.

 

The exact expression I’m using is this (with unformatted quotes):

IF({DE:BRC Request2}.{name}=“Site issues & feedback",true)

 

BrookeSt5
Level 2
August 27, 2026

Try using the ID of the task instead of the name. I had a similar issue trying in Fusion trying to update an internal field. The name wouldn’t work but the ID field did.

 IF({DE:BRC Request2}.{ID} = “abc123…...",true)

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor
August 27, 2026

hi Christine,

 

here is my custom form setup -- there are two fields at the end of the form. One is the internal lookup and one is the field I am hiding.

 

 

My internal lookup is a single select task lookup with no filters. On my Sprint Text field, is display logic text that says,

IF({DE:CHAMP - Skye - Internal Lookup for Task}.{name}="Site issues & feedback", true)

 

This has the effect of hiding the Sprint Text field, until I type in and select Site issues & feedback in the Internal Lookup field. Your calculation is working as intended. If you’re continuing to have issues with it, I suggest submitting a Support ticket.

Terms & ConditionsAccessibility statement

Loading footer...