Sequential Number Field
I would like to be able to have a field which would automatically create a sequential number for newly created documents. Ideally, we could have multiple series of Sequential numbers based on Prefix. It could assign the Sequential number when Saved.
SOP-0001
SOP-0002
SOP-0003, etc,
as well as
TEC-0001,
TEC-0002
Comments
With the release 54 launched this week, the calculated fields feature is officially out of beta and can answer your request of creating sequential ID:
https://support.aodocs.com/hc/en-us/articles/360044323212-Getting-started-with-formulas-for-calculated-properties#h_b7da3f28-2292-46f8-8f5f-e8a8bbb818f9
I second this.
The ID number is enough for me, the prefix could easily be added in custom script, but I agree that the sequential ID feature is something missing and quite needed
Any updates on this?
Or any recommended ways to do it?
With the release 53 launched this week, we bring the first step of calcultated properties: https://youtu.be/JJLER2WGRpQ?t=147
Using calculated properties and the new sequence ID (unique to every document) will allow to create this ID of document that you suggested.
We are currently in a closed beta, if you are interested to join it, reach out to aodocs-beta@aodocs.com and we'll come back to you.
Hi Thibault,
Thanks for the update, but the request is not completed. As indicated in the original post, the numbering should be "based on Prefix" which is not the case with the sequence ID. This is a first step, but this is not yet a solution to the request, which still needs to be done by custom script today.
You can actually hard code or make your prefix configurable using the calculated properties, based for example on the document class. Check out this example here:
https://support.aodocs.com/hc/en-us/articles/360044323212-Getting-started-with-formulas-for-calculated-properties#h_eb607533-e326-4e20-8a70-e64f10abbba2
The sequence ID is not yet bound to the independent prefix but we are considering it.
Thibault, the issue is not the concatenation of the prefix and the ID, the issue is that the sequential number is independent of the prefix. If I use the example provide by Rob up there, if SOP/TEC are values of a category in a class, then what is needed is the following numbering:
SOP-0001
SOP-0002
SOP-0003
TEC-0001
TEC-0002
The Sequential ID will not provide this but only:
SOP-0001
SOP-0002
SOP-0003
TEC-0004
TEC-0005
Which is not the business need (at least not mine).
Dear Thibault,
Introducing SequenceID and Calculated Properties is interesting but does not enable to generate sequential "Chrono number" based on a set of properties, as demonstrated by Nicolas above, and requested by Rob in this thread.
Any chance this feature could be added soon ? Meanwhile, we have use a workaround with script and index class, which slows down the document creation process.
Thanks
Please sign in to leave a comment.