Announcement

Collapse
No announcement yet.

Email Template Help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Email Template Help

    Hi,

    Is there any possibility add calculation to email template.

    for an example, I want to get the count of cases pending for more than 7 days in to the email body.


    Dear User,

    You have got "10" pending cases more than 7 days in your pipeline

    Is the calculation or formula can be added to email body ?

    Cheers!
    Nishan.

  • #2
    Hi,

    Yes, it is possible,

    Just add custom fields to the target entity to hold the values, and write the formula to calculate them, and you will be able to use in the email.

    I think this is the easiest & best way.
    Last edited by eymen-elkum; 06-17-2020, 07:09 AM.
    CEO of Eblasoft
    EspoCRM Expert since 2014
    Full Stack Web Developer since 2008
    Creator of Numerous Successful Extensions & Projects​

    Comment


    • #3
      Haven't done email template calculation before, but I believe you would need to create an actual field first then insert that field (using Formula or something to calculate that first field).

      You can't just use Email Template then straight forward and do something like: {cost}*{quantity}

      You would need to have a new field first. For example {price}, then use Formula to calculate then in your email template you would do something like this.
      Price: {cost} x {quantity} = {price}

      Comment


      • #4
        Hi, Thanks for the replies. will try it out and let see the easiest way and the outcome.
        Cheers!
        Nishan.

        Comment

        Working...
        X