Hi all, I need to create a field that will calculate the number of records that have been created before the current record with a date in the same year. I can't use record ID# because those numbers keep climbing regardless of year, and the way our numbering system works, it starts at 1 again in a new year (formatted Job #19001, for example).
So I'm thinking the best way to accomplish this is with a field that displays the number of records created previously with a date in the same year as the current record, and then + 1 to whatever that number is.
Any ideas for the formula for this field?
Question
Field to calculate the number of records created before current record?
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.