Skip to main content

Calculated Fields as new custom field type

Follow
Marcelo Ramagem

It would be very powerful if we could create read-only calculated fields.... with the ability to calculate using other fields and/or universal things like current date or days remaining etc.

Examples:

* Add new custom field that calculates how many days an activity is overdue (today - due date)

* Add custom field with a "Expiration Date" and then another field that calculates how many days until thats "Expiration Date"

etc

The use cases are plentiful... many more than the two that come to mind right now.

9

Comments

11 comments

Date Votes
  • Official comment
    Team Salesmate

    Currently, we have workaround with use of LiquidJS functions you can update a field value via workflow based on calculations you need.

    Comment actions Permalink
  • Martin Lightbowne

    100% agreed

    0
    Comment actions Permalink
  • Amine H.

    You beat me to it. Def. needed, especially for companies who do quotes and need to calculate tax or gratuities automatically. +10000 Vote! :)

    2
    Comment actions Permalink
  • darb

    Very much needed.  Any response on this Salesmate?

    0
    Comment actions Permalink
  • Matthew Gibbons

    I too would like formula fields in Salesmate. My use case would be to add a custom field for Monthly Recurring Revenue and then add a Formula field that multiplies the value in my MRR field by 12 to give me my Annual Recurring Revenue for that customer. 

    0
    Comment actions Permalink
  • darb
    • Edited

    @Team Salesmate - are you able to build the fields for us?  This could maybe be a realistic workaround whilst you get a full solution sorted...

    1
    Comment actions Permalink
  • Matthew Gibbons

    This may be a workaround for some but not for the majority of customers who are not developers. I agree with Reid on this, Salesmate needs to build this functionality. This is pretty standard functionality in CRM solutions (I have had a lot of experience with various CRM providers). 

    0
    Comment actions Permalink
  • Team Salesmate

    We have started exploring details of Calculated Fields. Right now, we are figuring out the best way to allow users to create such fields. If you have any suggestions, then kindly share them with us.

    Meanwhile, if anyone helps achieve calculated fields using our Workflow or Automation Journey feature, feel free to reach out to the support over the chat.

    1
    Comment actions Permalink
  • Brent Earle

    I work in insurance and I represent over 20 carriers in each product line - life insurance, medicare, aca, etc. So, I have over 100 products to add to the system. 

    My comp rate is a % of the annual premium and each product will pay me a different %.

    I want to add all of my products with the carrier information and the comp % per my contract.  Then, when I complete a deal, I want to be able to enter the policy premium and have a calculated field show me the income based on that product's comp %.

    *Ideally, I'd like to be able to enter the monthly premium and have the deal annualize it in another field (x12) and then do the calculation above.*

    In my sales reports, I want to track the following:

    • Annual premium sold for the year / product line
    • Total comp / product line
    • Total comp for the year
    0
    Comment actions Permalink
  • General Inquiries

    I agree! this is very useful. I plan to use it to calculate a client's age from a DOB field, of course, must update automatically every year based on the DOB 

    0
    Comment actions Permalink
  • Will Whitaker

    Is there any update on this feature? If not, VERY important and I'd like an update on this. It should be able to be built using simple mathematical functions with existing fields as the variables.

    Example from my business: Loan Amount (deal price) is a field. Appraised Value is another custom field. I'd love to have a field called "Loan to Value" which is calculated by the (Loan Amount) / (Appraised Value).

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post