When you delete an item, force users to use a customized form Attach a workflow to your main list, when an item is added, and which will update alos REF_LISt field: REF_AVAILABLE=No for DOC-Reference=:COD_reference In your main list, use as lookup column DOc_REFERENCE (from ref_list ), and also add a new column name it COL_WILL_BE_DELETED ( type yes/no, default NO )
Is to create a new list ( ref_list) with columns like DOC-TYPE, DOC-REference, and REF_AVAILABLEĪnd REF_AVAILABLE, type yes, no, default Yesįill this new list with items for each doc types The easiest way ( isn't a dynamic one - you should know all doc types ) Then you can create your full ID with a bunch of statements - you'll need some tortured logic to make sure the NextNumber you have is 4 characters, but it can be done. Your 'NextNumber' will be ready for the next document. You want to do the update right away so you don't get 2 people In workflow (which starts on creation), get the proper record in your custom list, grab the NextNumber into a variable, then immediately update that same record, setting LastNumber = NextNumber. List would also have a LastNumber (number type), and a NextNumber (calculated field, =LastNumber+1)Įnter the beginning number for the series in the LastNumber field for all the records. Record per discipline will be good enough. If you have too many of those, then maybe one You'd have one record per discipline/doc type. Use the title field to hold the identifier of the type of discipline, for example, CC-01, AA-01. Not sure how many discipline/doc type combinations you'll haveĬustom List to control the next number (I called it Unique IDs). This is how I've done 'autoincrement' like what you need through a custom list and workflow.
0 kommentar(er)
