You need to sign in to do that
Don't have an account?
Oleg Nikitchuk
Problem with ISNEW() and PICKVAL
Hi everyone,
I need to create a validation rule: Deal__c.Status__c record can be created only with Status__c = Open.
Also, I need to make a formula: formula should display small photo of car type if Type__c selected and isValidForRent is true. In other case show default text instead - no car available.
I really struggle with this. The way I thought it should be made with valid rule is to use ISNEW() and with formula, I tried:
IF(
AND(
NOT(ISBLANK(Type__c)),
isValidForRent = true
),
IMAGE(image_url, alternate_text),
"No car available"
)
but it didn't work
Please, help!
I need to create a validation rule: Deal__c.Status__c record can be created only with Status__c = Open.
Also, I need to make a formula: formula should display small photo of car type if Type__c selected and isValidForRent is true. In other case show default text instead - no car available.
I really struggle with this. The way I thought it should be made with valid rule is to use ISNEW() and with formula, I tried:
IF(
AND(
NOT(ISBLANK(Type__c)),
isValidForRent = true
),
IMAGE(image_url, alternate_text),
"No car available"
)
but it didn't work
Please, help!
I assume that status__c is a picklist type field so try this for validation.
IF( ISNEW() && ISPICKVAL(Status__c, 'Open') ,false,true)
And for the formula field, I assume that Type__c is a text field. If Yes please try the below formula.
IF(ISBLANK(Type__c)&&isValidForRent,IMAGE(image_url,alternate_text),'No car available')