I hope this email finds you well, Please let me know how to allow user to enter sequence number and the system does not accept duplicate numbers. I have a column named Number I want it should start from 1 for each org.
You’re welcome! Thank you! Would you please describe the use case further because it might help with finding a solution?
There is an option to use autogenerated values based on a TextPattern which has a function called SEQUENTIAL(); however, these autogenerated values are for Tracked Entity Attributes in a Tracker program. You are asking about a program rule so I believe you are using a tracker program so instead of using a data element you could use a tracked entity attribute. (In a TEA select ‘unique’ and an option will appear ‘automatically generated values’)