Hello, I have created a UI action workspace form button that when clicked shows a pop-up with the assignment group and assigned to fields.
the first field correctly displays all group options in the sys_user_group table,
however, the "assign to" field is not displaying any users from the sys_user table, let alone those in the group selected above.
the pop-up will be used to assign both the group and a member in that selected group, all in the same pop-up, any solutions/suggestions are appreciated.
here is the workspace client script fyr:
var fields = [{
type: 'reference',
name: 'assignment_group',
label: 'Assignment Group',
reference: 'sys_user_group',
mandatory: true,
// this line was for testing purposes query: 'sys_id = e92db6cca8100f1c60f7a51d53ae009c',
referringTable: g_form.getTableName(),
referringRecordId: g_form.getUniqueValue(),
},
{
type: 'reference',
name: 'assigned_to',
label: 'Assign to',
reference: 'sys_user',
mandatory: true,
referringTable: g_form.getTableName(),
referringRecordId: g_form.getUniqueValue(),
},
];
g_modal.showFields({
title: "Select a user",
fields: fields,
size: 'lg'
}).then(function(fieldValues) {
g_form.setValue('assignment_group', fieldValues.updatedFields[0].value);
g_form.setValue('assigned_to', fieldValues.updatedFields[1].value);
g_form.save();
});
