Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
Pablo Argentina Hi guys.
I'm sure that you can help me with this.
I have two fields.
1.- PICKLIST (values - win, negotiation, lost)
2.- numeric field (Amount)
Want to create something like:
IF PICKLIST VALUE = WIN, Amount should NOT be 0
The idea is that you can't choose win if you do not fill in the AMOUNT field.
Any idea?
Thanks in advance
Pablo
Are these the standard Stage and Amount fields on the Opportunity object?
If it is, then you don't need to bother with evaluating the Stage picklist, you can just say:
No, it's another NON standard object!!!
Okay, can you list the API Field Names then?
Something like this should do what you're looking for
SPICKVAL - Etapa__c (thisone should be WIN
Cantidad_Unidad_Solicitadas__c = amount shuld be different to 0
Thabks but no, still not working!!!
Can you copy&paste the VR that you are using and the picklist values as they appear in the picklist menu?
Pablo can you copy&paste the VR that you are using and the picklist values as they appear in the picklist menu like I asked? I have tested my VR on my DE org and it works with no errors, so I have to know how your SFDC Org is set up in order to troubleshoot this.
Sorry for the delay.
I don't understand what's the VR.
thanks
VR = Validation Rule
When you say the "it's not working" what is happening? are you getting a syntax error?
Are you all set or do you still need help with this?
No, actually i was working with this issue again. Not working, like nothing happens. No error message, but when i save it, nothing happens, i can set up the picklist as WIN with 0 values and it's OK!
Can you copy&paste the picklist values using the Printable View? If you are not getting a Syntax Error and the VR is not triggering a likely cause is that the value in your VR Formula does not match the Picklist options
I've tried changeing the formula like < 0.01 or < 0 or <> 0 and still not working.
The formula should trigger the message when it's ok or when it's wrong?
AND( ISPICKVAL(Etapa__c ,"Ganada"), Cantidad_Unidad_Solicitadas__c < 0.01 )
Picklist val:
Perdida
Ganada
En negociacion
----------------------------------
Perdida = Lost
Ganada = Win
En negociacion = negotiating
Cantidad_Unidad_Solicitadas = Quantity of requested Units
This formula will throw an error message if the user selects "Ganada" from the picklist and the quantity is less than 0.01
What is the datatype of the "Cantidad_Unidad_Solicitadas__c" field?
Can you post a screenshot of the VR Configuration screen?
I don't know how to paste an image, but i can tell you 2 things that can help:
Cantidad_Unidad_Solicitadas is a numeric field (4 digits)
But there's a message just next to the box were i should type the error message that says that this message will appear when the formula condition is TRUE
Is this ok??
You can take a screenshot and upload it to a secure file hosting site, like Flickr, Picasa, GoogleDocs, SlideShare, etc and paste a link to the URL of the image file
Yes, that is what you want
Pablo,
Are you all set with this or do you still need help?
are you all set or do you still need help with this?
Actually, no, never solved.
But i dimsiss whit it.
thanks anyway
Not for nuthin' but it would have been nice if you'd gotten back to me.