Skip to main content

Hello!


I am looking to create a formula where the autonumber resets based on the category code selected.




  1. Each product has an Item Number which is created using autonumber.

  2. I used another tab to create category codes for the prefix of the floor plan ID




  1. I create a formula that adds the prefx and item number to create Floor Plan ID


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 🙂

@Kamille_Parks discusses how to do this at length in this BuiltOnAir podcast:


@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):

Thank you both!, not on the pro plan but can get most of this accomplished.

Reply


Terms & Conditions