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:

[Laher Ghetla]

Hi Litchick10.

We have the similar requirement where we wanted a custom field on Idea portal which is a drop down and should write back to Idea table.

It did work in Tokyo but when we upgraded to vancouver its not working at all,.

Its like, if you try to pass the hardcoded value from widget's client script, it works, but does not take the actual values provided on front end from HTML code.

Do you have any solution?

[litchick10]

I haven't been able to get this to work after the upgrade. Sorry I can't help. 

[AbdulNow]

@litchick10  - Could you please let me know How you disable  the edit button in idea portal from that three dot in idea portal.

I could see that, there are 3 options (Edit,Delete and open in platform). We dont want to user to edit the idea in the portal. Please help! 

[Vikram3]

Hello,

Can you help me with this,
Add Priority field in Idea Portal - ServiceNow Community

[Nikesh5]

Are you able to get the custom fields on the form , when user selects edit idea option ??

For me system is only listing the fields which were OOB , my custom fields are not  getting listed for edit. Any leads on this will be really helpful