I am looking to create a formula where the autonumber resets based on the category code selected.
The autonumber cannot be reset contingent on the category code. The autonumber is unique to each row created.
I would like to have a way to be able to create codes that have the number after the prefix under Floor Plan ID show an autonumber based on the amount of items under that category.
it would be AC-1 opposed to AC-2 ( because there is only 1 item with the category code AC so far)
Any help would be appreciated!
Thank you :slightly_smiling_face:
@ScottWorld beat me to it!
The episode goes over two approaches, the first approach is likely the one you would go with; its less complicated and just requires a pretty straight-forward Automation. The use case the episode was based on came from this similar thread, wherein I wrote out the instructions:
With this follow-up advice (which is also pointed out in the podcast episode linked above):