Copy row and add one to a number column

I’m trying to create a Grouped action. The first action copies the row and second action adds 1 to a number column but it seems not work. I think because I’m using the action ‘copy this row and edit the copy’ so its waiting for me to edit and save and that’s where the second action ‘set the value of some columns in this row’ is getting stuck and not triggering. Does anyone know a workaround or better way to do this?? Thank you in advance.

0 2 311
2 REPLIES 2

Anytime one of the actions in a group forwards the user to a new view, that has to be the last action in the group.

If you’re trying to create sequential serial numbers for each record (1,2,3,4…), I would suggest using an expression in the initial value field, like MAX(table[col]) + 1.

@Marc_Dillon I actually figured it out by using LINKTOFORM() but the MAX(table[col])+1 will be really useful for something else that I’m working on. Thank you very much for taking the time help out.

Top Labels in this Space