I need to put the portal row number into a field so that I can export it. I cannot use @@ as whilst it gives each row a number, you cannot export it. The sort order will always be exactly the same.

TIA

Edited September 28, 200619 yr by Guest

Create a dummy number field with auto increment from 1.

Then create a new calculation field called item.

If(Dummy=Dummy;0;0)+1+Case(Get ( PortalRowNumber );Get ( PortalRowNumber )-1;0)

Tks but this would only put a value of 1 in the field upon exporting. On the portal it would only show it if you clicked into it.

I have got around it by creating a script which does a count then numbers them in chronological order.

Tks anyway.