I need some help with a version formula. I have 2 types of formula

  • Version_ID (This number express the id of the Custom_object__c)
  • Progression_Version (This number express the progression of the Custom_object__c)

Table created with excel

enter image description here

Thank you for your attentions,

  • 2
    Hi @Maronno_mio, welcome to SFSE! Please take a moment to visit the help center and read How to Ask. – Martin Lezer Oct 22 '18 at 8:22
  • Thank you very much for the tips. (+1) – Maronno_mio Oct 22 '18 at 8:36
  • @Maronno_mio, your question is still not clear. You may want to clarify it more like is the formula you want is a custom formula field in Salesforce or something else and is the Progression version a field in your custom object? – Ashish Sharma Oct 22 '18 at 8:51
  • I need to create two formulas fields (Version_ID, Progression_Version). Version_ID express the id of the record. It doesn't change when I did a modify. Progression_Version express the Progression_version number when the record is modify. – Maronno_mio Oct 22 '18 at 9:34

You need two fields, but neither of them is actually a Salesforce Formula Field.

Version_ID__c should simply be an Auto Number field. You can set the Display Format to {0000} or similar to just show an incrementing number for each new record you create.

Progression_Version__c should be a simple Number field. You can increment this field by one each time the record is editing using either Process Builder (with the "prevent recursion" option turned on) or an Apex trigger.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.