Our custom object has a property named “MRR”, that obviusly change over time.
I am looking for a way to create a property on same custom object that presents the max value seen of the MRR property.
Any ideas?
I have seen advise to use custom code action in workflows, but hope for a solution that do not requirre coding skills or perhaps a piece of code that can do the magic.
Hi @RAP_ELISA, I hope that you are well!
Thank you for reaching out to the Community!
The “max” feature is not natively present, so this would indeed require custom code.
Otherwise, as a workaround, you could add the custom property on the custom object index page (when clicking the “edit column”, you will be able to add the property), then at the top of the column, you can sort by ascending or descending order to see the max value for this property (see screenshot below).
Also, for you to know, there is a “max” option (that “displays the maximum value for the selected number property on all associated records of the selected object.”) if you create a calculated property based on properties of associated records, but this is not exactly what you are looking for I believe. Here is the article about it in case you are interested in it.
I’d like to ask some of our top experts on this: Hi @johnelmer, @SNigam and @Franci do you have any tips on how to achieve this, please?
Also, if anybody else has anything to add and/or share, please feel free to join in the conversation 
Thank you and have a great day!
Best,
Bérangère
Hi,
how I would do it.
I would add new Custom Property to Custom Object and name it Max MMR.
Set a workflow for this Custom Object, and set a trigger type “When an event occurs” → Property value changed and chose MMR
Whenever MMR will change I would run script with following logic
Get MMR
Get Max MMR
compare new MMR with Max MMR
if MMR > Max MMR
set new Max MMR with MMR value
if not bigger then do nothing.
If you need help with script let me know.
