Concatenate users into a text field

[zsitvayb]

Hello,

I created a matrix, including two lists (tasks list and the built in users list) as dimensions and a boolean formatted line item in order to set write access for an other line item through the Write Access Driver. That part works, no issue with it.

But I want to list (concatenate) in a simple text formatted line item all the users who have been previously marked (through the booleans described above). Is there a way to this? So, as an output I'd like to see my tasks list and a line item including all the users.

The purpose is that every task in the tasks list might have several users with write access, and I want to list all users in one field who will have write access for each given task in the list.

[nathan_rudman]

Hi,

to concatenate lists items into text we use the function TEXTLIST.
I have not tested it with the user list though, expecting your results 🙂

[Harsha]

Hello,

TEXTLIST function cannot be used with USERS list. Its one of the constraint with TEXTLIST. 

May be you can create custom users list and use textlist function.

Thanks,

Harsha

[Harsha]

Hello, 

I have created custom user list and I got below results. Let me know if this what you wanted.

Source Module:

Target Module:

Thanks,
Harsha

[nathan_rudman]

learnt two things today:
- textlist doesn't work with Users
- read the doc I should

[Misbah]

@zsitvayb 

See if this helps

Step 1: Create a Fake Users list. This list will be pulled from System module of Native Users

Step 2: Create a module with Task List and Fake Users as dimensions and  two line items created as well.One Boolean and other Text 

           Boolean for Input

           Text for identifying the user

Step 3: Create another module with Just Task List as a dimension and one text formatted line item

[zsitvayb]

Thanks, this seems to be something I tried. I think I failed because of using the system user list in the textlist function.

Maybe, it's just too late for me and it should be obvious, but can you please elaborate a bit your below point of 

'Step 1: Create a Fake Users list. This list will be pulled from System module of Native Users'

I assume a fake users list that is being somehow synchronized with the native users list, but have no idea how to do it.

[Misbah]

@zsitvayb 

I called it Fake you can call it anything, Fake Users list is when you try to mimic the Native Users List. So how to create Fake Users list

Step 1: Create a System module with Users list as a dimension. Create one line item and get the Users by writing formula  ITEM(Users) in the line item.

Step 2: Create a list call it anything and Import the Users from System module of Users (Created in Step 1).

Your Fake User list is ready

[zsitvayb]

Thanks, that was clear. I just thought there is a way to have the fake list automatically sychronized with the native list instead of importing it from the module.

But then will try it out soon. 

[zsitvayb]

@Misbah

Sorry, one additional question:

If I use the fake user list, then how can I use this module to drive the write access for a line item?

I have no idea how to use the value of the boolean here that is linked to the task list/dummy user list in a module where I have the task list/native user list as dimensions.