Skip to main content

Can I have a separate auto number for a different view?

  • September 21, 2020
  • 2 replies
  • 18 views

Forum|alt.badge.img+13
  • Known Participant
  • 62 replies

Can I have a separate auto number for a different view ?

So I can calculate the number of records in that view ?

2 replies

JonathanBowen
Forum|alt.badge.img+18
  • Inspiring
  • 1110 replies
  • September 23, 2020

Hi @Jay_P - no this won’t work. The Autonumber field type runs across the whole table, you can’t set it to only work on a view.

If you just want to know the number of records in a table or view, you can use the record counter in the bottom left corner of the base. This shows the number of records in the current view.


  • Known Participant
  • 14 replies
  • September 26, 2020

Hi @Jay_P - no this won’t work. The Autonumber field type runs across the whole table, you can’t set it to only work on a view.

If you just want to know the number of records in a table or view, you can use the record counter in the bottom left corner of the base. This shows the number of records in the current view.


Is there a function to list the serial number ( in sequential order) of the current record in the view ?