Task Collection Text Mode | Community
Skip to main content
MoniqueEvans
MoniqueEvans
New Participant
September 9, 2022
Solved

Task Collection Text Mode

  • September 9, 2022
  • 2 replies
  • 853 views

I am once again coming to all of you to help me with the text mode for my task collection. I have a Project report and can successfully pull the task collection to show the name and planned completion date but whenever I attempt to also add the parent name I get an error. The closest I came is parent ID which of course is a hot mess, but here is that code:

valueexpression=IF({numberOfChildren}=0,CONCAT({parentID},'-',{name},' - ',{plannedCompletionDate}))
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 skyehansen

that's weird... API explorer implies {parent}.{name} should have worked... is this what's giving you the error?

2 replies

GrahamJarrett
GrahamJarrett
New Participant
September 12, 2022

You do not have a false statement for the IF condition

 

Try...

valueexpression=IF({numberOfChildren}=0,CONCAT({parentID},'-',{name},' - ',{plannedCompletionDate}),"")

    skyehansen
    skyehansenAccepted solution
    New Participant
    September 9, 2022

    that's weird... API explorer implies {parent}.{name} should have worked... is this what's giving you the error?

      MoniqueEvans
      MoniqueEvansAuthor
      New Participant
      September 12, 2022

      Thanks, Skye!! 100% human error, forgot the "."

      That's what I get for trying to be productive on a Friday

      Terms & ConditionsAccessibility statement

      Loading footer...