Skip to main content

Using custom code to execute automatic numbering for sub-lists

Add sequential line numbers to an approval form’s Sub List and check how they change when rows are added, removed, or reordered.

Use a Custom Code control to number the visible rows of a Sub List on an approval form. The numbers follow the current order. Use a separate field for permanent identifiers such as purchase order numbers.


Step 1: Add a Sub List control

In the approval form designer, add a Sub List. Under Associated variable, note its Field ID. This example uses DetailsList as the ID and Purchase Details List as the display name. Configure a Sub List on an approval form

Open Fields → Settings and add a Text field. Use field_NO as its Field ID and NO as the display name. Select the checkbox to show the field, then move it to the first column.

Expand the NO column settings. In Table view, 50 px is a starting width. Check that the numbering fits on the screens your users need.

Under Control properties, open Settings for the NO text box and enable Readonly in Validation. This keeps users from typing over a generated number.


Step 2: Add a Custom code control

Add the Custom Code control from the Advanced group to the same form. Custom Code control

Paste the following script into Content. In an editable form, it skips removed rows and writes a sequence number to each remaining row.

codeInModules=function(t){var e={};function r(n){if(e[n])return e[n].exports;var o=e[n]={i:n,l:!1,exports:{}};return t[n].call(o.exports,o,o.exports,r),o.l=!0,o.exports}return r.m=t,r.c=e,r.d=function(t,e,n){r.o(t,e)||Object.defineProperty(t,e,{enumerable:!0,get:n})},r.r=function(t){"undefined"!=typeof Symbol&&Symbol.toStringTag&&Object.defineProperty(t,Symbol.toStringTag,{value:"Module"}),Object.defineProperty(t,"__esModule",{value:!0})},r.t=function(t,e){if(1&e&&(t=r(t)),8&e)return t;if(4&e&&"object"==typeof t&&t&&t.__esModule)return t;var n=Object.create(null);if(r.r(n),Object.defineProperty(n,"default",{enumerable:!0,value:t}),2&e&&"string"!=typeof t)for(var o in t)r.d(n,o,function(e){return t[e]}.bind(null,o));return n},r.n=function(t){var e=t&&t.__esModule?function(){return t.default}:function(){return t};return r.d(e,"a",e),e},r.o=function(t,e){return Object.prototype.hasOwnProperty.call(t,e)},r.p="",r(r.s=15)}({0:function(t,e,r){"use strict";Object.defineProperty(e,"__esModule",{value:!0}),e.MODULE_COMMON="common",e.MODULE_REQUEST="request",e.MODULE_MOMENT="moment",e.MODULE_BIZCHARTS="bizcharts",e.TEMP_VAR_PREFIX="__temp_",e.FILTER_VAR_PREFIX="__filter_",e.LIST_ROW_DELETE="_del"},1:function(t,e){t.exports=React},15:function(t,e,r){"use strict";var n,o=this&&this.__extends||(n=Object.setPrototypeOf||{__proto__:[]}instanceof Array&&function(t,e){t.__proto__=e}||function(t,e){for(var r in e)e.hasOwnProperty(r)&&(t[r]=e[r])},function(t,e){function r(){this.constructor=t}n(t,e),t.prototype=null===e?Object.create(e):(r.prototype=e.prototype,new r)}),i=this&&this.__read||function(t,e){var r="function"==typeof Symbol&&t[Symbol.iterator];if(!r)return t;var n,o,i=r.call(t),u=[];try{for(;(void 0===e||e-- >0)&&!(n=i.next()).done;)u.push(n.value)}catch(t){o={error:t}}finally{try{n&&!n.done&&(r=i.return)&&r.call(i)}finally{if(o)throw o.error}}return u},u=this&&this.__spread||function(){for(var t=[],e=0;e<arguments.length;e++)t=t.concat(i(arguments[e]));return t};Object.defineProperty(e,"__esModule",{value:!0});var c=r(1),a=r(0),s=function(){function t(){}return t.prototype.description=function(){return"Fill in sequence number in first column of a Sub List"},t.prototype.inputParameters=function(){return[{id:"listId",type:"string",desc:"Varaible ID of the Sub List, use to monitor the change of the list."},{id:"snField",type:"string",desc:"Field ID of Sub List to store sequence number."}]},t.prototype.requiredFields=function(t){return[t.listId]},t.prototype.render=function(t,e,r){return c.createElement(l,{data:e[t.params.listId],context:t,readonly:r})},t}();e.CodeInApplication=s;var l=function(t){function e(e,r){var n=t.call(this,e,r)||this;return console.log("Init addSeqNoToSubList..."),n.process(e),n}return o(e,t),e.prototype.process=function(t){var e=t.context,r=t.readonly,n=t.data;if(!r&&n&&n.length){var o=e.params,i=1,c=!1;n.forEach((function(t,r){t&&!t[a.LIST_ROW_DELETE]&&(e.setFieldValue(o.listId+"["+r+"]."+o.snField,i++),c=!0)})),c&&(this.cache=u(n),e.setFieldValue(o.listId,this.cache))}},e.prototype.componentWillReceiveProps=function(t){"data"in t&&t.data!==this.props.data&&t.data!==this.cache&&this.process(t)},e.prototype.render=function(){return null},e}(c.Component);e.ListChangeComp=l}});

In Input parameters, enter the two field IDs used by your form. Use the identifiers from the designer:

  • listId is the Field ID of the associated Sub List, such as DetailsList.

  • snField is the Field ID of the sequence-number column, such as field_NO.

Input parameters map listId to DetailsList and snField to field_NO.

Step 3: Preview and verify

In Preview, add three rows and check for 1, 2, 3. Delete the middle row and check for 1, 2. If reordering is available, move a row and check that the numbers follow the new order. Also preview an empty list and a read-only task form.

Purchase Details List preview shows sequential numbers in the first column.

Save and reopen a test request. Confirm that the sequence is in the intended column, the other detail fields kept their values, and the actual requester and reviewer roles behave as expected before you publish.

Did this answer your question?