Solved

Display array data as a comma separated list

  • 1 March 2022
  • 5 replies
  • 91 views
JimW

We have a use case where we need to display array data in a comma separated list rather than as table rows.

 

We're using an older version of Nintex DocGen 16.5.0.  The base object is a custom object and there is a lookup to another custom object that stores all of the participants tied to the base through a master/detail relationship.  So for each base object, we can have many participants.

 

We're interested in displaying the information like this:


Clients: Sally Jones, John Jones, Carol Star, Kathy Thomas

 

It would need to be a name followed by a comma and a space and then the next name. There should be no comma after the final item in the list.

 

Is there way to accomplish this in Nintex DocGen? Thank you for your help!

icon

Best answer by Brent_Doc 1 March 2022, 23:47

View original

5 replies

Brent_Doc
Userlevel 2
Badge +9

Hi @JimW 
This should be achievable using our Excel as Middleware / Connected Data feature. 
You would replicate the data in Excel, then use excel logic/functions to format it into a Single cell. Then Name the cell containing the formatted data and create a <<tag>> for the Word Document. 

We see this use-case a lot for emails on a Delivery option in the sample below:
Email use case: https://community.nintex.com/t5/How-To/Drawloop-Populate-Additional-To-email-field-dynamically/ta-p/204228

Connected Data: https://community.nintex.com/t5/How-To/Drawloop-Excel-as-middleware-Connected-Data-and-Named-Ranges/ta-p/120828

Hope this sends you down the desired output! let us know 🙂


JimW

Brent, this is very helpful.  I can see this being used for multiple use cases.  Thank you for the information!

JimW

@Brent_Doc,


First, just a quick update that it worked like a charm!  Thank you!  I do have a follow-up question.


For the single-cell named tag that we created, is that available in the field tagger anywhere or is it a manual process of adding it to our document templates?


Just curious.  Thank you again!


Jim

Brent_Doc
Userlevel 2
Badge +9

Hi @JimW 


 


Wonderful! Glad it worked!
For your followup questions about the <<Tag>>. No, it will not show up in the field tagger - it will be a manual process to note it in excel and create it in the output document.

I would recommend, if able, to either note the <<tag>> name next to the Cell containing the data or on a Separate Excel Sheet and note its location or formula to easily see the data from other sheets in one. This way you are able to find and validate easier if your excel document grows etc... 




JimW

Great suggestions.  We'll do just that.  Thank you again, @Brent_Doc.  Appreciate the help.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings