WE are looking at a counting field for our quote numbers so we can keep track of them. This would start with the year and then be a sequential number based on whatever the previous number used would be. so 17-0001 and then 17-0002 for the next one. Obviously it is a formula, but I am trying to figure out how to tie it all together.
Has anyone done this before?