fill code automatically

CarlosRod

I would like to be able to add members to a list but have the code fill in automatically. is this possible?

JaredDolich

@CarlosRod 

Great question. The answer is yes, but it's not super intuitive. Here's how I achieved the same feature, you might try this or modify it to suit your need:

• The code has to be unique, so we need a way to reliably create a new code.
• Create a system module for the list that you will be adding and add a line item that parses the existing codes for their numeric value. So, for instance if the code is "CODE001" we want to extract the "001" and convert it to a number, in this case a one (1). 
• Create a dimensionless module that grabs the MAX of that number.
• When your user creates a new list item, use an action, not a form. So in this case add a line item to your dimensionless module that allows the user to create as many new items as they want. This would be an editable, numerical value. I'll call this "n". You may have to add the USER dimension on this one if you have a lot of interest in creating new items.
• Create a list that has as the maximum number of list items a user might want to create.
• Add a line item in that list that has a list value starting with one (1), then two (2), etc.
• Add a line item that populates the the first "n" list items with the new codes starting with the MAX value you obtained earlier. Add the list value you created above. Concatenate any text you wish to that number to generate your code. Just make sure the numerical value of the code is easily parsed out.
• Create a saved view that filters out all the blank list items. So if the user creates 5 new list items, then your saved view should only show five list items.
• Use the saved view to create the new list items in your target list.

Hope that helps!