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

12 views

4

12

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 Champions
customer service

Question

Updated

1 day

 

Comments

  • A

    Allison Fasching

    7 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

      7 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

        7 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

      10 days

      ago

      05/09/2025

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

      • C

        Cortney S

        10 days

        ago

        05/09/2025

        Thanks, Allison! It's an odd one. 

    • A

      Allison Fasching

      10 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

        10 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

    455 views

    Cristopher Cravioto Garcia responded 

    3 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

    455

    0

    K

    Karla Prado

    2 years

     ago

    296 views

    Prabhakar Kumar responded 

    1 year

     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

    8

    296

    0

    H

    Hernan Rodriguez

    1 year

     ago

    273 views

    Allison Fasching responded 

    2 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

    273

    0

    P

    paulo.henrique

    2 years

     ago

    126 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

    126

    0

    S

    samantha_nardi

    3 years

     ago

    133 views

    Jay Elango responded 

    3 years

     ago

    How can I adjust the widget dimensions in order to have a single one in one ppt slide? If I download my report dashboard as it is today, it looks weird. Collapsed columns, overlapping rows and I see only 5 lines out of 14 in total. Suggestions?  

    Sprinklr Marketing
    Analyze

    6

    133

    0