Sequence Number in a sub form

Follow

David Foner

• March 02, 2019 08:08

Hi , 

is there anyway to create some sort of a sequence number in a sub form ? I'm using NX 7

Dragging  the Seq number control into the sub form results in a message saying "coming soon:"

Thanks 

 

0

• 

  Karl Makatenas

  • March 04, 2019 15:20

  I don't know if this will suffice, but in the Configuration for the Subform control, you can show each entry's index:

  

  0

  Comment actions Permalink
• 

  Nik

  • March 04, 2019 15:23

  Is the purpose to give an index for the users (see Row Number above) or to create a unique ID for data storage?

  0

  Comment actions Permalink
• 

  David Foner

  • March 04, 2019 20:14

  Hi and thanks for the answers.  

  I guess that I need both... sorry for being greedy :)

  Mu situation is that I'm registering a complaint in a form and in a sub form I'm detailing the corrective actions which need to be taken . These corrective actions are then opened as separate tasks through a sub process and they have to be numbered, hence the need for the seq number.  
  The row number would be fine if I could use it in a formula to combine with the complaint number but I can't see this property listed anywhere.  
  
  

   

   

  0

  Comment actions Permalink
• 

  Karl Makatenas

  • March 04, 2019 21:37

  I threw together a bit of JavaScript back in the day to move the node containing the row number.  If you need to put just the row number in a field, you can probably skip the whole Show Row Number business and go straight to the jQuery indexing loop.  Here's a bit of untested code to start you on the right path.

  function AddRowNumberToField(thisField) {
    var index;
    for (var i = 0; i < thisField.parent().children().length; i++)
    {
      if (thisField === thisField.parent().children().eq(i))
      {
        index = i;
        break;
      }
    }
  
    var options = {fieldId: 'YourInternalFieldNameHere:[' + index + ']', value: index + 1};
    eFormHelper.setFieldValue(options, function(r){});
    }
  }
  
  Another options would be to ignore the indexing and re-create all row indexes on button click (add/remove/copy row).  I've had to use that a few times when I couldn't get the indexing to work.

  0

  Comment actions Permalink

Please sign in to leave a comment.