Case ID custom

💬 General Discussion
1

Hi all,

How can i custom the Case ID. I would like to custom the case ID with the parameter of date of creation. For example. Today is 2017-6-5, I would lik to generate the case ID number with 20170605000001. Can SuiteCRM perform such thing?

2

Hi,

I think simpliest is to Create a workflow action on case creation with a calculated field

https://suitecrm.com/wiki/index.php/Userguide#Calculate_Fields

Regards,
BM

3

Ok and thank you. However I check the function for the workflow. I unable to found the function to combine ‘DATE CREATION’ and ‘CASE NUMBER’ together

4

Hi Define case number as a parameter P0 then in your formula set:

{now(Ymd)}{P0}

as i understand you want the number after the date to start again from 1 every day and you might be interested by

GlobalCounterPerModule

GlobalCounterPerUserPerModule

ref: suitecrm.com/wiki/index.php/Userguide#Calculate_Fields

5

Thank you for your information

6

How can i create a condition for if the field is not empty?