User list fields in Pipeline
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. Both User Lists fie...
Forum Discussion
I had a similar requirement. Below is what worked for me.
Warning: Test is a non-production environment. I temporarily 'broke' my target table on my first attempt. This was due to the second user list being empty for a record. The ';' separator was added at the end of the user list and Quickbase couldn't parse it.
In the jinja, lista and listb are separate user lists. A record may not have data in listb; therefore, I'm checking for that before joining lista and listb.
Additional checks may be required if what is comparable to lista may not have data.
{% if a.listb is not none %}{{([ a.lista| map(attribute="email")|join(";"),a.listb| map(attribute="email")|join(";")])|join(";")}}{% else %}{{a.lista|map(attribute="email")|join(";")}}{% endif %}