Generate unique ID in child list based on ID in parent list

In parent list, create a hidden field which keeps track of the number of children. (childCount)

When a child gets created, increment the childCount field of the parent by 1, write it back to the parent and use this value to create the id.

Dear Tarf,

Would you please explain me a bit elaborative wtih steps if possible............................

Regards,

Hi,

1. Go to the parent list and add a new column.
   1. Name it childCount (or something)
   2. Type: Number, default value 0
2. Go to the child list and create a workflow
   1. Under Workflow Settings -  Start when items are created -> Yes
   2. Using a query list action, read the childCount from the linked parent and store it in a variable
   3. Using a math operation, increment the variable by 1
   4. Update the parent with the variable (which for the first child should then be 1)
   5. Generate the child id ( ParentElement-Title - variable) 

Regards

Hi Tarf,

My workflow as below

Math Operation

Update item in Parent list

Hi,

how is your query list configured?

I wouldn´t update the parent based on the childcount, because then childcounts would have to be unique for all parent elements.

It´s better to update based on the childs parent or by id (which you could get from the query list action)

Tarf,

Parent list query action as below and there is no filter

Regards,

Tarf, 

I am able to generate unique ID in child list but not able to update childCount in Parent list.

Child list

in Parent list childCount is blank, we need to update

Regards,

Hi,

you are connecting the Action Plans (Children) to their Risks (Parent) using a Lookup Column, correct?

If so:

1. Update your Query List Action to receive the parents childCount
   Filter: Where RiskID equals {Your Lookup Column}
2. Use the same filter to update the correct parent only
   Update Risks where RiskId equals {Your Lookup Column}

Tarf,

final workflow as follows

Update childCount in parent list (update item action as follows)

Still it is not updating

Hi,

in your Screenshot, the update item action is disabled. May this be the cause?

You could also update using the id of the element.

Should look like this then:

Tarf,

Now it is updating but it is not increasing, refer below screenshots, i have created two child items under parent item RISK-2020-1

Regards,

Hi,

are you sure your query list returns the current childcount?

The rest looks fine to me.

Try placing a "log to history" action and log the itemCount variable.

Also I saw in a earlier response, you were not filtering in the query list action, have you fixed that? You want the childCount from the parent element (using the same filter as in the update item section)