Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 03, 2021 12:54 PM
Hello!
I am looking to create a formula where the autonumber resets based on the category code selected.
Issue
The autonumber cannot be reset contingent on the category code. The autonumber is unique to each row created.
End Result
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.
IE:
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:
Nov 03, 2021 01:26 PM
@Kamille_Parks discusses how to do this at length in this BuiltOnAir podcast:
Nov 03, 2021 01:30 PM
@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):
Nov 04, 2021 11:29 AM
Thank you both!, not on the pro plan but can get most of this accomplished.