How can I bulk populate a new field to the value of an existing field without database access?

Esther Strom_ ACP-JA

I'm an admin, but do not have direct access to the database to run SQL queries. Is there any other way I can bulk populate a new field with the value of an existing field?

 

Example: we have an Owner field that currently allows one name. We want to switch it to allow multiple names, but without database access, we can't change field types, so I've added a new field called Owners that's a multi-user picker. But we have hundreds of tickets, and updating them manually one by one would take way more time than I have. Is there any way to do the equivalent of this query, without database access?

UPDATE issue SET Owners = Owner

randyz

Hi Esther,

It will take some effort but totally do-able.

Here are the steps:

1) Create the new multi-user field and add it to the applicable project.

2) Use a list of the users populated in the original user field of the project then manually bulk edit(clone) the same user name onto the new multi-user field.

Best,

Randy