Copying single select field value between tables with script

[Becky_Rosenthal]

We’re trying to write a script that will copy all of the records in a template table into a work table. One of the fields in the template table is a single select field, but we can’t seem to copy its value into the new table. We can create a query with the selected records and iterate through them, but can’t get the format right for the single select field.

In the following code, the first two fields copy fine, but we can’t find the correct format to copy the value of the single select field “CATEGORY”.

            fields: {
                'BUYER CHECKLIST': task.name,
                'SORT': task.getCellValue('SORT'),
                'CATEGORY': ???,
            }

Can anyone point us in the right direction?

Thanks!