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:

[litchick10]

We are not currently using the edit functionality

[litchick10]

I have not tried to get it working as we don't allow edits. 

[litchick10]

As noted in the accepted solution, you are no longer able to add custom fields. I would recommend creating a record producer to generate ideas and removing the Idea form from the Idea Portal. 

[Ted19]

@litchick10  You mentioned you edited the api and script include, 

Do you mind sharing that part of information as well. 

I was able to have the value sent through the api , but I think the api isn't doing it's work. 

Thank you

[litchick10]

Script includes is called IMCreateEditIdeaDataService:

var IMCreateEditIdeaDataService = Class.create();

IMCreateEditIdeaDataService.prototype = Object.extendsObject(IMCreateEditIdeaDataServiceSNC, {
  
createIdea: function(ideaInfo) {
 //gs.log('ideaInfo: ' + JSON.stringify(ideaInfo), 'IdeaPortal');
 var newIdeaSysId;
 var ideaGr = new GlideRecord(this.ideaTableName);
 ideaGr.initialize();
 ideaGr.setNewGuidValue(ideaInfo.sysId); //Setting sys_id here so that to fetch related attachments
 ideaGr.module = ideaInfo.module;
 ideaGr.short_description = ideaInfo.title;
 ideaGr.idea_description = ideaInfo.description;
//added fields
 ideaGr.u_epic = ideaInfo.u_epic;
 ideaGr.u_collaborators = ideaInfo.u_collaborators;
 ideaGr.u_opened_for = ideaInfo.u_opened_for;
 ideaGr.u_business_unit = ideaInfo.u_business_unit;
//end add
 if(ideaGr.canCreate()) {
 newIdeaSysId = ideaGr.insert();
 //this.updateIdeaReferencesWithCategories(ideaInfo.categoryInfo,newIdeaSysId);
 this.createM2MReferencesForIdeaAndCategories(ideaInfo.categoryInfo,newIdeaSysId);
 this.updateEditorAttachments(ideaInfo.editorImages, newIdeaSysId);
 }

return {
 'sys_id': newIdeaSysId
 };
},
});

You have to copy the IMCreateEditIdeaDataServiceSNC and make the edits there