Rule condition question: Is it possible to create a condition for when a field is empty without using is not (select all)?
C

Cortney S

Published:

09/04/25 3:18 PM

29 views

5

29

I've discovered a situation where cases can be in the Assigned status, but the Assignee field is empty. I'd like to create a rule that will check for this and when it happens, update the Assignee field based on another (custom) field. My idea was to create a Queue rule that looks something like this: 
Condition: Is case in Assigned queue?
Y: Condition: Is Assignee field [empty]?
Y: Action: Copy [custom field: Last Engaged] to Assignee field

However, I'm somewhat stuck on if this is even possible. I feel like I may just be approaching this the wrong way. When I try to create the second condition, I'm not seeing a way to identify that the Assignee field has no value? If possible, I'd like to avoid doing "is not" and "Select All" because there's no possible way I'd remember to update that rule every time a user is added (unless "Select All" will auto-update as users are added?).

I'm also not really seeing action options like I'm looking for. 

Sprinklr User Network
customer service

Question

Updated

6 hours

 

Comments

  • S

    Scott Fletcher

    12 hours

    ago

    01/10/2025

    I understand that Cortney S wants to solve the immediate issue but this seems like a bug that should be fixed: a status Assigned should only ever mean that the case has an assignee. Have you logged to case to flag this as a defect?

    • A

      Allison Fasching

      23 days

      ago

      08/09/2025

      Happy to help!  I still have an internal question to our experts. If I get another answer I will definitely LYK!

      • A

        Allison Fasching

        23 days

        ago

        08/09/2025

        It is odd! It may require a support ticket.  😔

        Here's another way you might be able to achieve your results:

        1. Check for "is not" a queue. In some cases, you can set a condition like Assignee is not and then select a specific work queue or agent group that the case should be in. If the case is not assigned to one of these queues, the rule can proceed.
        2. Use a proxy field. If your organization uses a custom field that is always populated when a case is assigned, you can create a rule to check if that custom field is empty.
        3. Create a "Unassigned Cases" rule. If your automation is meant to catch unassigned cases, you can create a rule that catches all incoming cases and then has a No branch for the condition Case Assignee is [something]. Any cases that go down the No branch would be unassigned and trigger your desired action. 

        • C

          Cortney S

          23 days

          ago

          08/09/2025

          Oh, 3 might be workable- I'll explore that a bit more. If possible, I'd like to avoid adding users (user groups are fine, but so far the only options I've had are individual users- which just isn't sustainable for us). 


          I've changed permissions to prevent the field from being changed manually. So, in theory, this shouldn't even be a possibility, making a rule unnecessary (again, in theory, but I didn't think it was necessary from the start Crying with laughter ).  Thank you for all your help!

      • A

        Allison Fasching

        26 days

        ago

        05/09/2025

        Thanks for the details Cortney!  Let me run this past one of our experts!

        • C

          Cortney S

          26 days

          ago

          05/09/2025

          Thanks, Allison! It's an odd one. 

      • A

        Allison Fasching

        26 days

        ago

        05/09/2025

        Hi Cortney!  Your logic is on point: look for the Assigned queue, and if the Assignee field is blank, then do something about it. The one thing is that in Sprinklr, for a lot of field types, you can check if something’s empty just by leaving the value field blank. Sprinklr treats that as a check for null!  Here's a breakdown of the steps:

        1. Navigate to the Rule Engine: Go to Platform Setup > Manage Rules.
        2. Create a New Rule: In the top-right corner, click Create New Rule.
        3. Configure the basics:
          • Give the rule a clear name, such as "Assignee Correction Rule."
          • Set the Context to "Queue" since you want this to apply to messages in a specific queue.
          • Select an appropriate Rule Execution Batch (e.g., "Once per minute") and check the "Active" box.
        4. Set up the trigger:
          • Go to the "Manage Triggers" option within the rule.
          • Create a trigger that runs on new messages in your Assigned queue.
        5. Build the conditions:
          • Add your first condition:
            • Condition Applies to: "The properties of the Case attached to the message"
            • Condition: "Current Queue" is equal to [Your Assigned Queue Name]

          • Add your second, nested condition to check for the empty assignee:

            • Condition Applies to: "The properties of the Case attached to the message"

            • Condition: "Assignee" is equal to [leave the value field blank]

            • Explanation: For the "Assignee" field, simply leaving the value blank is the correct way to check if it has no value. When you save the rule, Sprinklr will interpret this as checking for a null or empty field.
        6. Add the action:
          • Attach a "Yes" branch to your second condition.
          • Click to Add Action.
          • Action Applies to: "Change properties of Case attached to the message"
          • Action:
            • Select the "Assignee" field.
            • Choose the "Copy property from another field" operator.
            • In the source field, select your custom field Last Engaged.
          • This action will copy the value from the "Last Engaged" field into the "Assignee" field.
        7. Save and activate:
          • Review your rule to make sure the logic is correct.
          • Click Save and then ensure the rule is active.
        • C

          Cortney S

          26 days

          ago

          05/09/2025

          That second condition is where I run into trouble. When I try to add it (Assignee is [nothing here]), I get an error that the rule failed to save. Or, it will save any other changes and only the other changes save on the canvas and the in the edit box. This seems to happen for most of the fields in the "Conditions Applies to The cases attached to the messages" where Is  or Is Not are the only options (I haven't tested all, but I did quite a few). I don't know if it is a bug or by design?

       
      Related Conversations
      JS

      Jaimie Selwa

      1 year

       ago

      459 views

      Cristopher Cravioto Garcia responded 

      4 months

       ago

      Hello, 👋 My name is Jaimie and I'm one of the Customer Advocacy Managers. Along with @Rupali Verma, we manage the Sprinklr Champions program. Welcome to the Community and our group! We'll use this space to share updates, executive opportunities, and gather feedback from you, our valued custome

      Sprinklr Champions

      3

      459

      0

      K

      Karla Prado

      2 years

       ago

      304 views

      Carlos Lara responded 

      8 days

       ago

      Hello everyone,I'm interested in integrating Sprinklr with Power BI to personalize my information. However, I haven't been able to find any documentation on the API itself. The only resources I came across were third-party platforms that require a fee for this integration. Has anyone successfully in

      Sprinklr Platform
      Integrations

      9

      304

      0

      H

      Hernan Rodriguez

      1 year

       ago

      284 views

      Allison Fasching responded 

      3 months

       ago

      Good morning, I am wondering if it is possible to add music or audio to an Instagram post. When I upload/schedule, I use the Quick Publish widget and I don't see it there. If it is currently not possible, I think it would be a really neat tool!

      Sprinklr Social
      Publishing
      Instagram
      support

      7

      284

      0

      JG

      Jordana Gustafson Wright

      1 year

       ago

      63 views

      Allison Fasching responded 

      2 days

       ago

      Hi Everyone! I wanted to share a success story we published a few weeks back with Deutsche Telekom. They're rolling out Sprinklr Service in their contact centers across Europe — they have a couple hundred agents already onboarded and expect to have 40k+ once the project is fully implemented. I loved

      Sprinklr Service

      8

      63

      0

      P

      paulo.henrique

      2 years

       ago

      129 views

      Jay Elango responded 

      2 years

       ago

      Estou criando uma apresentação e não entendo como ela está classificando por Classificar por. Seria possível ordenar alfabeticamente, ou criar alguma regra para esta ordenação?

      Sprinklr Platform
      Presentations

      8

      129

      0