Conditional Autonumber

[Niko_Gomez1]

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

3. 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 :slightly_smiling_face:

[ScottWorld]

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

[Kamille_Parks]

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

Update counter when action is triggered Automations

[Screen Shot 2021-07-13 at 12.17.11] [Screen Shot 2021-07-13 at 12.17.24] Hi, I’m a new user here and trying to create a basic order creation and tracking system. I have a field called Clients and another called client orders as attached above. Basically every time a user enters client name in the order tracking form, I need to generate a new order id in the format of. CUSTOMERNAME/1 and so the next time his name is added on the client order list it generates CUSTOMERNAME/2. I created a fie…

With this follow-up advice (which is also pointed out in the podcast episode linked above):

Update counter when action is triggered - problem when duplicating Base design

If your base is in a Pro workspace you can set the fake Autonumber field to have its permissions so no one can edit except Automations: [image] This way when you duplicate the record, the new record comes in with no field value. You could do that with a formula field: IF({Field A} = {Field B}, "yes", "no") Then have your automation filter for conditions where the formula outputs “yes”.

[Niko_Gomez1]

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