You need to sign in to do that
Don't have an account?
HNT_Neo
Currency and Percentage fields Validation Rule
I have 4 fields ranging in percentage and currency types (as shown below) that all will be required to contain a value prior to being saved.
Can someone assist in creating the VR for this one? Thanks!
Can someone assist in creating the VR for this one? Thanks!
I have just given the example below:-
IF( OR(ISBLANK( SitRate),ISBLANK(CloseRate),ISBLANK(RevenueJob),ISBLANK(GrossMargin)) , true, false)
Please just replace the field name in above VR with actual field API name from the insertfield picklist . Also give some error message like Please input the values for..... (whatever you like).
This will work.
Mark it as answer if it solves your problem.
All Answers
I have just given the example below:-
IF( OR(ISBLANK( SitRate),ISBLANK(CloseRate),ISBLANK(RevenueJob),ISBLANK(GrossMargin)) , true, false)
Please just replace the field name in above VR with actual field API name from the insertfield picklist . Also give some error message like Please input the values for..... (whatever you like).
This will work.
Mark it as answer if it solves your problem.
AND(NOT(ISBLANK(SitRate)),NOT(ISBLANK(CloseRate)),NOT(ISBLANK(RevenueJob)),NOT(ISBLANK(GrossMargin))). Replace Label Names with API Names .Keep the Error message in the Top.
Hope this Could be Helpful for you.
Mark tik if is helpful.
THanks
Dinesh
In the salesforceforce there is a multiple way to make required field.
You can use following any way as per your requirement.
1. At the time of field creation, you can check the check box name as “Required”. If you check this then this field will be always required while saving the record.
5. Fifth way is, if you are using Visualforce page and Apex class then it is very easy to do by apex coding. Check following example.