Idea Portal Widget IM Create/Edit - added fields not writing to table

[litchick10]

I have modified the IM Create/Edit widget by adding a field called "Opened For" that allows selection from the Sys_User table.  The problem is that the value is not writing to the idea table. Using an alert, I've determined that the value is "Undefined" so therefore cannot write to table. I don't know how to query the Sys_User table for the field to get the value.

I am Extremely new to widget development and am really struggling

Here are the changes made to the widget:

HTML added field:

<! --  Added Requested for Sys User Unit Selection -->   
      <label for="u_opened_for" 
             class="field-label" 
             title="{{data.label_hover_opened_for}}" 
             aria-label="{{::data.formModel._fields.u_opened_for.label}} "
             tooltip-right="true" 
                              {{::data.formModel._fields.u_opened_for.label}}
        </label>
        <sn-record-picker field="u_opened_for" 
                                table="'sys_user'" 
                                display-field="'name'" 
                                value-field="'sys_id'" 
                                search-fields="'name'" 
                                page-size="100" >

Server Script - added label only

//hover over 
data.label_hover_opened_for = "Are you submitting this for another associate or yourself";

data.messages.formLabels = {
'title': gs.getMessage('Title'),
'category': gs.getMessage('Category'),
'description': gs.getMessage('Description'),
'u_epic': gs.getMessage('Idea Details'),
'u_collaborators': gs.getMessage('Collaborators'),
'u_business_unit': gs.getMessage('Benefiting business line'),
'u_opened_for': gs.getMessage('Opened for')

Client Controller

   $scope.data.formModel = {
        _fields: {
// Add Opened for field
	u_opened_for: {
		label: $scope.data.messages.formLabels.u_opened_for,
		name: $scope.data.messages.formLabels.u_opened_for,
		stagedValue: ($scope.data.ideaInfo && $scope.data.ideaInfo.u_opened_for) || '',
		value: '',
		displayValue: '',
		type: 'reference',
		mandatory: true,
		mandatory_filled: function () {
		return !!($scope.data.formModel._fields.u_opened_for.stagedValue);
		},
		isMandatory: function () {
		return true;
		}
		},
  var _getRequestParams = function (formFields, widgetMode) {
        var requestParams = {};
        requestParams.sysparm_sys_id = $scope.data._attachmentTableSysId;
        requestParams.sysparm_u_opened_for = formFields.u_opened_for.stagedValue//does not work
   } 

I have updated the script includes/scripted rest api for idea to send the info from sys_parm_u_opened_for to table but because this value is undefined, it cannot write it.

Here is what form looks like:

[Juan Ignacio Z]

@litchick10 How are you? 😊

How did you edit since in my instance it appears as read-only ( Script Include: IMCreateEditIdeaDataService). On the other hand, in the field that you added u_opened_for, how do you add the filter so that it only brings active users.

Thank you very much for the contributions.

[nameera]

"IMCreateEditIdeaDataServiceSNC" script include is read-only. But you can add mappings to "IMCreateEditIdeaDataService"