Skip to main content
ben
ben
Helper ⭐️⭐️⭐️
January 25, 2017
Question

Can you make a rule with a filter using the result of another field?

  • January 25, 2017
  • 4 replies
  • 62 views
Hey all,

We have a separate team, called "Account Specialists", that exclusively handle customer renewals. Each account is assigned a specific Account Specialist as well as the standard account owner (i.e. Customer Success role). The Account Specialist would be the individual that owns the Renewal opportunity for the account.

I am trying to create a rule that finds any Renewal opportunity record types where the owner of said opportunity does not match the Account Specialist assigned to the account (also a user lookup field). I am having trouble finding a way to use the result of a field as a criteria for another. Is that possible?

Thanks!

    4 replies

    kendra_mcclanahan
    kendra_mcclanahan
    Gainsight Employee ⭐️⭐️
    January 25, 2017
    Hi Ben,

    Hopefully I'm interpreting your question correctly. This is one way you may be able to accomplish the comparison.

    While you can't compare two fields in the filters, you can utilize the criteria in a rule action. You'll want to include both user lookup fields in the 'Show' area on the Rule Setup. Then you can compare the two fields in the action of the rule:



    What is the action you want to take when the Account Specialist doesn't match the Opp owner? 

    I hope this helps and let me know if I misinterpreted and you're looking to accomplish something different.
      ben
      benAuthor
      Helper ⭐️⭐️⭐️
      January 25, 2017
      Thanks Kendra. That is what I am looking for, but I now have a new road block. 



      Now I cannot seem to select other fields when attempting to do what you mentioned. Any way to get more in that list?
      -Ben
      smorrisgainsightcom
      smorrisgainsightcom
      Helper ⭐️⭐️⭐️
      January 25, 2017
      Hey Ben:

      You'd need to add any field you want to compare in the show area of the rule.  Another thing to keep in mind is the field types must match as well.  Let us know if you run into any issues.
        ben
        benAuthor
        Helper ⭐️⭐️⭐️
        January 25, 2017
        This was what I needed Scott! I was using two different field types. Once I lined that up, things were in place effectively. Thanks!
        -Ben
          Terms & ConditionsAccessibility statement