Why do my custom Word reports keep repeating the same candidates?

Modified on Thu, 3 Feb, 2022 at 11:24 AM

The cause of the multiple lines for the same person is usually ‘multivalued’ items; fields where more than one value could be stored like education, pipeline statuses, addresses, languages, etc.


To get these to work, you need to either 

  • Just select the first item in the list by adding #*#1 before the closing bracket in the field name (you can include more items by changing it to #*#2, #*#3, etc).  For example, ${candidates.pipelineTags.text#*#1} will just give the most recent pipeline status.
  • Or put the field names into their own table, inside the table row you are using for the candidates.  This will then add a row to this ‘mini-table’ for every repeated row that the record has.  

For example (to show all the education items the candidate has):

 

${candidates.fullName}

${candidates.edus.degree} ${candidates.edus.field}

${candidates.edus.university}

 

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article