Auto Numbering/Sequential Numbering Based on Other Field Values

Feature Requests
1

Hello, I can’t see any way of doing this currently in Softr Databsases but I have multiple similar use cases for Custom numbering based on other properties e.g. Project, Client etc

I am trying to create a projects database where I need to auto increment a field value based on values in other fields, similar to how the Auto number field works but with a varying prefix.

For example, I want to number records with the Project Prefix and then type of record or document, followed by an auto number, like:

E0001-RISK-001, E0001-RISK-002, and so on.

The current autonumber field doesn’t allow this, and I’ve had to manually input a sequential number in a separate column which can lead to mistakes and no way of auto generating the number.

This would be the same if we require contracts numbered by client e.g.:

CLIENT1_CONTRACT_001,

CLIENT1_CONTRACT_002

CLIENT2_CONTRACT_001

It would be great to have this feature to streamline the process. Any idea if this will be possible with a combination of formula field and workflows (once available)? I can obviously use the CONCATENATE formula for the prefix but can’t see a way of getting the sequential number to work based on the prefix?

1 Like
2

I would need something like this also. For example: One of my clients uses the App for Task management, which are coming in from customers. The customers call, a team creates the task and assign the co-workers to it. For this they want a numbering like 20250001, 20250002, … . But it should start from new when the year is changing. My workaround here for now is: If the Autonumber-fieldname is changed, it starts from new. This works for me for now but it would be greater, if you could customize the function. Especially in more advanced cases like depending on different records and relations.

1 Like