Syntax for cross-object references in valueexpressions. | Community
Skip to main content
S
ShawnMe
Level 3
August 6, 2020
Solved

Syntax for cross-object references in valueexpressions.

  • August 6, 2020
  • 2 replies
  • 1101 views

Hi,

I am trying to write an IF statement that enters either 1) the data from a task's custom field (Requester) or 2) the data from the same field on the project level. I can't find the syntax anywhere here or in the documentation.

I have tried

valueexpression=IF(ISEMPTY({DE:Requester}),{DE:project:Requester},{DE:Requester})

valueexpression=IF(ISEMPTY({DE:Requester}),{DE:project}:{DE:Requester},{DE:Requester})

valueexpression=IF(ISEMPTY({DE:Requester}),{project:DE:Requester},{DE:Requester})

valueexpression=IF(ISEMPTY({DE:Requester}),{project}:{DE:Requester},{DE:Requester})

and others that I probably shouldn't even admit to.

Is there a way to make this reference work?

Thanks

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by imgrund

    Interesting, I did a test in my enviroment with a field called Vantage Job Number and it worked fine. My calculation is

    displayname=Calculation

    textmode=true

    valueexpression=IF(ISBLANK({DE:Vantage Job Number}),{project}.{DE:Vantage Job Number},{DE:Vantage Job Number})

    valueformat=HTML

    Check your valueformat field. It should be HTML or string. Not customDataAsAString

    2 replies

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    August 6, 2020

    Hi - just out of curiosity, have you tried ISBLANK? That is what I usually use.

    Try this one:

    valueexpression=IF(ISBLANK({DE:Requester}),{project}:{DE:Requester},{DE:Requester})

      S
      ShawnMeAuthor
      Level 3
      August 6, 2020

      Argh. ISEMPTY is a remnant from my FileMaker days. Thanks for catching that, Anthony.

      Unfortunately, replacing ISEMPTY with ISBLANK did not make any of the listed expressions work. So something is wrong with the project:Requester syntax.

      imgrund
      Adobe Employee
      imgrundAdobe EmployeeAccepted solution
      Adobe Employee
      August 6, 2020

      Interesting, I did a test in my enviroment with a field called Vantage Job Number and it worked fine. My calculation is

      displayname=Calculation

      textmode=true

      valueexpression=IF(ISBLANK({DE:Vantage Job Number}),{project}.{DE:Vantage Job Number},{DE:Vantage Job Number})

      valueformat=HTML

      Check your valueformat field. It should be HTML or string. Not customDataAsAString

        Terms & ConditionsAccessibility statement

        Loading footer...