Help

Copying single select field value between tables with script

Topic Labels: Scripting extentions
1059 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Becky_Rosenthal
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0