sypou

Auto-fill (field calculator) to populate field based on another sorted field

Discussion created by sypou on Jun 3, 2012
Latest reply on Jun 6, 2012 by sypou
Dear All,

Is it possible to auto fill a new field based on an another sorted field but not ID?

There was an article but it was based on ID and the issue was also raised there at Knowledge Base - Technical Articles

For example:

ID F1 F2
0   a  
1   d
2   c
3   a
4   b
...

Then I sort based on F1:

ID F1 F2
0   a  
3   a
4   b
2   c
1   d
...

Then I auto populate F2 (for example using field calculator)

ID F1 F2
0   a    1
3   a    2
4   b    3
2   c    4
1   d    5
...


Cheers,
Serge

Outcomes