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:

[kmeyer]

Any chance you could provide the updates together with the edits needed to make this work? I made some decent progress to have the field added to the form with correct reference to table. However when I click to submit the record is not produced. 

[litchick10]

The exact modifications I did are as listed...not sure why it isn't working for you. Perhaps there is a typo. 

[kmeyer]

All good. I think we are going to use the form as is and focus on leveraging the modules and categories to fit our needs. Appreciate the post to help those who need to customize the form!

[Mike D1]

Hi 

I am trying to do a similar solution now. I can see from my alert that the value is there on submit, however it is not being written to the field.

Even if I go to the the Idea Management Portal scripted rest resource and try to just add a string it still doesn't write that either:

ideaInfo.u_test = 'my test';

  Did you also need to update IMCreateEditIdeaDataServiceSNC API?

Thanks

Mike

[Mike D1]

Confirmed my own question. Made a copy of the API and edited this and now all is working.

Great post btw!