Skip to main content
Solved

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

  • June 23, 2021
  • 2 replies
  • 26 views

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.

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • 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
  • Author
  • Known Participant
  • 18 replies
  • June 24, 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.


Ok Thank you for the feedback