I am trying to give each record entry a unique numeric value that conforms to the following convention:
(Year - Month - Project number for the month)
As an example, for our 15th project this month, we would have the ID: 20-04-015. The project number resets to 0 at the beginning of each month, so in May the first project would be 20-05-000. The dashes aren't important here, I just included them for clarity -- I want this to be a numeric field.
I thought I could do this by making a field of type Formula - Numeric where I get the last field entry value and increment, but it doesn't look like I can actually pull the last field value.
Can someone please help me define a formula that will do this?
------------------------------
Cypress Beach
------------------------------
Question
Help with numeric formula field
This topic has been closed for replies.
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.