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

Syntax for cross-object references in valueexpressions.

  • August 6, 2020
  • 2 replies
  • 1098 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

    S
    ShawnMeAuthor
    New Participant
    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
    imgrundAccepted solution
    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

      imgrund
      imgrund
      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})

        Terms & ConditionsAccessibility statement

        Loading footer...