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.
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
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
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
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.
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
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.
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.