Rule condition question: Is it possible to create a condition for when a field is empty without using is not (select all)?
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.
Question
Updated
1 day
Comments
- 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:
- 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.
- 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.
- 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). 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:
- Navigate to the Rule Engine: Go to Platform Setup > Manage Rules.
- Create a New Rule: In the top-right corner, click Create New Rule.
- 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.
- 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.
- 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.
-
- Add your first condition:
- 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.
- 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
Jaimie Selwa
1 year
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
3
455
0
Karla Prado
2 years
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
8
296
0
Hernan Rodriguez
1 year
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!
7
273
0
paulo.henrique
2 years
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?
8
126
0
samantha_nardi
3 years
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?
6
133
0
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!