Skip to main content
Solved

Is there a special field for column number in a view?


Michel_Billiau
Forum|alt.badge.img+7

Hi,
I would like to use the column number in a view in a formula.
Example : If a record is listed as 5th is a view, I would like to use the number 5 in a formula.
Is there an internal field giving me this number ?

PS If this exists, is there a list of internal fields that can be used ? like RECORD_ID, …

Best answer by kuovonne

No, formulas cannot access the row number of a record. A record could be in different rows in different views. The same goes for field order. Fields can be in different positions in different views.

You can see all the ‘internal fields’ in the formula field reference under the ‘Record functions’ heading. There aren’t many.

View original
This topic has been closed for replies.

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • June 23, 2021

No, formulas cannot access the row number of a record. A record could be in different rows in different views. The same goes for field order. Fields can be in different positions in different views.

You can see all the ‘internal fields’ in the formula field reference under the ‘Record functions’ heading. There aren’t many.


Michel_Billiau
Forum|alt.badge.img+7

No, formulas cannot access the row number of a record. A record could be in different rows in different views. The same goes for field order. Fields can be in different positions in different views.

You can see all the ‘internal fields’ in the formula field reference under the ‘Record functions’ heading. There aren’t many.


Ok Thank you for the feedback