User list fields in Pipeline

Question

Good afternoon,I've created a pipeline that searches Table A for criteria and if it matches it will copy a User List field from Table B to another User List field in Table A.&nbsp; &nbsp; Both User Lists fields could have multiple Users selected when the pipeline runs.&nbsp; &nbsp;My first attempt wiped out any information already listed in Table A's field with the information copied from Table B, but it listed all Users that were selected.&nbsp;When trying to figure out how to keep the information in Table A's field while adding the information from Table B, I then found the community thread which is similar to what I'm trying to do:&nbsp; https://community.quickbase.com/discussions/getting-started/using-multi-select-field-in-pipelines/18991&nbsp;However, when I enter&nbsp; {{table B User List field}} ; {{table A User List Field}}&nbsp; Table A's information remains, but the new information copied are placeholders rather than the User name.&nbsp; &nbsp;So it looks like&nbsp;When I've attempted to use the ID or Email from the User List (as found recommended in other threads)&nbsp;It keeps Table A's information but only lists the first User from Table B.&nbsp; &nbsp;Any other User is not copied over.&nbsp; &nbsp; &nbsp;Any suggestions on how to get the placeholders to actual show the User Names?&nbsp; &nbsp;

mez · Answer

Do both user list fields use the same User data? This might be part of the hiccup for the placeholders. Also, have you tried using the join function in pipelines to marry these two sources of data? It would like something like this:

{{ [ tableA.userList, tableB.userList ] | join(";") }}

kelly-anntainto · Answer

I have attempted a few variations of join, but not the one you suggested.&nbsp; However, when I plug it in with the brackets ([ ]) and without, it gives an error.&nbsp;&nbsp;&nbsp;

mez · Answer

Ok, two things: 1. use email property of these list user fields: "c.assigned_test.email". 2. use lower case 'join()' - and remove the trailing space after the semicolon:&nbsp;join(";").

Forum Discussion

User list fields in Pipeline

3 Replies

Related Content

Managing your User Access and Apps

Three Words of Advice on Pipelines

Create child records from Parent List - User field

Three Words of Advice on Building Pipelines - Brittany Scheid

Pipeline - Add Year from Record Created to a field