Questions tagged [isblank]
The isblank tag has no usage guidance.
31
questions
0
votes
0
answers
31
views
formula salesforce that includes isblank and 0 conditions
I have two conditions to include inside a formula field of type percent:
If Trained__C is empty, result should be 0%,
If Trained__c is equal to 0, result should be 20%,
Else, result should be equal ...
- 1
0
votes
1
answer
1k
views
ISNULL Flow Entry Criteria Not Working
I set up a simple flow with "All Conditions Are Met (AND)" with Field | Is Null | True. This should trigger whenever the lookup field is null. It triggers as it should but now I want to ...
- 2,551
0
votes
2
answers
489
views
No zeroes or blank in fields
I want that when they user move to Stage 1, they have to enter an amount for the MRR and ARR greater than zero(0) and not to leave it blank. I created this validation rule and even if I input an ...
- 11
-1
votes
1
answer
9k
views
Cannot reference a Long Text Area data type into a Formula Text field [closed]
Is there a way I can reference a long text area field to a formula text field?
I just need to check if my LongText field value is blank or not.
- 53
-2
votes
1
answer
1k
views
make a field required for a specific profile
I want to make the field deadline required if the user profile is Profile Bs , it not should be empty . (The deadline is a Date ) , but with this code is not working for me , I tried before the ...
0
votes
1
answer
51
views
Validation rule to be adjusted
Hello after adjustment of validation rule when I am creating contact with one of the profiles from the validation rule and insert mobile phone the validation rule still doesn't allow me to create a ...
- 13
0
votes
1
answer
5k
views
IF ISBLANK FORMULA
I'm trying to get a validation rule to check a Date Field called Triage_Stop_Time and if there is a value in the field it will make my Billing Picklist required with an error message "Required&...
- 3
0
votes
1
answer
397
views
Validation Rule for Account to request fields not to be blank to change Stage isnt working
This is my Validation Rule I do not understand where is the issue
If you are no admin, and CEO hasnt approoved it you shouldnt be able to change Account Stage without filling out infor for company ...
- 39
0
votes
1
answer
107
views
Exclude cases with blank recordtypes in process builder
I am trying to exclude cases with blank record type on the process builder that I've built, the process should not trigger a flow for cases with certain recordtypes and for cases with blank record ...
2
votes
0
answers
2k
views
ISBLANK not working properly in formula field in auto-launched Flow?
We have an auto-launched Flow that is called by a process builder. The PB passes in some record values into flow variables. We have a formula in the flow that uses ISBLANK to check these variables ...
- 7,390
1
vote
0
answers
588
views
ISNEW and ISBLANK not working together in Process Builder [duplicate]
I am using PB to check if the Case record is new, and if the Account field is Not blank and a Case.Account.picklist__c has a Certain value then update priority.
SO, my evaluation criteria are -
AND ...
0
votes
2
answers
1k
views
Completely remove <apex:outputText> string if the value is blank
I'm using this code now:
<apex:outputText rendered="{!NOT(ISBLANK(Description__c))}" value="{!Description__c}"/>
But sthis string is between another strings, and when I use this code, I'm ...
- 417
0
votes
1
answer
49
views
multiselect pick list custom field
I have a long if(includes formula that is aggregating a few common responses into the same text values. (It's longer than below but that is enough for my question). There are actually 3 outcomes I ...
- 9
-1
votes
1
answer
86
views
Question on Multiselect Picklist
I am trying to assign values to a multiselect picklist which also allows users to input a unique value (lots of values).
I would like to create a formula to assign a 1 to all values, and 0 to blank.
...
- 9
-1
votes
1
answer
832
views
Validating input and throwing error
So I have this field input in my UI, I need it to throw an error if it is left blank, but it is not. This is my code
<div class="slds-text-heading_medium slds-align_absolute-center">
&...
- 17
0
votes
1
answer
1k
views
How to display a field in the Lead layout only when the field is not blank?
In the lead object I need to display a custom text field on the lead page layout ONLY IF field is NOT blank. Is that feasible in Salesforce and how it can be achieved?
- 427
1
vote
1
answer
2k
views
Validation rule not firing if there are empty spaces in Long text area field
I have a validation rule that should fire whenever there is a value on field 'A' and the 'description' field Long Text Area(32000)) of case object is left blank.
This rule fires for manual cases but ...
- 55
1
vote
1
answer
115
views
Unexpected result in validation rule
I have a validation rules as follows:
a <> related__r.b
When a is null/or empty, the validation rule fails to trigger regardless of the value in b.
I fixed the logic with the following:
OR(a ...
- 518
1
vote
0
answers
65
views
Isblank in visualflow always returning the same value
My flow starts with a screen element that has two fields. Then it proceeds to a screen element that outputs both fields and two formulas. The formulas follow the format of ISBLANK(Field1) and again ...
- 1,196
0
votes
3
answers
5k
views
validation rule error Incorrect argument type for function 'ISBLANK()' [closed]
IF( ISBLANK( Close_Date__c ) ,
TODAY() - Open_Date__c ,
Close_Date__c - Open_Date__c )
1
vote
1
answer
783
views
Process Builder Entry Criteria Formula
I have the following entry criteria in the Process Builder
!ISBLANK([Material_Request__c].Out__c.Email_Address__c )&&
NOT(ISBLANK([Material_Request__c].Out__c) )&&
[...
- 361
0
votes
2
answers
2k
views
Validation rule: ISBLANK
I need to display an error when a checkbox(field1) is true , AND if either of field2 or field3 is blank. The formula below doesn't work.
AND(field1=true, ISBLANK(field2) II ISBLANK(field3))
Is ...
- 1
1
vote
2
answers
3k
views
Flow long text area input fields never seen as blank
I've got a flow screen with a long text area input field. No default value. Then I have a formula ISBLANK({!Field}) that always returns false. Why might this be happening?
- 1,196
3
votes
0
answers
337
views
Why is an empty apex:attribute neither null nor blank but still an empty string?
Consider this simple component:
<apex:component access="public" layout="none">
<apex:attribute name="myString" type="String" />
{!ISNULL(myString)} {!ISBLANK(myString)} {!...
- 2,551
2
votes
1
answer
356
views
Salesforce process builder - When removing active account from hierarchy, failed but works when added to hierarchy
I currently created a process which checks if a parent account is present, has been changed and checks if a parent field contains a certain value. If these conditions are met, update other fields in ...
- 21
1
vote
0
answers
3k
views
Using IsNull in flows on a formula text field
I read on this forum that we should use IsBlank for text fields, which I assume holds true to formula text fields. I'm not sure however that holds true for flows as I don't see the option for IsBlank.
...
- 21
2
votes
2
answers
1k
views
Receiving "System.StringException: Invalid id:" error even though the String that is being created checks for the scenario
For the following String creation within a trigger, I'm checking to see if the field is blank. If not, then it should use that field's value as the correct string, else, it should remain blank.
...
- 335
3
votes
3
answers
114
views
Valdiation Formula Broken
The scenario for the validation rule is:
-if one lookup field is empty, then check that other n fields are not empty
(if a lookup is empty, then make sure that the fields that will be used to create ...
- 747
2
votes
3
answers
14k
views
Check if list is empty
I have to check whether a list<Order> is empty or null.I can use isEmpty() to check this.
But Can I use isBlank() with list<Order> to check.
- 441
0
votes
3
answers
3k
views
Only modify field value if field is empty?
Short question: How can I can I update a field only if it is empty? I tried IF(ISBLANK('Enrollment_Date__c'),CloseDate) but it needs 3 parameters, I gave it 2. What can I put in the 3rd parameter that ...
- 1,613
50
votes
5
answers
178k
views
How to check in Apex if a Text field is blank
I'm unsure what's the shortest and most robust way to check whether a Text field is blank / empty?
/*1*/ Boolean isBlank = record.txt_Field__c == '';
/*2*/ Boolean isBlank = record.txt_Field__c == ...
- 38k